Microsoft Excel Tools and Functions
This half-day course is designed for all users of Microsoft Excel, and shows how to work with various functions including lookup and text functions. It also covers styles and how to carry out what-if analysis.
Course Outline
- Learn how to use the IF function effectively
- See how to extract data from tables using LOOKUP and VLOOKUP functions
- Learn to manipulate text using the text functions
- Cover how to set up styles and spreadsheet templates
- Learn to discover new values using the goal seek tool
- See how to use the solver tool
Who would benefit from the course?
This course is designed for all users of Excel who want to improve functionality within their worksheets by using functions.
Pre-requisites
Delegates should be familiar with the rudimentary PC keyboard. A basic understanding of using Windows and familiarity with using a mouse would be an advantage.
