Zero to Hero in Microsoft Excel: Complete Excel guide 2025

$0.99
Instructor:
Start-Tech Academy
Category:

Start using Excel to its full potential to become proficient at your Excel tasks today!

Either you’re new to Microsoft Excel, or you’ve played around with Excel since long but want to get more comfortable with MS Excel’s advanced features, or maybe you want to enhance your data analysis skills using Microsoft Excel. Either way, this Excel course will be great for you.

A Verifiable Certificate of Completion is presented to all students who undertake this MS Excel course.

 

What you’ll learn
  • A Beginner’s Guide to Microsoft Excel – Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts, Macros
  • Knowledge of all the essential Excel formulas
  • Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
  • Master Excel’s most popular lookup functions such as Vlookup, Hlookup, Index and Match
  • Harness full potential of Excel by creating Pivot tables with slicers
  • Make great presentations using the Conditional and Table formatting options
  • Visually enchant viewers using Bar charts, Scatter Plots, Histograms etc.
  • Increase your efficiency by learning how to create and use important Excel shortcuts
  • Explore fun and exciting use cases of Excel
Course content
20

20 sections • 93 lectures • Total duration 10 h 33 min

Introduction
Excel Basics
Essential Excel functions
XLookup - only for Excel 2021 and Office 365
Data Tools
Formatting data and tables
Pivot Tables
Excel Charts
Pivot Charts
NEW! Analyze Data option in Excel - only for Microsoft 365 users
Special purpose charts
Named Ranges
Excel Shortcuts
Macros
Importing data from PDF and Websites
Advanced Excel
Power Query, Power Pivot and DAX in Excel
Copilot in Excel - only for Microsoft 365 subscribers
Creative Infographics
Congratulations & about your certificate