Microsoft Excel Formula Essentials
This half-day course is designed for all users of Microsoft Excel. It shows how to create your own formulas and start working with multiple worksheets and multiple files.
Course Outline
- Learn the difference between relative and absolute referencing and how it affects your formulas
- Cover working with multiple worksheets
- See how to create formulas that reference different worksheets
- Cover using formulas and hyperlinks to connect to different Excel files
- Learn how to set up multiple windows
Who would benefit from the course?
This course is designed for all users of Excel who want to move beyond working with single worksheets and wizard-based 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.
