Duration: 1 day (6.5 hours)
Cost: £260 +VAT per person (prices vary for bespoke courses – please enquire)
Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data.
This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending.
By the end of the course you will be able to:
- Use a range of Text functions to manage text data
- Create and use different types of date and time functions
- Work with rounding functions
- Use logical statements
- Build nested formula
- Use SUMIF, COUNTIF and AVERAGEIF
- Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions
- Use IS functions and IFERROR to test cell values