Beginner Level3 Weeks

Excel for Business & Finance

By the end of this course, students will confidently use Excel to clean, analyze and visualize business and financial data with professional-grade spreadsheets and dashboards.

Live Online

Interactive sessions

Hands-On Projects

Build real spreadsheets

Certificate

Professional Certificate of Completion

Course Prerequisites

What you need

  • Basic computer skills
  • Willingness to learn through hands-on practice
  • Access to Microsoft Excel (2016 or later recommended)

Not required

  • No prior Excel experience needed
  • No coding or programming knowledge
  • No advanced mathematics

Equipment

  • Laptop or desktop with internet access
  • Microsoft Excel installed (or Microsoft 365)

What You'll Learn

Formulas & Functions

Master essential Excel functions - SUM, IF, VLOOKUP, XLOOKUP, COUNTIF for real business tasks.

Pivot Tables & Analysis

Summarize and explore large datasets quickly using pivot tables, slicers and grouping.

Charts & Visualizations

Build compelling bar, line and combo charts that communicate business performance at a glance.

Data Cleaning & Validation

Remove duplicates, fix formatting errors and validate inputs to keep your data accurate and trustworthy.

Excel Dashboards

Design interactive dashboards using conditional formatting, charts and dynamic tables for stakeholder reports.

Portfolio Development

Build a set of Excel projects that demonstrate your analytical skills to employers or clients.

What You'll Build

Throughout the course, you'll create portfolio-ready spreadsheets that showcase your skills to employers.

Sales Analysis Spreadsheet

Analyze monthly sales data using formulas and pivot tables to identify top products, regions and trends.

VLOOKUPPivot TablesFormulas

Financial Budget Tracker

Build a dynamic budget vs. actuals tracker with conditional formatting to flag variances instantly.

IF StatementsConditional FormattingCharts

Business KPI Dashboard

Design a one-page Excel dashboard displaying key performance indicators with dynamic charts and slicers.

Dashboard DesignSlicersData Validation

Data Cleaning Project

Take a messy real-world dataset, clean and restructure it then produce a summary report from scratch.

Data CleaningXLOOKUPText Functions

Your Instructor

Likeleli Motheo

Likeleli Motheo

Finance Analyst

A professional Finance Analyst with data analytics certification and extensive experience in financial modeling, business intelligence and data-driven decision making in international companies. Specializes in Excel, Power BI, dashboard design and storytelling with data for businesses and finance professionals who want to turn numbers into clear, compelling insights.

Course Curriculum

Part of the Data Analytics cohort. Excel students complete weeks 1–3 alongside Data Analytics students, working through the same curriculum at the same time.

1

Excel Foundations

Shared with Data Analytics

Formulas, functions, data cleaning and basic analysis

2

Advanced Excel Part 1

Shared with Data Analytics

Pivot tables, VLOOKUP, XLOOKUP and data validation

3

Advanced Excel Part 2

Shared with Data Analytics

Conditional formatting, charts, dashboards and automation

Who This Course Is For

Students preparing for data or business analysis positions
Career switchers targeting data or financial analyst roles
Professionals who need to present data clearly to management
Finance professionals who work with reports and spreadsheets daily
Business analysts who want to analyze data more effectively
Anyone handling numbers in Excel who wants to do more

Small Class Sizes for Better Learning

Limited to 25 students per cohort

Excel mastery requires close guidance, formula troubleshooting and discussion around real business scenarios. By limiting each cohort to 25 learners, we ensure every student receives personalized support, clear feedback on their work and the hands-on mentoring needed to build confidence with data.

Why Learn Excel?

The World's Most Used Data Tool

Excel is used by over 750 million people worldwide and remains the most common data tool in business, finance and operations.

Instantly Applicable at Work

From budgets to reports to dashboards, Excel skills are used daily across virtually every industry and job function.

Foundation for Advanced Analytics

Excel is the natural starting point before moving into SQL, Power BI or Python - building your analytical thinking from day one.

High Return on Investment

Employers consistently seek candidates who can work confidently with data in Excel, making it one of the fastest ways to increase your value.

Course Pricing

M2,000.00

3-Week Program

M350.00 application fee paid upon applying

Full Payment

M2,000.00

Pay in full before course starts

Frequently Asked Questions

Why only 25 students per cohort?

Excel mastery requires close guidance and hands-on practice. Small cohorts allow instructors to review each student's work individually, provide targeted feedback and ensure everyone builds solid, practical spreadsheet skills.

Do I need any prior experience?

No! This course is designed for complete beginners. Basic computer skills are all you need. We start with Excel fundamentals and build up step by step.

What if I have a full-time job?

Sessions are held in the evenings for 2 to 2.5 hours, only 2 days per week. You can follow along without disrupting your work schedule.

Will I get a certificate?

Yes, you will receive a Professional Certificate of Completion after finishing the course and submitting your projects.

Can I upgrade to the full Data Analytics program later?

Yes! If you complete the Excel course and want to continue into SQL, Power BI and the full analytics curriculum, you can join the Data Analytics program and credit your Excel weeks.

Ready to Master Excel?

Join the next cohort and build the spreadsheet skills that make your data work for you.

Enroll in Excel Course

Have questions? Contact us

Got any Questions?Chat with us