Advanced formulae in ExcelPrint course
Advanced formulae in Excel
Carbon Footprints, 10 Duke Wynd, Glasgow, G4 0WX
Members £100.00 / Non-Members £200.00
No dates for this event.
|Date:||No dates for this event.|
Who's it for and what's it about
This short half day course is designed for those already working with the basic Excel formulae but would now like to work with large sheets of numerical data and be able to create various scenarios.
- Work with SumIF, countIF and subtotal
- Exploring expanding IF functions with nesting, AND and OR
- Create lookup tables for comparisons
- Create alternative scenarios to view data
- Exploring how to work with other functions
Participants will be expected to already have a basic knowledge of Excel and now want to use some of the more advanced techniques to increase efficiency in the workplace.
Trainer: Debby Broughton-Hay