Course Overview
Master Microsoft Excel from fundamentals to advanced analysis. This course is structured into modules with hands-on exercises, practical case studies, and projects — ideal for professionals and students.
- Hands-on exercises, real-world case studies & downloadable templates
- Step-by-step modules from navigation to automation (VLOOKUP, INDEX/MATCH, PivotTables, Dashboards)
- Certificate of completion
Course Modules & Detailed Syllabus
Click on Chapter names for more information
Topics & Time split
Ribbon, Quick Access Toolbar, Formula Bar, Status Bar. Workbooks and worksheets.
Introduction to the Excel interface: (30 min) 30
Basic Navigation: (30 min) 30
Data Entry and Editing: (45 min) 30
Basic Formatting: (45 min) 45
Saving and Opening Workbooks: (15 min) 15
Chapter 2: Working with Data & Basic Formulas
Number, currency, date, time formats and custom formats; creating Excel tables; adding/deleting rows & columns.
Data Types and Formatting: (30 min) 30
Creating and Editing Tables: (30 min) 30
Basic Formulas (SUM, AVERAGE, COUNT, MIN, MAX) & References: (1 Hour) 60
Basic Error Handling: (30 min) 30
Advanced Formatting
Conditional formatting; cell styles, table styles.
Advanced Formatting: (1 Hour) 60
Sorting & Worksheet Management
Sorting & filtering, freezing panes, splitting windows, working with multiple worksheets, data validation.
Sorting and Filtering Data: (45 min) 45
Worksheet Management: (45 min) 45
Text Functions
LEFT, RIGHT, MID, CONCATENATE, TRIM, UPPER, LOWER, PROPER.
Text Functions: (1 Hour) 60
Date & Time Functions
TODAY, NOW, DATE, YEAR, MONTH, DAY, WEEKDAY; Text to Columns; Find & Replace.
Date and Time Functions: (45 min) 45
Text to Columns and Find & Replace: (45 min) 45
Logical Functions
IF, AND, OR, NOT, nested IF statements.
Logical Functions: (1 Hour) 60
Lookup Functions
VLOOKUP, HLOOKUP, INDEX, MATCH, IFERROR.
Lookup Functions: (1.5 Hours) 90
Conditional Sums & Counts
SUMIF, COUNTIF, AVERAGEIF, SUMIFS, COUNTIFS, AVERAGEIFS.
Conditional Sums and Counts: (1 Hour) 60
Named Ranges & Array Formulas
Named Ranges and a short intro to array formulas.
Named Ranges: (30 min) 30
Array formulas intro: (30 min) 30
Pivot Tables & Analysis
Subtotals, Tables & PivotTables, Slicers & Timelines, Recommended Pivot Tables.
Subtotals: (30 min) 30
Tables and PivotTables: (1 hour) 60
Slicers and Timelines: (30 min) 30
Recommended Pivot tables: (30 min) 30
Chart Types & Elements
Column, Bar, Line, Pie, Scatter charts; adding chart elements (titles, labels, legends); sparklines.
Chart Types: (1 Hour) 60
Chart Customization: (1 Hour) 60
Advanced Charting
Combination Charts, Dynamic Charts, Creating simple Dashboards.
Combination Charts: (1 hour) 60
Dynamic Charts: (1 hour) 60
Creating Simple Dashboards: (1 hour) 60
Import & Export
Import text files, CSV, web data; export data.
Importing Data: (1 hour) 60
Exporting Data: (30 min) 30
Project & Review
Practical case studies and a final project to apply learning.
Case Studies/Projects: (1-2 Hours) 120
Testimonials
Real feedback from learners mentored by Jayen
“Jayen understood my problem and suggested me the right thing which I will work on.”
- Sonal Anand“The mentoring helped me think beyond numbers and focus on the story the data tells.”
- Amit Patil“Approachable and insightful guidance. Helped me align my learning with career goals.”
- Priya SharmaAbout the Author
Jayen Thakker
Founder of MetricMinds.in, Jayen is an Excel & Data Analytics Trainer with 10+ years of experience delivering training, mentoring learners, and building dashboards & analytics programs. Jayen focuses on practical learning and making analytics accessible to all.
Contact: jayen@metricminds.in