Basic to Advanced Excel By Ram Sanjay Jaiswal

Basic to Advanced Microsoft Excel -

Module 1: Excel Basics

Introduction to Excel interface & ribbon

Workbook & worksheet management

Data entry, formatting & cell styles

Basic formulas & functions (SUM, AVERAGE, COUNT, MIN, MAX)

Sorting & filtering data

Module 2: Intermediate Excel

Logical functions (IF, AND, OR)

Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)

Text functions (LEFT, RIGHT, MID, CONCAT, TRIM)

Date & time functions

Conditional formatting

Data validation & dropdown lists

Module 3: Data Analysis & Visualization

Charts & graphs (Column, Line, Pie, Bar)

Pivot Tables & Pivot Charts

Slicers & timelines