Best MS Excel Course in Kanakapura Road, Jp Nagar and Konankunte

Module 1: Introduction to Excel (Beginner)

• Overview of Excel interface (Ribbon, Tabs, Quick Access Toolbar)
• Workbook vs Worksheet
• Cell, Rows, Columns, and Ranges
• Entering and editing data
• Saving and opening files
• Basic formatting (fonts, colors, borders, alignment)
• Number formats (currency, percentage, date, time)

Module 2: Basic Operations

• AutoFill and Flash Fill
• Copying, moving, and pasting data
• Sorting and filtering data
• Inserting/deleting rows, columns, and sheets
• Freeze panes, split windows, and view options

Module 3: Formulas and Functions

• Understanding formulas and cell references (relative, absolute, mixed)
• Basic functions: SUM, AVERAGE, MIN, MAX, COUNT
• Text functions: LEFT, RIGHT, MID, CONCATENATE, TRIM
• Logical functions: IF, AND, OR
• Date and Time functions: TODAY, NOW, DATE, DATEDIF

Module 4: Formatting & Data Visualization

• Conditional Formatting
• Data validation and drop-down lists
• Working with Themes and Styles
• Creating charts: Column, Bar, Line, Pie, Area
• Modifying and formatting charts
• Sparklines

Module 5: Working with Large Data

• Using Named Ranges
• Subtotals
• Outline and Grouping
• Working with multiple worksheets (3D references, linking data)
• Consolidating data

Module 6: Advanced Functions

• VLOOKUP, HLOOKUP
• XLOOKUP (Excel 365/2021)
• INDEX & MATCH
• Advanced text functions: TEXT, VALUE, SUBSTITUTE, REPLACE
• Nested IF statements
• Error handling functions: IFERROR, ISERROR

Module 7: Data Analysis Tools

• PivotTables (creating, formatting, and updating)
• PivotCharts
• Slicers & Timelines
• Using Goal Seek
• What-If Analysis (Data Tables, Scenario Manager)

Module 8: Advanced Data Management

• Importing data from other sources (CSV, Access, Web)
• Power Query basics
• Protecting worksheets and workbooks
• Sharing and collaborating on Excel files

Module 9: Macros & Automation (Optional Advanced)

• Introduction to Macros
• Recording and running a Macro
• Assigning Macros to buttons
• Introduction to VBA (Visual Basic for Applications)

Module 10: Final Project

• Preparing a business report with data entry, formulas, charts, and PivotTables
• Automating repetitive tasks with a Macro

Advanced Excel Syllabus

Module 1: Advanced Cell References & Named Ranges

• Dynamic named ranges
• Using INDIRECT & OFFSET
• Linking and consolidating data from multiple sheets/workbooks

Module 2: Advanced Functions & Formulas

• Lookup & Reference:
• VLOOKUP with approximate/exact match
• HLOOKUP
• INDEX + MATCH combinations
• XLOOKUP (Excel 365/2021)
• Dynamic arrays (FILTER, SORT, UNIQUE, SEQUENCE)
• Nested IFs & IFS
• Text functions: TEXT, SUBSTITUTE, REPLACE, VALUE, TEXTJOIN
• Error handling: IFERROR, ISNA, IFNA
• Financial functions: PMT, NPV, IRR
• Statistical functions: RANK, PERCENTILE, QUARTILE

Module 3: Data Validation & Protection

• Advanced data validation rules
• Creating dependent drop-down lists
• Using formulas in data validation
• Protecting ranges and workbooks
• Using sheet-level passwords and permissions

Module 4: Conditional Formatting (Advanced)

• Using formulas inside conditional formatting
• Creating dynamic color scales and icon sets
• Managing multiple rules
• Highlighting duplicates, outliers, or top/bottom values

Module 5: Data Analysis Tools

• PivotTables (advanced grouping, calculated fields, multiple consolidation ranges)
• PivotCharts with slicers and timelines
• Advanced sorting & filtering (custom lists, color filtering)
• Subtotals and Outlining large datasets

Module 6: What-If Analysis & Scenario Planning

• Goal Seek (complex scenarios)
• Scenario Manager
• Data Tables (one-variable & two-variable)
• Solver Add-in for optimization problems

Module 7: Power Tools (Optional but Valuable)

• Introduction to Power Query:
• Importing data from multiple sources
• Cleaning and transforming data
• Introduction to Power Pivot:
• Data Models
• Relationships and DAX basics

Module 8: Working with External Data

• Importing & linking data from Access, Web, SQL
• Refreshing external data
• Using Connections & Queries

Module 9: Automation with Macros & VBA

• Recording macros with relative & absolute references
• Assigning macros to shapes/buttons
• Introduction to VBA Editor
• Writing simple VBA procedures/functions
• Automating repetitive tasks

Module 10: Dashboard & Reporting

• Designing interactive dashboards
• Using form controls (combo boxes, checkboxes)
• Dynamic charts & data visualization
• KPI indicators & trend analysis

Module 11: Final Project

• Creating a complete automated report/dynamic dashboard using advanced formulas, PivotTables, and macros