Contact
Need Help? 0141 550 7595
About SHARE

Learning & development

Advanced formulae in Excel

Print course

Advanced formulae in Excel

Date: No dates for this event.
Course duration: 1 day
Venue: Carbon Footprints, 10 Duke Wynd, Glasgow, G4 0WX
Costs: Members £100.00 / Non-Members £200.00

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.

Learning outcomes

  • 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


Further Information

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