September Intake applications are now open
View
Live
Epic Academy

Advanced Excel for Professionals Course at Epic Academy Kenya, Intermediate, 6 Weeks in Nairobi

Go beyond basic spreadsheets with advanced formulas, dashboards, automation and professional data analysis. Learn Excel, Dashboards, Automation, Analytics, Power Query, Power Pivot at Epic Academy Kenya (www.epicacademy.ke). Build professional spreadsheets, dashboards and analytical workflows.

Nairobi,Kenya
Business Technology•Flexible

Advanced Excel for Professionals

Go beyond basic spreadsheets with advanced formulas, dashboards, automation and professional data analysis.

6 Weeks110+ learnersCertification
Program Fee
KES 15,000/ USD 120
Program Overview

Excel. Analyze. Transform.

Excel is one of the most powerful tools for data analysis and reporting. This program teaches you advanced Excel techniques for professional data work.

You'll master advanced formulas, PivotTables, Power Query, Power Pivot, and learn how to create professional dashboards that drive better decision-making.

Advanced Formulas

XLOOKUP, INDEX/MATCH

PivotTables

Data Analysis & Summaries

Power Query

Data Transformation

Dashboards

Professional Reporting

Advanced Excel for Professionals
Advanced Excel for Professionals

What You'll Achieve

  • Master advanced Excel formulas
  • Build professional dashboards
  • Analyze data with PivotTables
  • Use Power Query for data transformation
  • Create automated Excel workflows

Capstone Project

Build a comprehensive Excel dashboard using real-world data, with advanced formulas, PivotTables, and professional visualizations.

Curriculum

Your Excel Mastery Journey

A structured 6-week program covering advanced Excel techniques and professional data analysis.

1

Advanced Excel Skills

Month 1

Week 1

Advanced Formulas

  • XLOOKUP
  • INDEX & MATCH
  • Dynamic Arrays
Week 2

Logical Functions

  • IF Statements
  • Nested Functions
  • Error Handling
Week 3

Data Analysis

  • PivotTables
  • PivotCharts
  • Data Summaries
Week 4

Data Visualization

  • Charts
  • Conditional Formatting
  • Report Design
2

Advanced Excel Tools

Month 2

Week 1

Power Query

  • Data Cleaning
  • Transformations
  • Merge Datasets
Week 2

Power Pivot

  • Data Modeling
  • Relationships
  • Measures
Week 3

Dashboards

  • Dashboard Design
  • KPIs
  • Interactive Elements
Week 4

Capstone Project

  • Project Planning
  • Development
  • Presentation
Technologies

Tools You'll Master

Microsoft ExcelAdvanced FormulasXLOOKUPINDEX & MATCHPivotTablesPivotChartsPower QueryPower PivotDashboardsKPIsData VisualizationConditional FormattingWhat-If AnalysisVBA

Ready to Master Excel?

Master advanced Excel techniques and build professional dashboards that drive better decisions.

Program Fee
KES 15,000/ USD 120

Frequently Asked Questions about Advanced Excel for Professionals at Epic Academy Kenya

What is the Advanced Excel for Professionals course at Epic Academy Kenya?

Advanced Excel for Professionals at Epic Academy Kenya is a 6 Weeks intermediate-level program. Go beyond basic spreadsheets with advanced formulas, dashboards, automation and professional data analysis. The course covers Excel, Dashboards, Automation, Analytics, Power Query and finishes with a capstone project.

Who is the Advanced Excel for Professionals course for?

Advanced Excel for Professionals at Epic Academy Kenya is designed for intermediate learners who already have basic computer literacy and want to build practical, career-ready skills.

What will I learn in the Advanced Excel for Professionals course at Epic Academy Kenya?

You will learn Excel, Dashboards, Automation, Analytics, Power Query, Power Pivot, VBA. By the end of the program you will be able to: Master advanced Excel formulas; Build professional dashboards; Analyze data with PivotTables; Use Power Query for data transformation; Create automated Excel workflows.

How long does the Advanced Excel for Professionals course take at Epic Academy Kenya?

Advanced Excel for Professionals at Epic Academy Kenya takes 6 Weeks, delivered in a flexible format.

How much does the Advanced Excel for Professionals course cost at Epic Academy Kenya?

Advanced Excel for Professionals at Epic Academy Kenya costs KES 15,000 (approximately USD 120). Scholarships are available for learners with financial need, visit www.epicacademy.ke/scholarships.

Do I get a certificate after the Advanced Excel for Professionals course?

Yes. On successful completion of Advanced Excel for Professionals at Epic Academy Kenya, you receive an industry-recognized certificate of completion verifiable at certopus.com/verify.

What tools and technologies are used in the Advanced Excel for Professionals course?

The Advanced Excel for Professionals course at Epic Academy Kenya covers: Microsoft Excel, Advanced Formulas, XLOOKUP, INDEX & MATCH, PivotTables, PivotCharts, Power Query, Power Pivot, Dashboards, KPIs, Data Visualization, Conditional Formatting, What-If Analysis, VBA.

Is the Advanced Excel for Professionals course available online in Kenya?

Yes. Advanced Excel for Professionals is available online at Epic Academy Kenya, with live cohort sessions, mentorship and project reviews. Learners across Kenya, Africa and worldwide can participate without relocating to Nairobi.

Is Advanced Excel for Professionals at Epic Academy Kenya worth it?

Yes. Advanced Excel for Professionals at Epic Academy Kenya is taught by industry practitioners, includes real-world projects, hands-on tools and a capstone project, and finishes with an industry-recognized certificate. Alumni have moved into roles at Safaricom, KCB, Andela and Microsoft, among others.

What career can I pursue after Advanced Excel at Epic Academy Kenya?

Build professional spreadsheets, dashboards and analytical workflows. Graduates commonly pursue roles related to Business Technology in Kenya and across Africa, or use the skills to freelance, build products, or advance within their current role.

Can I apply for a scholarship for Advanced Excel for Professionals at Epic Academy Kenya?

Yes. Epic Academy Kenya has awarded 180+ scholarships. Apply at www.epicacademy.ke/scholarships. Scholarships cover course fees and include mentorship and project-based learning.