Microsoft Excel Intermediate (2 days)
2 days
HRD Corp claimable
Runs in-house for your team
Overview
For clerks, officers, executives, supervisors, administrators and managers who know the Excel basics, this programme adds intermediate formulas, data tools and charts.
Participants set up range names with the Name Box, Define Name and Name Manager, then work through COUNTIFS, SUMIFS, nested IF and IFS, and the database functions DSUM, DCOUNT and DAVERAGE. They build Excel tables, sort and filter data and set data validation rules using lists, dates and formulas.
Later sessions cover conditional formatting, charts and sparklines, and page setup with Page Break Preview and custom views. The aim is that participants can summarise data by condition, keep data entry clean and present results in charts.
Module topics
- Cell references and range names
- Conditional summary and logical functions
- Database functions such as DSUM
- Excel tables and data validation
- Conditional formatting and charts
- Adding and editing sparklines
- Page views and multiple windows
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
1 day
2 days