Learn to analyse and manipulate data, automate repetitive tasks and use advanced functions available in Microsoft Excel.
Who should attend?
Anyone with an understanding of Excel to an intermediate level that needs to use advanced functions and macros to enhance the design of their spreadsheets, as well as summarise and analyse data to produce statistical information.
Course overview
• Enter, edit and find data more effectively
• Sort data by multiple columns
• Summarise data instantaneously
• Summarise data in tables that can be changed and redesigned dynamically
• Extract and calculate values from a data list based on criteria you specify
• Complete complex or repetitive tasks easily
• Solve macro problems and modify your macros
• Add keyboard shortcuts, buttons and menu options to Excel spreadsheets to run macros
• Use logical functions to calculate values and outcomes based on criteria you specify
• Join text together from different cells
• Create custom number formats and apply conditional formatting
• When a formula is to complex to read, or if a spreadsheet becomes confusing, visually identify which cells areinvolved in a formula by using the auditing tools
Pre-requisites
A good knowledge of formula and functions, absolute referencing, paste special, date calculation, use Max, Counta, IF and VLOOKUP functions, Nest functions, sort data, use autofill and format numbers.
Duration
2 days
Price
Onsite: £645 + VAT per day
Offsite: £795 + VAT per day
