Courses that have matched your search criteria

Workshops 1 day | Price: £195 + VAT

Finance & IT

Excel Advanced

Overview of course

Our Excel Advanced course is designed for the experienced user of Excel who wants to examine the more advanced and sophisticated features of Microsoft Excel. The aim of this Excel training course is to develop skills in the higher-level data analysis, formula building, formatting and automation features. Macro building is covered but Visual Basic for Applications (VBA) is the subject of a separate course.

You will train on the version of Excel that you use in your office or at home. Our courses are highly practical and interactive. All Open courses take place in our Exeter training suite, we supply laptops for use during the session. We limit the class size to 8 to ensure the tutor has time to deal with any specific queries you may have.

This course will equip you to utilise the advanced functions of Excel and is the highest level of Excel training that we offer as part of our Open training programme – further tuition can be provided, please contact the office for bespoke training details.

We provide training for both PC and Macs. Please contact the office for more details.

Who is it for?

A good knowledge of Excel is required for this programme. Knowledge of spreadsheet design, layout, formatting and automation is necessary. This course is designed for those who want to build on their existing Excel skills and learn the more complicated commands in Excel. Anyone who has successful completed our Excel Intermediate course and feels ready to progress their skills will enjoy this workshop.

What will you learn?

You will learn the more advanced functions of Excel enabling you to complete sophisticated tasks in Excel.

Course Content

  1. ‘What if’ forecasting using one and two variable data tables and scenarios.
  2. LOOKUP functions, Automatic Outline, using the form tools and scenario manager, excel macros.
  3. Restricting input using protection and data validation.
  4. Goal Seek and Solver analysis.
  5. Importing data into Excel.
  6. Navigation using hyperlinks, command buttons and sheet and range naming.
  7. ‘What if’ forecasting using one and two variable data tables and scenarios.
  8. Various Built In Functions
  9. Custom Formats
  10. Data Tables
  11. Automatic Outline
  12. Logical And/Ors
  13. Scenario Manager
  14. Protection
  15. Data Validation
  16. Goal Seek and Solver analysis
  17. Data Consolidation
  18. Macros – Record Only

Who is the trainer?

Nigel Hickman – Senior Crisp Associate

 You may also be interested in?

Get more for your money with our Learning Passport.  Find out more here

Download a PDF of this course

Thank you, your email has been sent.

Sorry, there was a problem sending, please try again.

Benefits of the course

By the end of the session you will feel……

…. like an expert in Excel! Well, certainly and extremely competent user of the advanced functions of the programme.

Other people like you who attented this course commented:

  • “Very good training session, stopped to help when I was lagging behind. Very relaxing surrounding, lunch was ace, staff even better, very attentive.”
  • “Another Excellent course which will be very useful for me using Excel day to day”

 

Date Tue 6 June 2017

Venue Compton House (directions)

working...

I would like to book for person

Date Tue 12 December 2017

Venue Compton House (directions)

working...

I would like to book for person

Cannot make these dates? Express an interest in the course and we will let you know when new dates are available

Please double check the form and try again

Thank you for letting us know!

Please enter your name

Please enter your email

Please enter your phone number

This is also available as an in house course - (for prices please contact us)