IN-STEP E.X.C.E.E.D. - Intensive Excel Functions and Formulas
1 day
HRD Corp claimable
Runs in-house for your team
Overview
This workshop is for clerks, officers, executives, supervisors, administrators and managers who already use Excel and want stronger formula skills. It concentrates on the functions that cut manual work and errors in everyday reports.
Participants practise on business scenarios. They start with cell, sheet, name and table references, then move to text functions such as LEFT and MID, logical tests with IF and date functions such as NETWORKDAYS. Later sessions cover FILTER, SORT, UNIQUE and SEQUENCE, how to fix spill errors, and XLOOKUP with partial and multiple-criteria matches.
By the end, participants can build formulas that update as the data changes and find specific records with XLOOKUP.
Module topics
- Cell, sheet, name and table references
- Statistical and text functions
- Logical, date and time functions
- Dynamic arrays with FILTER, SORT and UNIQUE
- XLOOKUP for exact, approximate and partial matches
Who runs this programme
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
2 days
Microsoft Excel
2 days
Microsoft Excel
2 days