18-Day Advanced Excel Syllabus
Fast-track your Excel skills from beginner to advanced level in just 18 days.
Who is this course for?
- Students who want strong Excel skills for studies & jobs
- Job seekers preparing for office, accounting, and data roles
- Working professionals who want to upgrade Excel skills fast
- Anyone looking for a compact, fast-paced Excel course
What you will achieve in 18 days
- Cover core Excel tools & functions in a short time
- Practice with real-world business examples
- Build confidence to work with Excel in office environments
- Learn reporting, analysis & dashboards (without heavy VBA)
Course Outline – Advanced Excel (18 Days)
Day 1: Getting Started with Microsoft Excel (Recorded – 1 Hour)
- Excel interface & core features
- Workbooks, worksheets & navigation
- Ribbon & Quick Access Toolbar customization
Day 2: Auto Fill, Formatting & Invoice Designing (Live – 1 Hour)
- Auto Fill & Flash Fill
- Text & number formatting
- Invoice template designing
- Table formatting best practices
Day 3: Cell References & Ledger Accounts (Live – 1 Hour)
- Relative, Absolute & Mixed references
- Using references in formulas
- Ledger account preparation in Excel
Day 4: Hands-on Practice Session (Live – 1 Hour)
- Practice Days 1–3 concepts
- Guided exercises & problem-solving
Day 5: Home Tab, Paste Special & Conditional Formatting (Live – 1 Hour)
- Home tab deep dive
- Paste Special techniques
- Conditional formatting for analysis
Day 6: Practical Classwork Session (Live – 1 Hour)
- Real-life examples using conditional formatting
- Data cleaning & formatting practice
Day 7: Data Summarization Functions (Live – 1 Hour)
- SUM, AVERAGE, COUNT, MIN, MAX
- SUBTOTAL & AGGREGATE
- SUMIF, COUNTIF, AVERAGEIF
Day 8: Hands-on Summarization Exercises (Live – 1 Hour)
- Practical data analysis problems
- Report-based exercises
Day 9: Preparing Reports for Printing (Recorded – 1 Hour)
- Page setup & print area
- Headers, footers & page number
Day 10: Logical Functions (IF, Nested IF, IFS, SWITCH) (Live – 1 Hour)
- IF with AND / OR
- Nested IF real-world logic
Day 11: Lookup & Reference Functions (Live – 1 Hour)
- VLOOKUP, HLOOKUP
- XLOOKUP
- INDEX & MATCH
Day 12: Dynamic Excel Functions (Live – 1 Hour)
- FILTER, UNIQUE, SORT
- INDIRECT & HYPERLINK
- Dynamic linking concepts
Day 13: Date & Time Functions (Live – 1 Hour)
- DATEDIF, NETWORKDAYS, WORKDAY
- YEAR, MONTH, DAY & more
Day 14: Text Functions & File Security (Live – 1 Hour)
- LEFT, RIGHT, MID, LEN
- TRIM, SEARCH, SUBSTITUTE
- Workbook & worksheet protection
Day 15: PivotTables – Data Analysis (Live – 1 Hour)
- Creating PivotTables
- Sorting, filtering & grouping
Day 16: Pivot-based Reports (Live – 1 Hour)
- Business reports using PivotTables
- Summary & comparison reports
Day 17: Charts & Dashboards (Live – 1 Hour)
- Charts, slicers & visuals
- Interactive dashboard basics
Day 18: Practical Automation Session (No VBA Coding) (Live – 1 Hour)
- Macro concepts (overview only)
- Recording simple macros
- Practical automation examples
- Final revision & Q&A
