Microsoft Office Suite
Microsoft Excel
This comprehensive Microsoft Excel training takes you from foundational skills to advanced data analysis techniques. Whether you are new to spreadsheets or looking to sharpen your expertise, this course covers everything from cell formatting and formulas to PivotTables, Power Query, and dynamic dashboards. You will leave with the confidence to automate repetitive tasks, build professional reports, and make data-driven decisions faster.
30 hours (flexible scheduling)
Live virtual sessions or on-site training
Beginner to Advanced
What You Will Learn
Formulas & Functions
PivotTables
Data Analysis
Charts & Visualization
Course Curriculum
6 modules01
Excel Fundamentals
- Navigating the interface and workbook structure
- Cell formatting, number styles, and conditional formatting
- Working with multiple sheets and cross-references
- Printing, page layout, and sharing workbooks
02
Formulas & Functions
- Essential functions: SUM, AVERAGE, COUNT, IF, VLOOKUP
- Nested formulas and logical operators (AND, OR, NOT)
- Text functions: CONCATENATE, LEFT, RIGHT, MID, TRIM
- Date and time functions for scheduling and tracking
- Error handling with IFERROR and ISERROR
03
Data Management & Analysis
- Sorting, filtering, and advanced filtering techniques
- Data validation rules and dropdown lists
- Removing duplicates and cleaning data
- Importing data from CSV, web, and external sources
- Using Tables for structured, dynamic ranges
04
PivotTables & PivotCharts
- Creating and customizing PivotTables
- Grouping, slicing, and drilling into data
- Calculated fields and custom aggregations
- Building interactive PivotCharts and dashboards
05
Charts & Data Visualization
- Choosing the right chart type for your data
- Formatting charts for professional presentations
- Sparklines and in-cell visualizations
- Dynamic charts with named ranges and OFFSET
06
Advanced Excel & Automation
- Introduction to Power Query for data transformation
- XLOOKUP, INDEX/MATCH, and dynamic array formulas
- Recording and editing macros for task automation
- Protecting sheets, workbooks, and sensitive data
- Collaboration features: comments, co-authoring, version history
After This Course
- Build professional spreadsheets and reports from scratch
- Master 30+ essential Excel functions and formulas
- Create dynamic PivotTables and interactive dashboards
- Automate repetitive tasks with macros and Power Query
- Clean, transform, and analyze data from multiple sources
- Present data visually with charts and conditional formatting
Who Is This For
- Business analysts and financial professionals
- Administrative staff managing reports and data
- Team leads who need data-driven insights
- Anyone looking to boost productivity with Excel
Prerequisites
Basic computer literacy. No prior Excel experience required for beginner modules.
Ready to master Microsoft Excel?
Get in touch to discuss scheduling, group rates, or a customized curriculum for your team.