Preview Advanced Microsoft Excel Online Course

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

Preview - Advanced Microsoft Excel Online Course - Hindi