Understand where to use and how to create useful functions and how to analyse data with pivot tables.

Open participant course: £195 per person - maximum 10 people

Closed company course: £1,000 per course - maximum 10 people

Those who need to exploit the full potential of Excel to build powerful spreadsheets, including a wide array of formulae and functions. It is also suitable for those who also need to use Excel modelling tools to report on results.

By the end of the course, you will be able to create sophisticated spreadsheets, which include complex functions. You will be able to utilise analysis tools to summarise and extract data, use pivot tables, scenarios, and auditing tools. The use of macros will facilitate automating tasks.

Practical Functions:

• Statistical functions (COUNTIF and SUMIF).
• Logical functions (IF, AND and OR).
• Lookup and reference functions (VLOOKUP and HLOOKUP).
• Text functions.

Data Validation:

• Validating text, values, dates and lists.
• Validation input messages.
• Error message alerts.
• Locating invalid data.

Introducing Pivot Tables:

• Creating a pivot table.
• Drilling down on pivot data.
• Sorting, grouping and filtering pivot data.
• Summarise value fields.

Automating Spreadsheets with Macros:

• Recording and running macros.
• Deleting a macro.
• Macro virus protection.

This course can be delivered remotely or in a classroom environment, to suit your requirements.

Attendees should have a thorough grounding in building multiple sheet workbooks which include formulas and functions, such as SUMIF. They should also be able to create charts and use filter and sorting options. 

Attendees must have the following equipment to attend this training remotely:

• PC or laptop with a microphone and speakers (webcam is preferred but not essential).
• Access to the internet and web browser application (e.g. Google Chrome).
• Microsoft Excel installed on the PC or laptop.
• An email account for file sharing.
• A second screen is ideal but not essential.