About this course
By the end of this Excel training course, you will be confident in using some of Excel’s more advanced features. You will be able to do more complex “what if” scenarios and use conditional formula and pivot tables to manipulate information.
What you will learn
In particular you will be able to:
- Move around a spreadsheet speedily using range names and even use them in formula to make them easier to read
- Use the auditing feature to check where the errors such as DIV?0 or NAME come from
- Create calculations based on conditions. For example, add a £10 bonus to all staff who have achieved results above target
- Use Hlookup and Vlooukup functions. For example, to look up how much poll tax should I pay based on the value of my house?
- Use Filters and Pivot Tables to help manipulate your data to find only the data you are interested in and make it easier to read
- Create macros to automate your work
- Assign a button on a toolbar to a macro to make it easier to use
Recent reviews
Paul was very helpful and a good trainer providing the knowledge and materials required to learn the basics in Macros and VBA.
Aishah C21 Nov 16
The course was designed for beginners and it achieved it's goal well. It covered the basics and helped individuals new to VBA get a good start into extending their Excel applications and spreadsheets.
John C21 Nov 16