📊 Excel Training Course Content

Module 1: Introduction to Excel (Basics)

• Overview of Excel interface

• Workbook, worksheets, cells, rows & columns

• Data entry, editing & formatting

• Autofill, flash fill & custom lists

• Saving, printing & page setup

Module 2: Formatting & Productivity Tools

• Cell formatting (fonts, colors, borders, number formats)

• Conditional formatting (highlighting rules, data bars, icon sets)

• Sorting & filtering data

• Freeze panes, split windows, zoom & view options

• Find & Replace, Go To Special

Module 3: Basic Formulas & Functions

• Understanding formulas & cell references (Relative, Absolute, Mixed)

• Arithmetic operations (+, -, *, /, %)

• Common functions:

  • SUM, AVERAGE, MIN, MAX

  • COUNT, COUNTA, COUNTBLANK

  • TODAY, NOW

• Text functions: LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE, TEXTJOIN

Module 4: Data Handling & Validation

• Data validation (drop-down lists, input messages, error alerts)

• Removing duplicates

• Using Flash Fill effectively

• Protecting worksheets & workbooks

Module 5: Charts & Visualization

• Creating & customizing charts (Column, Bar, Line, Pie, Area, etc.)

• Combo charts

• Sparklines

• Formatting chart elements

• Best practices for data visualization

Module 6: Advanced Formulas & Functions

• Logical functions: IF, AND, OR, IFERROR, IFS

• Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX + MATCH

• Date & time functions: EOMONTH, DATEDIF, NETWORKDAYS, WORKDAY

• Statistical functions: RANK, PERCENTILE, AVERAGEIF(S), SUMIF(S), COUNTIF(S)

• Dynamic arrays: SORT, FILTER, UNIQUE, SEQUENCE

Module 7: PivotTables & PivotCharts

• Creating PivotTables from datasets

• Grouping data (dates, numbers, text)

• Summarizing & filtering PivotTables

• Using slicers & timelines

• Creating PivotCharts

Module 8: Advanced Data Tools

• What-If Analysis: Goal Seek, Data Tables, Scenario Manager

• Power Query (Get & Transform Data)

• Consolidating data from multiple sheets

• Flash Fill for automation

• Removing duplicates & cleaning data

Module 9: Advanced Excel Features

• Named ranges & dynamic ranges

• Array formulas & dynamic arrays

• Data validation with formulas

• Conditional formatting with formulas

• Hyperlinks & linking sheets/workbooks

Module 10: Macros & Automation

• Introduction to Macros

• Recording & running macros

• Assigning macros to buttons

• Basics of VBA (optional for advanced learners)

Module 11: Collaboration & Security

• Sharing workbooks

• Tracking changes & comments

• Protecting worksheets/workbooks

• Restricting editing with passwords

Module 12: Real-Time Case Studies & Projects

• Sales & revenue dashboard

• HR employee database management

• Financial budgeting template

• KPI reporting with PivotTables & charts