Course details
Course description
Key Topics
- How to use scenarios
- How to use the solver tool
- Using spreadsheet auditing facilities
- Creating conditional formats
- Using data validation
- Using the data analysis tools
- Saving Excel templates
- Introduction to creating and running macros.
This 1 day course takes the skills learned in Introduction to Excel and Intermediate Excel, and moves to look at some more advanced Excel tools. It is particularly suited to those who use Excel as a means of modelling data to find solutions to problems
Entry requirements
Course options
Course details
Online
23rd Aug 2023 to 23rd Aug 2023
Cost: Visit the provider's website for details.
Venue details
Dumfries Campus
Bankend Road
Dumfries
DG1 4FD
Course details
Short course
23rd Aug 2023 to 23rd Aug 2023
Cost: Visit the provider's website for details.
Venue details
Dumfries Campus
Bankend Road
Dumfries
DG1 4FD