12 Week's - Excel Certification Program

SECTION 1: EXCEL FOUNDATIONS & BASICS

Lecture 1.1: Overview

Lecture 1.2: Excel Interface Mastery

Lecture 1.3: 50 Keyboard Shortcuts (Compressed)

Lecture 1.4: Formula Auditing & Best Practices

SECTION 2: CONDITIONAL LOGIC & LOGICAL OPERATORS

Lecture 2.1: IF Function - Fundamentals

Lecture 2.2: Nested IF - Multiple Conditions

Lecture 2.3: Error Handling - IFERROR

Lecture 2.4: NOT Operator & IS Statements

PROJECT

SECTION 3: STATISTICAL FORMULAS

Lecture 3.1: RANK & PERCENTRANK

Lecture 3.2: SMALL, LARGE & Extremes

Lecture 3.3: RAND & RANDBETWEEN

Lecture 3.4: SUMPRODUCT - Advanced

Lecture 3.5: COUNTIFS, SUMIFS, AVERAGEIFS

Lecture 3.6: PROJECT - Sales Dashboard

SECTION 4: LOOKUP FUNCTIONS

Lecture 4.1: VLOOKUP - Complete Guide

Lecture 4.2: VLOOKUP Errors & IFERROR

Lecture 4.3: INDEX & MATCH - Flexible Lookup

Lecture 4.4: XLOOKUP - Modern Alternative

Lecture 4.5: CHOOSE & OFFSET Functions

Lecture 4.6: PROJECT - Multi-Sheet Consolidation

SECTION 5: TEXT FUNCTIONS

Lecture 5.1: UPPER, LOWER, PROPER, TRIM

Lecture 5.2: LEFT, RIGHT, MID, LEN

Lecture 5.3: CONCATENATE & TEXTJOIN

Lecture 5.4: SEARCH, FIND & Pattern Matching

Lecture 5.5: SUBSTITUTE & Advanced Text

Lecture 5.6: TEXT & VALUE Conversions

Lecture 5.7: PROJECT - Data Cleaning System

SECTION 6: DATE & TIME FUNCTIONS

Lecture 6.1: DATEVALUE & Date Formatting

Lecture 6.2: TODAY & NOW - Dynamic Dates

Lecture 6.3: Extract Date Components

Lecture 6.4: EOMONTH & Fiscal Periods

Lecture 6.5: DATEDIF - Duration Calculation

Lecture 6.6: WORKDAY & NETWORKDAYS

Lecture 6.7: YEARFRAC & Advanced Calculations

Lecture 6.8: PROJECT - Leave & Payroll System

SECTION 7: ADVANCED FORMATTING & DATA ANALYSIS

Lecture 7.1: Conditional Formatting Mastery

Lecture 7.2: Pivot Tables - Fundamentals

Lecture 7.3: Pivot Table Calculations & Aggregations

Lecture 7.4: Charts from Pivot Tables

Lecture 7.5: Slicers & Timelines

Lecture 7.6: PROJECT - Executive Dashboard

SECTION 8: POWER QUERY - COMPLETE

Lecture 8.1: Power Query Introduction

Lecture 8.2: Load Data from CSV

Lecture 8.3: Basic Transformations

Lecture 8.4: Data Types & Error Handling

Lecture 8.5: Merge & Append Queries

Lecture 8.6: Group By & Aggregations

Lecture 8.7: Split & Custom Columns

Lecture 8.8: PROJECT - Consolidate 5 CSV Files

SECTION 9: MACROS & VBA AUTOMATION

Lecture 9.1: Recording Macros - No Coding!

Lecture 9.2: VBA Editor & Programming Basics

Lecture 9.3: Objects, Properties & Methods

Lecture 9.4: Loops - FOR, FOR EACH, DO WHILE

Lecture 9.5: Conditionals - IF THEN ELSE

Lecture 9.6: Common Automations

Lecture 9.7: PROJECT - Invoice Automation

SECTION 10: CAPSTONE PROJECTS

Lecture 10.1: Capstone Option 1 - Financial Model

Lecture 10.2: Capstone Option 2 - Dashboard

Lecture 10.3: Capstone Option 3 - Automation System

Lecture 10.4: Portfolio & Career

SECTION 11: Live 1:1 Interview - Technical Round

SECTION 12: CERTIFICATION - Exam