Excel Courses Potchefstroom
November 7, 2026
1-on-1
Live Online Training
From R3,750
Starting Price
Excel Courses Potchefstroom
Potchefstroom is a major North West university city where Excel skills are in demand among its student, academic and growing professional services community for data analysis and financial management.
School of IT offers live, 1-on-1 online Excel training in English — from absolute beginners through to advanced users who need to work with Power Query, dynamic array formulas and dashboard design. All sessions are delivered by a real Excel trainer via MS Teams or Google Meet, with flexible scheduling so you can study around your existing commitments from Potchefstroom.
Excel Level 1 — Fundamentals
R3,750
4 hours
Beginner
Build a confident foundation in Microsoft Excel — navigate workbooks, enter and format data, write essential formulas, and create clear business reports.
- ✓Navigate Excel’s interface — worksheets, ribbons, cell references and workbook structure
- ✓Enter, format and validate data using number formats, cell styles and data validation rules
- ✓Essential formulas — SUM, AVERAGE, COUNT, IF, VLOOKUP and cell referencing (relative vs absolute)
- ✓Create and format charts — bar, column, line and pie charts for business reporting
- ✓Print and share workbooks — page setup, print areas and workbook sharing options
Excel Level 2 — Intermediate
R4,500
6 hours
Intermediate
Take your Excel skills to the next level — master PivotTables, advanced lookup functions, conditional formatting and structured data models for business reporting.
- ✓PivotTables and PivotCharts — summarise, group and visualise large datasets quickly
- ✓Intermediate functions — XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS and AVERAGEIFS
- ✓Conditional formatting — highlight cells, data bars, colour scales and icon sets
- ✓Named ranges, Excel tables and structured references for organised data management
- ✓Protecting workbooks, sheets and cells for secure sharing across your team
Excel Level 3 — Advanced
R6,900
8 hours
Advanced
Master advanced Excel — dynamic array formulas, Power Query for data transformation, financial and statistical functions, and interactive Excel dashboards.
- ✓Dynamic array formulas — FILTER, SORT, UNIQUE, SEQUENCE, XLOOKUP and spill ranges
- ✓Power Query — connect to data sources, transform and reshape data, and automate refresh
- ✓Financial functions — NPV, IRR, PMT, FV and financial modelling best practices
- ✓Statistical functions — STDEV, FORECAST, regression analysis and what-if scenarios
- ✓Dashboard design — slicers, timelines, dynamic charts and interactive business reporting
Compare Excel Courses — 2026 Prices
Choose the course that fits your current skill level and professional goals:
| Course | Price | Hours | Level |
| Excel Level 1 — Fundamentals | R3,750 | 4 hours | Beginner |
| Excel Level 2 — Intermediate | R4,500 | 6 hours | Intermediate |
| Excel Level 3 — Advanced | R6,900 | 8 hours | Advanced |
All prices in ZAR and include courseware. Live 1-on-1 training delivered online from Potchefstroom.
What You Will Learn
From building your first workbook through to advanced analytics and dashboards — School of IT Excel training gives you skills that apply immediately in your workplace:
- ✓Build structured Excel workbooks with data validation, named ranges and table references
- ✓Write essential formulas — IF, VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS and dynamic arrays
- ✓Summarise and analyse datasets using PivotTables, PivotCharts, slicers and timelines
- ✓Transform and clean data using Power Query
- ✓Build Excel dashboards with interactive charts and conditional formatting
- ✓Apply financial and statistical analysis using Excel’s built-in tools
Excel Courses Potchefstroom — FAQs
Start Your Excel Training in Potchefstroom Today
Live 1-on-1 online instruction. Flexible scheduling. From R3,750. Commence anytime.
Enquire Now →