Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Course overview

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

Course duration

1 day

Delivery method

Flexible (Online/Classroom)

Costs

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

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

Suitable for

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.

Learning outcomes

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.

Course content

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.

Course requirements

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.

 


For more information about this course please contact us.


Queens Court Regent Street Barnsley South Yorkshire S70 2EG
Tel: 01226 216760 | Email: info@ind-training.co.uk | www.independenttrainingservices.co.uk

These course details were downloaded on 22/06/2021

https://www.independenttrainingservices.co.uk/courses-new/it-and-digital-skills/other/microsoft-excel-advanced-fast-track-1-day/

Enquire Now