FREE 4 Hours Complete Excel Course
Here is a FREE, complete end-to-end Excel course to help you learn all the key and essential aspects of Microsoft Excel for Data Analysis work.
ย

ย
What you will learn:
- How to use MS Excel
- Working with Power Query to automatically clean data
- Data load from Web pages, CSV files & Excel files
- Adding columns with new calculations
- Replacing “blank” or “null” values
- Data quality checks
- Splitting names into first & last names
- Working with dates in Power Query
- Using Important Excel Functions & Formulas
- Using references in Excel
- SUMIFS, COUNTIFS formulas
- Statistical Analysis of Data with Excel formulas
- FILTER function
- Lookup functions – VLOOKUP, INDEX+MATCH, XLOOKUP
- Combining functions (nesting) to solve problems
- Working with Excel Pivot Tables
- Creating Pivot tables
- Sorting & filtering pivots
- Slicers & timelines with Pivots
- Grouping data with Pivots
- Pivot charts, Interactive charts
- Complete Excel Project
- Creating a call center dashboard
Download the files ?
Download the Files 
Please enter your name & email address so I can send the files to you.
Watch the Video
Here is the 4 hour course video. Please watch it below or on my YouTube channel – 4 hour Excel complete course video.
Additional Resources 
Power Query
- Deep introduction and examples on Power Query
- Extract common values between tables with PQ
- Combine multiple files with PQ
- SQL vs. Power Query: Ultimate Comparison
XL Formulas
- Excel Cell References
- Structural References (Excel table formulas)
- SUMIFS
- SUBTOTAL
- VLOOKUP
- INDEX + MATCH
- XLOOKUP
- FILTER
- Dynamic Array Formulas
XL Pivot Tables
- Excel Pivot Tables – Complete Guide
- Advanced Pivot Table Tricks
- Connecting Two Tables in Excel Pivots
- How to make pivot when you data in multiple sheets
- Working with Excel Slicers
XL Dashboards
- 5 Step process to make Excel Dashboards
- Excel Dashboards – Complete Guide
- 200+ Excel Dashboard Examples
The post FREE 4 Hours Complete Excel Course appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.
Original source: https://chandoo.org/wp/complete-excel-course-free/