Excel Power Query
Learn the key tool to remain competitive and become dramatically important for every company in today’s world.
Contents & Schedule
Inhalte & Ablauf
Contenido y procedimiento
01. Einleitung:
01. Introduction:
01. Introducción:
As part of the introduction, you'll get an introduction to the basics of Excel Power Query, get a brief context, and learn how you can use Power Queryin a professional context.
02. Theoretische Grundlagen:
02. Fundamentos teóricos:
02. Theoretical foundations:
Subsequently, the theoretical basics of Excel Power Query will be covered. Here you will learn, among other things:
Introduction to Power Query:
- What is Power Query and why it's the best Excel feature since Pivot Tables!
- Importing from CSV and TXT
- Importing data from SQL
- Importing multiple files from a folder
03. Praktische Anwendung:
03. Practical application:
03. Aplicación práctica:
This part of the webinar is about the practical application of Power Query in a professional context. The following contents will be covered here:
Data Transformations:
- Filter, Replace, trim, delete, combine, split etc
- Changing data types
Combining data:
- Appending data
- Merging data
Advanced use of Power Query:
- Duplicating queries in Power Query
- Using Parameters in Power Query
- Using M Query language
- Pivoting data
- Loading to different destinations
- Automatic refreshing
Using our Power Query output in Pivot Tables
04. Q&A + Möglichkeit zur Zertifizierung:
04. Q&A & Ausleitung:
04. Sesión de Q&A y Salida:
04. Q&A + Posibilidad de certificación:
04. Q&A Session and ending:
04. Possibility of certification + Q&A:
At the end of the webinar, you will have the opportunity to discuss all your questions with the coach in a live interactive format and get direct answers. Our clear goal is that you take away no unanswered questions from the webinar and have a good understanding of the basics of Excel Power Query and how to implement it in a professional context.
You will have the opportunity to certify your knowledge after this webinar.
Description:
Are you a student or young professional looking to boost your career? Take advantage of this free two-hour webinar that will teach you how to use Excel Power Query! This webinar will provide you with the tools you need to help you advance your career and reach your goals. With this webinar, you'll learn how to quickly and easily find, connect, and transform data using Power Query's powerful capabilities. Don't wait, sign up today and get the skills and knowledge you need to succeed!
Why you should learn Excel Power Query?
Students and young professionals should learn Excel Power Query to give them a competitive edge. With Power Query, you can quickly and easily combine data from multiple sources and transform it into meaningful and useful insights. This can help you make more informed decisions, stay organized, and increase your productivity. Power Query also allows you to create visualizations that can help you communicate your data more effectively. Learning Excel Power Query will help you stand out from the crowd and give you the skills you need to excel in your field.
What can you earn with this skill?
- Average income for young professionals and freelancers in data analytics can vary widely depending on experience, geographic location, and the type of work
- According to Payscale, the average salary for entry-level data analysts is $55,000 per year in the United States
- Average salary for more experienced professionals is around $81,000 per year
- Freelance rates can range from $45 to $90 per hour depending on the scope of the project and the analyst's level of experience
- With the right skills and experience, data analysts can earn significantly more than the average salary
Why this skill will become more and more important in the future?
Learning Excel Power Query will become increasingly important for young professionals and students in the future, as the data-driven world continues to grow. Data analysis and insights will be key for many industries and roles, and those who are skilled in Excel Power Query will have an edge when it comes to finding and analyzing data more efficiently. Having the skills and knowledge to work with data quickly and accurately will be a great asset in the future job market, and learning Excel Power Query now will give you a head start.
Who is the webinar suitable for?
- People with an interest in handling Data and / or Excel
- Young professionals who want to expand their skillset
- People with an interest in learning new things
- People who would like to further their education
What are the technical requirements?
- Excel should be Installed before the Webinar
- A stable internet connection
- An Internet-enabled device (we recommend a computer, laptop or tablet)
Werde Teil der ELEVEL Skill Community!
Join the ELEVEL Skill Community!
Forma parte de la ELEVEL Skill Community!
Exklusive Inhalte, Q&A Sessions und Communities
Unser ELEVEL Discord-Server hilft dir, deine Ziele zu erreichen und dich mit Gleichgesinnten aus der ganzen Welt zu vernetzen. Mach mit und erhalte Zugang zu einer Vielzahl von exklusiven Inhalten, Ressourcen und Communities, die dir dabei helfen, die Skills zu entwickeln, die du für deinen Erfolg brauchst. Trete jetzt bei und profitiere!
Contenido exclusivo, sesiones de Q&A y comunidades
Nuestro servidor de Discord de ELEVEL te ayuda a alcanzar tus objetivos y a conectar con personas afines de todo el mundo. Únete y accede a una gran variedad de contenidos exclusivos, recursos y comunidades que te ayudarán a desarrollar las habilidades que necesitas para triunfar. ¡Únete ahora y benefíciate!
Exclusive content, Q&A sessions, and communities
Our ELEVEL Discord server helps you achieve your goals and connect with like-minded people from around the world. Join and get access to a variety of exclusive content, resources and communities that will help you develop the skills you need to succeed. Join now and start benefiting!
