Experience Microsoft Excel like never before with our comprehensive 120-minute course, Microsoft Excel: Master Power Query in 120 Minutes. Advanced data manipulation techniques are introduced in the first module, which covers the fundamentals of Power Query in Microsoft Excel. The ability to effectively transform data in Microsoft Excel is a crucial skill for every data analyst, and it will be covered in this course. This is a major topic covered in Module 2.
The middle modules, “From Folder” and “From Workbook,” guide you through integrating multiple data sources in Microsoft Excel. This knowledge is crucial for handling real-world data scenarios where information is scattered across different files and formats. Module 05, “Joins,” takes you deeper into Microsoft Excel’s capabilities, teaching you to merge data from various sources seamlessly.
The last module solidifies your understanding of Power Query in Microsoft Excel, enabling you to tackle challenging data projects. By the time this course ends, you will be able to manipulate and analyse data like an expert because of your newfound expertise with Microsoft Excel.
Learning outcome
Grasp the fundamentals of Power Query in Microsoft Excel.
Transform data effectively using Microsoft Excel.
Integrate data from folders using Microsoft Excel tools.
Merge information from multiple workbooks in Microsoft Excel.
Master various joins in Microsoft Excel for comprehensive data analysis.
Develop advanced Power Query skills in Microsoft Excel.
Enhance data handling and analytical skills in Microsoft Excel.
Become proficient in Power Query, a vital Microsoft Excel feature.
Learn data transformation techniques in Microsoft Excel for better analysis.
Master integrating diverse data sources in Microsoft Excel.
Gain expertise in advanced data manipulation using Microsoft Excel.
Boost your career prospects with Microsoft Excel skills.
Career Path
Data Analyst
Financial Analyst
Business Intelligence Developer
Research Analyst
Marketing Analyst
Operations Manager
Project Coordinator
Requirements
No formal qualifications required, anyone from any academic background can take this course.
Access to a computer or digital device with internet connectivity.
Course Curriculum
Course Curriculum
Module 01: Introduction
Power Query Intro and Excel version
00:03:00
Excel Power Query – Introduction
00:03:00
Excel Power Query – Query Editor Ribbon
00:09:00
Module 02: Transform Data
Transform Data – Trim in Excel Power Query
00:05:00
Transform Data – Format Dates and Values in Excel Power Query
00:02:00
Transform Data – Parsing URLs in Excel Power Query
00:05:00
Transform Data – Split Text Fields in Excel Power Query
00:10:00
Transform Data – Group By in Excel Power Query
00:03:00
Transform Data – Unpivoting Columns in Excel Power Query
00:05:00
Transform Data – Pivoting Columns in Excel Power Query
00:02:00
Transform Data – Split Columns into Other Columns in Excel Power Query
00:04:00
Transform Data – Filtering Rows in Excel Power Query
00:05:00
Transform Data – Sorting Columns in Excel Power Query
00:02:00
Transform Data – Transform and Add Columns in Excel Power Query
00:07:00
Module 03: From Folder
From Folder – Import From Folder in Excel Power Query
00:07:00
From Folder – Doing Auto Cleanup in Excel Power Query
00:13:00
From Folder – Extract Data from Forms in Excel Power Query
00:13:00
Module 04: From Workbook
From Workbook – Extract Multiple Criteria in Excel Power Query
00:05:00
From Workbook – Extract Multiple Worksheets in Excel Power Query
00:04:00
Module 05: Joins
Joins – Intro to Joins
00:04:00
Joins – Merging
00:08:00
Joins – Full Outer Join
00:06:00
Joins – Right Anti Join
00:09:00
Module 06: Power Query
Power Query – Convert Reports into Pivot Tables
00:05:00
Modulo
00:06:00
Don't just take our word for it
Amazing workshop.
Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.
Aarini Sinha
It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.
Varsha Sivamohan
I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.
Judith Taylor
The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable.
I am very grateful for the support
Charlie Anderson
Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it.
Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.
Parmjit Dosanjh
I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.
Shan
I was a bit nervous about the course but I gave a try,it's perfect and I still can't believe I paid a peanut to acquire such a course,the sliding show and introduction was well understood.i will recommend skill up to anyone interested to persuade a meaningful career,and also to the support team keep doing the good work.💪
Sara Nana
$457.31Original price was: $457.31.$34.75Current price is: $34.75.
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.