Microsoft Excel Foundation to Intermediate
2 days
HRD Corp claimable
Runs in-house for your team
Overview
This programme takes clerks, officers, executives, supervisors, administrators and managers from the basics of Excel to intermediate skills for day-to-day business work.
The early sessions cover the interface, data entry, formatting, number formats and worksheet management, then formulas with SUM, AVERAGE, COUNT, MAX and MIN. Participants also compare workbooks side by side and set up reports for printing. The intermediate part adds relative and absolute references, named ranges, COUNTIF, SUMIF, IF and IFERROR, Excel tables with sorting and filtering, and charts.
By the end, participants can analyse data with conditional functions, manage it in tables and present it in charts.
Module topics
- Getting started in Excel
- Formatting reports and managing worksheets
- Basic formulas and functions
- Comparing worksheets and workbooks
- Setting up reports for printing
- Relative, absolute and named references
- Conditional and logical functions
- Managing data with Excel tables
- Charts and chart elements
At a glance
2 days
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
1 day
Microsoft Excel
2 days
Microsoft Excel
2 days