What Are the 5 Basic Excel Skills Every SA Professional Needs in 2027?
Microsoft Excel is one of the most requested skills in SA job listings in 2027 — but most SA job seekers and employees don’t actually know which Excel skills SA employers mean when they say “proficient in Excel.” Here are the 5 fundamental Excel skills every SA professional needs, what they look like in practice, and how to build beyond them into the intermediate and advanced Excel skills that SA employers pay more for.
The 5 Basic Excel Skills SA Employers Expect in 2027
1
Navigating and Organising Data in Spreadsheets
The most basic Excel skill is understanding how Excel is organised — workbooks, worksheets, rows, columns, and cells — and being able to enter, edit, format, and organise data efficiently. SA employers expect anyone who claims basic Excel to be able to: enter and edit data without breaking formulas, format cells (number formats, currency, dates, text, percentages), use AutoFill to extend data series, freeze panes to keep headers visible while scrolling, and sort and filter data to find what they need. These are the entry-level SA Excel skills for administrative, reception, HR, and operations roles.
Key actions: Format cells → Sort/Filter → Freeze Panes → AutoFill
2
Basic Formulas and Functions (SUM, AVERAGE, COUNT, IF)
Formulas are what make Excel genuinely useful — transforming a spreadsheet from a table into a calculation engine. SA employers expect basic Excel users to write formulas confidently: SUM to add ranges, AVERAGE for averages, COUNT and COUNTA to count entries, MIN and MAX, and basic IF statements for simple conditional logic. Understanding cell references — relative (A1), absolute ($A$1), and mixed ($A1 or A$1) — is critical for writing formulas that work correctly when copied across rows and columns. SA professionals who understand cell references and can write a working IF formula are already ahead of a significant portion of South African office workers who claim Excel proficiency.
=SUM(B2:B100) | =AVERAGE(C2:C50) | =IF(D2>100,”Over”,”Under”)
3
Creating and Formatting Charts
SA employers across finance, marketing, HR, and operations expect Excel users to create clear, professional charts from data. Basic SA Excel chart skills include: creating bar, column, line, and pie charts from selected data, formatting chart titles, axis labels, and legends, choosing the right chart type for the data being displayed, and copying charts into SA Word documents and PowerPoint presentations. SA professionals who can produce a clean, correctly labelled Excel chart that communicates data clearly — without formatting it to look like a default Excel output — make a noticeably better impression in SA workplace reporting.
Insert → Chart → Select type → Format axes, title, legend
4
PivotTables — Summarising and Analysing Data
PivotTables are Excel’s most powerful basic-to-intermediate feature — and the Excel skill SA employers most commonly mention specifically in job requirements. A PivotTable lets you summarise hundreds or thousands of rows of SA data in seconds: total sales by SA region, headcount by SA department, revenue by SA product category. SA employers expect intermediate Excel users to build a PivotTable from raw data, group rows correctly, add calculated fields, and filter results with slicers. PivotTables are the entry point to real SA data analysis in Excel — once you understand them, you understand how most SA reporting and analysis spreadsheets are structured.
Insert → PivotTable → Drag fields → Group → Slicer → Refresh
5
VLOOKUP / XLOOKUP — Looking Up Data Across Sheets
VLOOKUP (and its modern replacement XLOOKUP, available in Microsoft 365) is the Excel formula SA employers most commonly test in SA interviews and assessments. XLOOKUP searches a column for a value and returns a corresponding value from another column — letting you match, enrich, and cross-reference SA data across spreadsheets. SA HR teams use it to match employee IDs to names. SA finance teams use it to match invoice numbers to amounts. SA operations teams use it to match product codes to descriptions. Understanding when to use XLOOKUP versus VLOOKUP, how to handle errors with IFERROR, and how to do two-way lookups with INDEX/MATCH is what SA employers mean when they say “intermediate Excel.”
=XLOOKUP(A2,Sheet2!A:A,Sheet2!B:B,”Not found”)
Beyond the Basics — SA Excel Skills by Career Level 2027
| SA Career Level | Excel Skills Required |
| SA Admin / Reception / Entry level | Skills 1–3: data entry, basic formulas, charts |
| SA Office / HR / Operations | Skills 1–5: all basics + PivotTables + XLOOKUP |
| SA Finance / Accounting roles | Basics + nested IFs, SUMIFS, financial functions, audit tools |
| SA Data Analyst roles | Advanced: Power Query, Power Pivot, complex formulas, dashboards |
| SA Financial Modelling roles | Expert: dynamic arrays, scenario modelling, VBA macros |
Most SA employees claim Excel proficiency — most mean skill level 1 or 2: SA research consistently shows that the majority of SA office workers who list “Microsoft Excel” on their CV can format cells and use SUM. Fewer than a third can build a working PivotTable from scratch. Under 15% can write a correct XLOOKUP formula without help. This gap is a real SA career opportunity — a SA professional who genuinely masters skills 1–5 above, plus Power Query and dashboard design, is significantly more valuable to SA employers than the average office worker who lists “Excel proficient” and means they can format a table. School of IT’s live 1-on-1 Excel training is designed to close that gap efficiently, with a SA instructor helping you build real skills at every step.
Master Excel With a SA Instructor — School of IT
Live 1-on-1 Microsoft Excel training. Formulas, PivotTables, XLOOKUP, Power Query, and Excel dashboards — taught by SA instructors who know what SA employers test. No matric. No prior experience. Start in 2027.
View Excel Courses