FREE 4 Hours Complete Excel Course

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/

Close Menu