Intermediate Excel Module

Build analytical skills with advanced functions and data visualization. Take your Excel skills to the next level with powerful lookup functions and data analysis tools.

Intermediate

3-4 weeks

Duration

Lessons

Practice Questions

Projects

Prerequisites

Basic Excel knowledge (Beginner module recommended)

Skills You'll Gain

Logical FunctionsLookup FunctionsAdvanced ChartsPivot TablesData Validation

Topics Covered

IF & Logical Functions (IF, AND, OR, NOT)

VLOOKUP & HLOOKUP Functions

XLOOKUP - The Modern Lookup

INDEX & MATCH Functions

Advanced Chart Types

Pivot Tables & Pivot Charts

Data Validation Rules

Conditional Formatting

Advanced Filtering

Text Functions (LEFT, RIGHT, MID, CONCATENATE)

Date & Time Functions

Statistical Functions

Error Handling (IFERROR, ISERROR)

Named Ranges

Advanced Formatting

Practice Questions

12 questions available

VLOOKUP Basic

Find employee salary using VLOOKUP

5 minIntermediate30 points

RIGHT Function

Extract characters from right

3 minIntermediate20 points

MID Function

Extract characters from middle

4 minIntermediate25 points

FIND Function

Find position of text

4 minIntermediate25 points

SUBSTITUTE Function

Replace text within string

4 minIntermediate25 points

DATE Function

Create date from components

3 minIntermediate20 points

YEAR Function

Extract year from date

3 minIntermediate20 points

MONTH Function

Extract month from date

3 minIntermediate20 points

DAY Function

Extract day from date

3 minIntermediate20 points

WEEKDAY Function

Get day of week

4 minIntermediate20 points

DATEDIF Function

Calculate difference between dates

5 minIntermediate30 points

IF with AND

Check multiple conditions

4 minIntermediate25 points

Hands-On Projects

Sales Dashboard with Charts

Employee Database Management

Financial Tracker with Analysis

Inventory Management System

Customer Data Analysis