Advanced Excel Masterclass
About Course
This advanced Excel course is designed to take your spreadsheet skills to the next level. Whether you’re a business professional, analyst, or data enthusiast, you’ll gain expertise in complex functions, data analysis techniques, automation, and visualization. Dive deep into Excel’s advanced features and unlock its full potential to streamline workflows, analyze data efficiently, and make informed decisions.
Course Content
Advanced Formulas and Functions
-
Nested functions and formula auditing
00:00 -
Logical functions (IF, AND, OR) with advanced applications
00:00 -
Date and time functions for complex calculations (DATEIF, WORKDAY, NETWORKDAYS etc)
00:00 -
Link your data with VLOOKUP, HLOOKUP,XLOOKUP functions
00:00 -
SUMIF, SUBTOTAL, COUNTIF, COUNTA, $ functions,
00:00 -
Error handling (ISNA(), IFERROR(), ISERROR(), IFNA()
00:00
Data Analysis Techniques
Data Visualization and Dashboards
Student Ratings & Reviews
No Review Yet
