arrow_back
Section I - Excel Functions for Professionals
Introduction to Advance Functions in Excel
Payment Functions & Loans
Future Value Function & Pensions
VLOOKUP Function & Grade Books
IF, Concatenate, & Evaluation
Conditional Formatting
IFERROR Function & Dynamic Amortization Tables
Calculating A Grade Example
How to Collect Data by Google Forms?
Section J - Statistical Functions Commonly used in Excel
Basic Excel Statistical Functions: COUNT, MEDIAN, MODE, PERCENTILE, STDEV, VAR, and more.
Extracting Values with SMALL/LARGE & RANK/PERCENTRANK
Randomization with RAND() & RANDBETWEEN
Row-Level Calculation with SUMPRODUCT
How to Calculate Shipping Cost with SUMPRODUCT?
Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
Building a Basic Dashboard with COUNTIFS & SUMIFS
Counting Duplicates with COUNTIF & SUMPRODUCT
Data Profiling with COUNT & SUMPRODUCT
Macros/VBA
Macros/VBA - Beginners
VBA Editor
VBA Editor - Beginners
VBA Editor - Advanced
Creating / Editing Code
Basics : Creating / Editing Code
Advanced: Creating / Editing Code
Invoking Macros
Beginners : Invoking Macros
Advanced: Invoking Macros
Compiling Code
Basic : Compiling Code
Advanced: Compiling Code
Variables
Understanding Variables
Variables - Advanced
Working With Object Model
Basic : Working With Object Model
Working With Object Model - Advanced
Creating and naming objects
Basic : Creating and naming objects
Advanced: Creating and naming objects
Navigation / Selection Techniques
Navigation / Selection Techniques - Beginners
Navigation / Selection Techniques - Advanced
Logic Statement
Logic Statement : Nested IF
Functions - User Defined
What is Logical Statement?
Looping Statement
Basic : Looping Statement
Advanced: Looping Statement
Interactive Code
Basic : Interactive Code
Interactive Code - Advanced
Error Handles
Error Handles - Beginners
Error Handles - Advanced
Excel Live Session
Excel Live Session 1