Skip to main content

Microsoft Excel 2010 advanced

This course introduces some of the more advanced functions available within Microsoft Excel 2010 and will encourage more efficient use of the application.

Level: Advanced
Duration: 1 day

Who is it for?

This course is for people who already use Microsoft Excel extensively in their work, and require the knowledge to be able to utilise the more advanced functions available within the program.

What does it cover?

On completion of this training course, participants will be able to use:

  • Pivot tables and pivot charts
  • Various functions to analyse and manipulate data
  • VLOOKUP and HLOOKUP
  • Nested functions
  • Subtotals
  • Data validation
  • Advanced filters
  • Goal seek and scenarios
  • Simple macros

Prerequisites

Delegates will be expected to have a good working knowledge of Microsoft Excel.

This course can be delivered in-house if required.

For further details or to book this course, please contact us via our online form, call our team on 01432 383500 or email training@hoopleltd.co.uk. You may also search for upcoming open courses on CPD Online.