Menu

Search

Preparing Data for Analytics with Power Query in Excel

Microsoft Excel Analytics for Business Professionals
Instructor:
Bliva TangerynTech
1,474 students enrolled
English [Auto]
Clean your Data using EDA techniques
Transform data using Power Query.
Analysing large datasets using PivotTables
Summarise your data

In the Professional Data Analytics Training in Excel course, you will embark on a comprehensive journey through the powerful features of Microsoft Excel, a leading tool in data analytics. The course begins with an introduction to Microsoft Excel and an exploration of its key features. You will then gain proficiency in Excel functions and formulas, essential for performing calculations and data manipulations. The program goes on to cover working with data in Excel, connecting to external databases, and engaging in advanced data cleaning and transformation using Power Query. Furthermore, a significant portion of the course is devoted to exploratory data analysis using PivotTables, which are instrumental in summarizing and analyzing large datasets. The course concludes with a focus on data modeling and analysis using Power Pivot, empowering you to create complex data models and perform advanced analytics. This course is designed for people who want to use Excel for professional data analysis.

Course Overview:

  • Beginner to Pro

  • No prior knowledge or experience in business intelligence and analytics is required. The course is designed for beginners who are interested in learning about these fields.

  • Students will have unlimited access to course materials even after the training ends.

  • Downloadable content

  • Hands-on exercises

Note: This comprehensive training program is structured into six key parts, each designed to enhance your proficiency with Microsoft Excel.

Introduction

1
Excel Interface Walkthrough

Kindly note that, the sample data used in the lesson, is different from the downloadable excel file. This is to help challenge your problem solving skills as you follow along the course.

1: PREPARING DATA FOR ANALYSIS-Excel

1
PREPARING DATA FOR ANALYSIS 1

2: PREPARING DATA FOR ANALYSIS-Excel

1
PREPARING DATA FOR ANALYSIS 2

3: PREPARING DATA FOR ANALYSIS-Excel

1
PREPARING DATA FOR ANALYSIS 3

4: PREPARING DATA FOR ANALYSIS-Excel

1
PREPARING DATA FOR ANALYSIS 4

5: PREPARING DATA FOR ANALYSIS 5

1
PREPARING DATA FOR ANALYSIS 5

6: PREPARING DATA FOR ANALYSIS-Excel

1
PREPARING DATA FOR ANALYSIS 6

7: PREPARING DATA FOR ANALYSIS-Excel

1
PREPARING DATA FOR ANALYSIS 7
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!

Be the first to add a review.

Please, login to leave a review
9b23bdbcbf9de905d5c065ccb90917e0
FREE For First 1000 Enrolls

Includes

1 hours on-demand video
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW