Microsoft Excel – MS Excel Formulas & Functions in just 3hrs
$0.99
Start using Excel to its full potential to become proficient at your Excel tasks today!
Either you’re new to Excel, or you’ve played around with it but want to get more comfortable with all the popular functions in Microsoft Excel, either way, this course will be great for you.
What you’ll learn
- Knowledge of all the essential Excel formulas
- Master Excel’s most popular lookup functions such as Vlookup, Hlookup, Index and Match
- Solid understanding of Microsoft Excel
- Master Excel’s most popular lookup functions such as Vlookup, Hlookup, Index and Match
Course content
1313 sections • 42 lectures • Total duration 3 hours 57 minutes
Introduction
Basic Formula Operations and Mathematical Functions
Textual Functions
Logical Functions
Date-time Functions
Lookup Functions (V Lookup, Hlookup, Index-Match)
XLookup - only Excel 2021 and Office 365
Data Tools
Indirect Function
NEW! Analyze Data option in Excel - only for Microsoft 365 users
Financial Functions
Pivot Tables
Bonus Section