Microsoft Excel Intermediate (1 day)
1 day
HRD Corp claimable
Runs in-house for your team
Overview
This programme is for clerks, officers, executives, supervisors, administrators and managers who know the Excel basics and want to do more with formulas, data and charts.
Participants practise relative, absolute and mixed references, then summarise data with COUNTA, AVERAGEA, COUNTIF, AVERAGEIF and SUMIF, and return results by condition with IF and IFERROR. They turn data ranges into tables, remove duplicates, sort and filter, and add subtotals. Conditional formatting, chart creation and chart formatting follow, along with arranging workbooks side by side for comparison.
Participants leave able to highlight values with conditional formatting and present data in clear, well-formatted charts.
Module topics
- Relative, absolute and mixed references
- Summary and conditional functions
- Organising data with Excel tables
- Conditional formatting rules
- Creating and formatting charts
- Managing multiple workbook windows
At a glance
1 day
In-house at your premises or a venue you choose
HRD Corp claimable
Prefer to chat? WhatsApp us on 012-600 4488.
Ask about this programme
Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.
More in this category
Microsoft Excel
2 days
Microsoft Excel
2 days