- Excel Fundamentals: Launching Excel, interface overview, ribbon customization, workbook structure & shortcuts
- Entering & Editing Data: Numeric/text data, cell references, basic formulas
- Basic Functions: SUM, MIN, MAX, COUNT, AVERAGE, AUTOSUM
- Modifying Worksheets: Move/copy data, insert/delete rows & columns, resize cells, manage sheets
- Formatting Data: Fonts, borders, number formats, conditional formatting & styles
- Charts & SmartArt: Insert images, shapes, SmartArt, create & format charts
- Printing Worksheets: Page layout, margins, scaling, headers/footers, print range
- Excel Templates: Using & creating templates
- Practice Session (Beginner Wrap-Up)
- Conditional Functions: Named ranges, IF, COUNTIF, SUMIF, IFERROR, nesting
- Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, dynamic lookups
- Text Functions: LEFT, RIGHT, MID, LEN, SEARCH, CONCATENATE
- New Excel 365 Functions: FILTER, SORT, UNIQUE, XLOOKUP, SWITCH, TEXTJOIN, TEXTSPLIT
- Auditing & Protection: Trace formulas, watch window, protect cells/workbooks
- What-If Analysis: Goal Seek, Solver, Data Tables, Scenario Manager
- Macros (Intro): Record, edit, run macros, buttons & basic VBA edits
- Practice Session (Advanced Wrap-Up)
- Project #1 – Macro Recorder Tools
- VBA Concepts, Logic & Loops
- Project #2 – User Interaction & Sorting
- Project #3 – Cleaning & Formatting Data
- Project #4 – Automating Formulas
- Project #5 – Weekly Reports with VBA
- Project #6 – VBA User Forms
- Project #7 – Importing Text Files with VBA
- Final Exam & Course Wrap-Up
- Build and manage professional spreadsheets
- Master formulas (SUM, VLOOKUP, IF, INDEX/MATCH, XLOOKUP)
- Analyse large datasets with PivotTables & PowerPivot
- Automate tasks with Macros & VBA
- Create dashboards and interactive reports
- Improve productivity with shortcuts & best practices
- No prior Excel knowledge required
- Microsoft Excel 2007–2024 or Microsoft 365 installed
- Students and professionals looking to master Excel
- Beginners who want to learn step by step
- Advanced users aiming to automate workflows with VBA
- Anyone wanting to build powerful Excel reports and dashboards