Microsoft Excel Advanced
| Location | Duration | Kenyan Cost | Non-Kenyan Cost | Upcoming Schedules |
|---|---|---|---|---|
| Nairobi, Kenya | 5 Days | KES 100,000 | USD 1,300 |
| Location | Duration | Non-Kenyan Cost | Register |
|---|---|---|---|
| Online | 5 Days | USD 550 |
| Register |
|---|
Microsoft Excel Advanced
About the Course
This course is designed to take professionals beyond basic spreadsheet skills into advanced Excel
functionality used for data analysis, automation, and reporting. Participants will master complex
formulas, data tools, and visualisation techniques that improve efficiency and decision-making in
everyday business tasks.
Target Participants
- ● Finance, accounting, and administrative professionals
- ● Data analysts and business analysts
- ● Managers and team leaders handling reports and dashboards
- ● HR and operations professionals managing data
- ● Procurement and supply chain officers
- ● Anyone seeking to strengthen their Excel proficiency for work
What You Will Learn
- ● Apply advanced formulas and functions for data analysis
- ● Use lookup and reference functions effectively
- ● Build and manage PivotTables and PivotCharts
- ● Apply data validation, conditional formatting, and data cleaning techniques
- ● Automate repetitive tasks using macros and basic VBA
- ● Create dynamic dashboards and visual reports
- ● Use Power Query for data transformation
- ● Apply what-if analysis and scenario planning tools
- ● Manage and consolidate large datasets across worksheets and workbooks
- ● Apply best practices in spreadsheet design and data integrity
Course Duration
- ● Face-to-face workshops: 5 days
- ● Virtual Training: 7 days
- ● LMS: Self-paced learning
Course Outline
Advanced Formulas and Functions
- ● Logical functions: IF, AND, OR, nested IFs
- ● Lookup functions: VLOOKUP, HLOOKUP, INDEX and MATCH, XLOOKUP
- ● Text functions for data cleaning and manipulation
- ● Date and time functions
- ● Array formulas and dynamic arrays
Data Analysis Tools
- ● Sorting, filtering, and advanced filtering techniques
- ● Data validation rules and drop-down lists
- ● Conditional formatting for data visualization
- ● Removing duplicates and cleaning datasets
- ● Consolidating data from multiple sheets and workbooks
PivotTables and PivotCharts
- ● Creating and customising PivotTables
- ● Grouping and summarizing data
- ● Calculated fields and items in PivotTables
- ● Building PivotCharts for visual analysis
- ● Refreshing and managing PivotTable data sources
Dashboards and Data Visualisation
- ● Principles of effective dashboard design
- ● Using charts and sparklines for visual storytelling
- ● Interactive dashboards with slicers and timelines
- ● Combining multiple data views in a single dashboard
- ● Best practices for presenting data to stakeholders
Power Query and Data Transformation
- ● Introduction to Power Query
- ● Importing and transforming data from multiple sources
- ● Cleaning and reshaping data efficiently
- ● Merging and appending queries
- ● Automating data refresh processes
Automation with Macros and What-If Analysis
- ● Introduction to macros and recording basic macros
- ● Introduction to VBA for task automation
- ● Introduction to VBA for task automation
- ● What-if analysis: data tables, scenario manager, and goal seek
- ● Building simple financial and operational models
- ● Spreadsheet best practices, security, and version control
Training Approach
This course will be delivered through a coaching-first approach that goes beyond traditional
instruction. Whether in our Nairobi classroom, live virtual cohorts, or through our White Label
LMS, participants engage in a safe and nonjudgmental learning environment designed for
meaningful transformation.
We focus on the individual behind the professional title, connecting with the heart before
training the mind. This approach encourages reflection, practical application, and deeper
engagement, ensuring that learning is not only understood but also internalized and applied with
confidence.
Certification
Participants will receive a certificate upon successful completion of the course, recognizing their
knowledge and practical competence.
Customized Training Solutions
This course can also be delivered as a tailor-made program, designed to address the specific
needs, priorities, and operational challenges of your organization.