Microsoft Excel Intermediate

About the course

You know the basics — now it's time to work smarter. Excel Intermediate is designed for those who are comfortable in Excel and want to unlock its more powerful features for managing, analysing and presenting data.

Over four practical sessions, you'll learn to import, sort and filter data, apply conditional formatting, and use intermediate formulas including SUMIF, COUNTIF and logical functions like IF, AND and OR. You'll also be introduced to charting and PivotTables — two of Excel's most useful tools for turning raw data into meaningful insights.

Whether you're preparing reports, tracking information or analysing results, this course gives you the confidence to handle more complex data tasks in your everyday role.

Address for In Person sessions:

ICTS Training room 102.1
Level 1, Kramer Law Building
UCT Middle Campus
Rondebosch

Course content

• Apply advanced formatting including conditional formatting, styles and hyperlinks
• Import, sort, filter and subtotal data for clear reporting
• Use intermediate formulas: SUMIF, COUNTIF, AVERAGEIF and cell references
• Apply logic functions (IF, AND, OR) to automate decision-making in spreadsheets
• Look up data efficiently using XLOOKUP
• Build, format and customise charts using Quick Analysis tools
• Create and modify PivotTables and PivotCharts to summarise data
• Protect workbooks and manage data integrity

Certification

On successful completion of this course, participants receive a UCT ICTS Certificate of Completion. Attendance at all four sessions is required. Participants who miss more than one session will not qualify for certification.

Cost and registration

• External delegates: R1,500 - enrol directly through The Learning Store (below)
• UCT staff (permanent and T1–T2 contractors): No cost - register via SuccessFactors
• UCT staff with third party accounts: No cost - request a discount voucher code from icts-training@uct.ac.za BEFORE enrolling for the course

NB: Alternative (free) learning resource for staff and students: LinkedIn Learning

More Information

Read more: Microsoft Excel Intermediate
Email: icts-training@uct.ac.za
Phone: +27 (0)21 650 5392