Microsoft Excel Training – Advanced

Description

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

• 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