Master Microsoft Excel

• 1. Introduction to Excel Interface (1 hour)

•       Ribbon, cells, rows, columns Basic navigation

• 2. Basic Formulas & Functions (2 hours)

•       SUM, AVERAGE, MIN, MAX

• 3. Formatting Cells and Data (2 hours)

•       Cell formatting, borders, fill color, text alignment
•       Number formats (currency, percentage, dates)

• 4. Working with Worksheets (1 hour)

•       Creating, renaming, deleting, and moving sheets

• 5. Basic Data Entry & Editing (2 hours)

•       Copy, cut, paste, autofill, undo/redo Find and replace

• 6. Introduction to Sorting and Filtering (1.5 hours)

•       Sorting data (A-Z, Z-A) Basic filters

• 7. Printing & Page Setup (1 hour)

•       Setting print area, adjusting margins, page orientation

• 8. Basic Charts (2 hours)

•       Creating and formatting bar, column, and pie charts




• Total Duration: 10.5 hours

Price: ₹4,000

Book Appointment

• 1. Advanced Functions (2 hours)

•       IF, AND, OR, COUNTIF, SUMIF, VLOOKUP, HLOOKUP

• 2. Data Validation & Conditional Formatting (2 hours)

•       Drop-down lists, custom validation Applying conditional formatting rules

• 3. Working with Large Datasets (2 hours)

•       Sorting, filtering, removing duplicates
•       Using the Subtotal function

• 4. Pivot Tables (2 hours)

•       Creating pivot tables
•       Summarizing data, filtering, and pivot charting

• 5.Working with Tables (2 hours)

•       Creating tables, structured references, slicers

• 6. ext Functions (1.5 hours)

•       CONCATENATE, LEFT, RIGHT, MID, TRIM, LEN

• 7. Working with Dates & Times(2 hours)

•       Date and time formatting, basic date functions (TODAY, NOW, DATEDIF)

• 8. Basic Macros Introduction(1.5 hour)

•       Recording, running, and editing simple macros




• Total Duration: 15 hours

Price: ₹8,000

Book Appointment

• 1. Advanced Formulas & Array Functions (2 hours)

•       INDEX, MATCH, INDIRECT, OFFSET
•       Array formulas and dynamic arrays

• 2. Advanced Pivot Tables & Pivot Charts (2 hours)

•       Grouping data, calculated fields, and items
•       Advanced charting with pivot tables

• 3. Advanced Data Analysis with Excel (2 hours)

•       Using Excel’s Analysis ToolPak
•       Goal Seek, Solver, and Scenario Manager

• 4. Power Query (2 hours)

•       Extracting, transforming, and loading data
•       Combining datasets and cleaning data

• 5. Advanced Data Validation & Conditional Formatting (2 hours)

•       Dynamic lists, complex validation rules
•       Custom conditional formatting with formulas

• 6. Dashboard Creation (4 hours)

•       Combining charts, tables, slicers for dashboards
•       Using form controls (checkboxes, drop-downs)

• 7. Introduction to VBA (Visual Basic for Applications)(2 hours)

•       Introduction to Visual Basics




• Total Duration: 15 hours

Price: ₹10,000

Book Appointment