★★★★★
"The structure, the practice exams, the instructor — all top tier. Passed first try."
AS
Ranjan PradhanSenior Project Manager
— The journey
Course Outline
What the programme covers, module by module.
Module 1: Introduction to Microsoft Excel
- Excel interface
- Workbook and worksheet concepts
- Ribbon navigation
- Quick Access Toolbar
- Creating a workbook
- Saving files
Module 2: Working with Worksheets
- Rows and columns
- Cell references
- Selecting cells
- Inserting and deleting rows
- Renaming worksheets
- Worksheet navigation
Module 3: Data Entry & Editing
- Entering data
- Editing cell content
- Copy and paste
- AutoFill
- Fill Handle
- Undo and redo
Module 4: Cell Formatting
- Fonts and styles
- Alignment
- Borders
- Cell colors
- Number formats
- Format Painter
Module 5: Basic Formulas
- Formula creation
- Arithmetic operators
- Cell references
- Formula copying
- Relative references
- Absolute references
Module 6: Essential Excel Functions
- SUM
- AVERAGE
- COUNT
- MAX
- MIN
- AutoSum
Module 7: Managing Data
- Sorting data
- Filtering records
- Find and Replace
- Remove duplicates
- Data organization
- Table formatting
Module 8: Working with Tables
- Creating tables
- Table formatting
- Table styles
- Table sorting
- Table filtering
- Managing records
Module 9: Creating Charts
- Column charts
- Bar charts
- Pie charts
- Line charts
- Chart formatting
- Chart customization
Module 10: Page Layout & Printing
- Page setup
- Margins
- Headers and footers
- Print area
- Page breaks
- Printing worksheets
Module 11: Workbook Management
- Opening workbooks
- Saving versions
- Protecting worksheets
- File organization
- Workbook views
- Navigation shortcuts
Module 12: Basic Data Analysis
- Simple summaries
- Conditional formatting
- Basic calculations
- Data comparison
- Highlighting trends
- Quick analysis tools
Module 13: Productivity Features
- Freeze panes
- Split windows
- Keyboard shortcuts
- Templates
- Quick formatting
- Efficient navigation
Module 14: Everyday Excel Applications
- Expense tracker
- Attendance sheet
- Sales register
- Budget worksheet
- Inventory list
- Task tracker
Module 15: Practical Excel Exercises
- Workbook creation
- Data entry practice
- Formula application
- Chart creation
- Report formatting
- Spreadsheet review
— 01.2 · Is it right for you?
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Who it's for
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
What's included
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Who it's for
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
What's included
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Who it's for
Self-Paced
Best for self-motivated learners who need maximum flexibility around work and life.
What's included
Everything you get
- ✓ On-demand video lessons
- ✓ Interactive quizzes
- ✓ 24/7 access on any device
— About this course
Course Overview
The Microsoft Excel Foundation program helps learners build essential spreadsheet skills for organizing, analyzing, and presenting data efficiently. Participants learn worksheet management, formulas, functions, formatting, charts, data sorting, filtering, printing, and basic reporting techniques to improve productivity and perform everyday business, academic, and personal data management tasks.