MS Excel Intermediate Training South Africa
Microsoft Excel Intermediate – Formulas, Data & Everyday Reporting is a practical one-day course for employees who already understand the basics of Excel and now need to work more confidently with formulas, business data, worksheets and everyday reporting.
The course builds the bridge between MS Excel Basic and College Africa Group’s Advanced Excel Training pathway.
Delegates work with practical workplace examples covering formula references, named ranges, logical formulas, dates, structured business data, sorting and filtering, Excel Tables, Conditional Formatting, multiple worksheets, workbook links and charts.
College Africa Group provides instructor-led MS Excel Intermediate training in South Africa for corporate teams through onsite and virtual delivery.
Duration: One day
Typical training time: 09h00–15h30
Delivery: Onsite or instructor-led virtual training
Level: Intermediate
Certificate: Electronic Certificate of Attendance
Who Should Attend MS Excel Intermediate?
MS Excel Intermediate is suitable for employees who already use Excel and understand the basic spreadsheet environment but need stronger skills for everyday workplace calculations, data management and reporting.
Typical delegates include employees working in:
- Finance and accounts
- HR and payroll
- Administration
- Sales and customer support
- Operations and logistics
- Project administration
- Procurement
- Reporting and business support
Delegates should already be comfortable entering and editing information, creating simple formulas, formatting worksheets and performing basic Excel tasks.
If these foundations are not yet secure, start with MS Excel Basic Training.
Not Sure Whether Basic or Intermediate Excel Is Appropriate?
Employees often describe themselves as Beginner, Intermediate or Advanced Excel users based on how long they have used Excel. This does not always reflect what they can actually do.
College Africa Group’s practical Excel Skills Assessment can help organisations identify important skill gaps and determine whether an employee should strengthen their Basic Excel foundation or may be ready for Intermediate or higher-level training.
View the Excel Skills Assessment
MS Excel Intermediate Course Objectives
By the end of the course, delegates should be able to:
- Work more efficiently with worksheets, ranges and common Excel productivity tools
- Understand relative, absolute and mixed cell references
- Create and use named ranges
- Use IF formulas in practical business calculations
- Work confidently with Excel dates and date calculations
- Structure business data correctly
- Sort and filter information using multiple criteria
- Convert ordinary ranges into Excel Tables
- Use Conditional Formatting to identify exceptions and trends
- Work effectively across multiple worksheets
- Create simple links between Excel workbooks
- Create and edit charts for everyday business reporting
- Combine Intermediate Excel skills in a practical workplace exercise
Download the MS Excel Intermediate Course Outline
Download the complete Microsoft Excel Intermediate – Formulas, Data & Everyday Reporting course outline.
View / Download MS Excel Intermediate Course Outline (PDF)
MS Excel Intermediate Course Content
1. Working More Efficiently in Excel
- Review of essential Excel foundations
- Efficient worksheet navigation
- Selecting and working with ranges
- Copying and moving data effectively
- Using AutoFill and productivity shortcuts
- Understanding common spreadsheet errors
2. Formula References
- Relative cell references
- Absolute cell references
- Mixed cell references
- Copying formulas correctly
- Practical exercises using different reference types
3. Named Ranges
- Understanding named ranges
- Creating simple named ranges
- Using names in formulas
- Editing and managing basic range names
- Practical price-list exercise using named ranges
4. Logical Formulas
- Understanding logical tests
- Using the IF function
- TRUE and FALSE results
- Text and numeric results
- Combining IF with practical business calculations
- Troubleshooting common IF formula errors
5. Working with Dates
- How Excel stores dates
- Entering and formatting dates correctly
- Date arithmetic
- TODAY
- DAY, MONTH and YEAR
- Calculating periods between dates
- Practical date-based workplace calculations
6. Working with Business Data
- Structuring data correctly
- Good list and dataset design
- Finding and replacing information
- Removing duplicate records
- Preparing data for sorting, filtering and reporting
7. Sorting and Filtering
- Single-level sorting
- Multi-level sorting
- Sorting by different fields
- Applying filters
- Custom filters
- Filtering text, numbers and dates
- Clearing and reapplying filters
- Practical business-data exercises
8. Excel Tables
- Converting a data range into an Excel Table
- Understanding the benefits of Tables
- Table styles and formatting
- Automatic expansion
- Sorting and filtering Tables
- Total Row
- Adding calculated columns
- Working efficiently with structured business data
9. Conditional Formatting
- Understanding Conditional Formatting
- Highlight Cells Rules
- Top/Bottom Rules
- Duplicate values
- Data Bars
- Colour Scales
- Icon Sets
- Creating and editing rules
- Managing rule priority
- Using Conditional Formatting to identify exceptions and trends
- Introduction to a simple formula-based Conditional Formatting rule
- Practical workplace examples
10. Working with Multiple Worksheets
- Creating and organising worksheets
- Renaming worksheets
- Moving and copying worksheets
- Working with multiple sheets
- Creating formulas between worksheets
- Linking information between worksheets
- Freeze Panes
- Basic worksheet protection
11. Linking Workbooks
- Understanding workbook links
- Creating simple links between workbooks
- Updating linked information
- Basic considerations when moving or sharing linked workbooks
12. Intermediate Charts
- Selecting appropriate data for charts
- Creating charts from business data
- Choosing an appropriate chart type
- Editing chart elements
- Titles, labels and legends
- Basic chart formatting
- Presenting business information clearly
13. Integrated Workplace Exercise
Delegates apply the Intermediate skills to a practical business workbook. The exercise brings the course together by requiring delegates to:
- Work with a structured dataset
- Create formulas using relative, absolute and mixed references
- Use a named range in a practical calculation
- Apply an IF formula
- Work with dates
- Sort and filter business information
- Convert data into an Excel Table
- Apply Conditional Formatting to highlight exceptions
- Work across multiple worksheets
- Produce a simple chart or report
Practical Intermediate Excel for the Workplace
The purpose of Intermediate Excel training is not simply to introduce more Excel features. Employees need to understand how the different skills work together when dealing with real business spreadsheets.
Typical applications include maintaining structured employee or customer information, calculating values using fixed references, identifying exceptions, analysing lists, working across worksheets, preparing recurring reports and presenting information using charts.
The integrated workplace exercise gives delegates an opportunity to combine the individual skills rather than practising each Excel feature in isolation.
Progress From Basic to Intermediate to Advanced Excel
College Africa Group provides a structured Excel training pathway, but employees do not have to attend every course simply because it comes next in a sequence.
The appropriate course depends on existing capability and the work the employee needs to perform.
Excel training pathway:
- MS Excel Basic – foundation Excel skills for everyday spreadsheet work
- MS Excel Intermediate – formulas, data management and everyday reporting
- Advanced Excel Training – choose the advanced course that best matches the employee’s work requirements
Advanced Excel Courses After Intermediate
Employees who have the necessary foundations can progress from Intermediate Excel into the most appropriate Advanced Excel course.
Formulas & Reporting
For employees who need stronger formula-building, data-control, PivotTable and reporting capability.
Business Modelling
For employees who need to use Excel for XLOOKUP, What-If Analysis, Goal Seek, Scenario Manager, Data Tables and practical business modelling.
Modern Excel 365
For experienced Excel users who need to understand newer Microsoft 365 functionality, Dynamic Arrays and modern approaches to formulas, data and productivity.
View the complete Advanced Excel Training pathway
MS Excel Intermediate Training for Corporate Teams
College Africa Group specialises in practical corporate Excel training for organisations in South Africa and Southern Africa.
Training can be delivered onsite or through instructor-led virtual sessions. Corporate programmes can also combine Excel Skills Assessment with Basic, Intermediate and Advanced Excel training where employees have different existing skill levels.
Where appropriate, practical examples can be related to the types of spreadsheets employees use in areas such as finance, HR, administration, operations, sales and reporting.
When Training Alone Is Not the Excel Problem
Sometimes employees already understand Excel but still spend excessive time updating repetitive reports, copying information between worksheets, correcting inefficient spreadsheets or completing recurring manual processes.
In these situations, additional training may not be the only solution.
College Africa Group also provides Excel consulting and automation support where organisations need to improve existing spreadsheets, reporting processes or repetitive Excel workflows.
Why Choose College Africa Group for Excel Training?
- Corporate training experience since 2003
- Practical workplace-focused Excel training
- Structured Basic, Intermediate and Advanced Excel pathways
- Excel Skills Assessment available before training
- Onsite and instructor-led virtual delivery
- Practical exercises and supporting course material
- Electronic attendance certificates
- Advanced Excel, consulting and automation support where required
- B-BBEE Level 2 company
Frequently Asked Questions About MS Excel Intermediate
Who should attend MS Excel Intermediate?
MS Excel Intermediate is designed for employees who already understand the basic Excel environment and need stronger skills in formulas, business data, sorting and filtering, Tables, Conditional Formatting, multiple worksheets and everyday reporting.
What should delegates know before attending?
Delegates should be comfortable entering and editing data, creating simple formulas, formatting worksheets and performing ordinary Basic Excel tasks. Employees who still need these foundations should consider MS Excel Basic first.
How long is the MS Excel Intermediate course?
The course is one day and normally runs from approximately 09h00 to 15h30.
Does the Intermediate course include practical exercises?
Yes. Delegates complete practical exercises throughout the course as well as an integrated workplace exercise that combines the main Intermediate Excel skills.
Does the course cover IF formulas?
Yes. Delegates learn how to use IF with practical business calculations and how to troubleshoot common IF formula errors.
Does MS Excel Intermediate cover sorting, filtering and Excel Tables?
Yes. The course includes sorting and filtering business information, custom filters, Excel Tables, Total Rows and calculated columns.
What comes after MS Excel Intermediate?
Employees with the appropriate foundations can progress into College Africa Group’s Advanced Excel Training pathway, including Formulas & Reporting, Business Modelling and Modern Excel 365.
How do we know whether employees should attend Basic, Intermediate or Advanced Excel?
The Excel Skills Assessment can provide a practical indication of existing Excel capability and help identify an appropriate starting point for training.
Enquire About MS Excel Intermediate Training
Tell us how many employees require training, their current Excel experience, your preferred delivery method and what they need to achieve with Excel.
Arnold Muscat: 083 778 4903
Email: sales@collegeafricagroup.com