Microsoft Excel Weekender Crash Course

$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
  • Solid understanding of Microsoft Excel
  • 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, Waterfall charts etc.
  • Increase your efficiency by learning how to create and use important Excel shortcuts
  • Become competent in using advanced Analytics techniques in Excel such as Regression, Goal seek and Solver
  • Learn Automation techniques by using Macros
  • Explore fun and exciting use cases of Excel in our bonus videos
Course content
22

22 sections • 70 lectures • Total duration 7 hours 8 minutes

Introduction
Essential Formulas and Functions
Lookup Functions
XLookup - only for Excel 2021 and Office 365
Data Tools
Formatting data and tables
Pivot Tables
Charts
NEW! Analyze Data option in Excel - only for Microsoft 365 users
Maps Chart - only for Excel 2019 and above
Named Ranges
Excel Shortcuts
Importing data from external sources
Analytics in Excel
Macros
Power Query, Power Pivot and DAX in Excel
Copilot in Excel - only for Microsoft 365 subscribers
Excel Use Cases: Engaging Visualizations
Excel Use Cases: Income Tax template
Excel Use Cases: Modeling Customer Lifetime Value
Final Quiz
Congratulations & about your certificate