Excel Advanced (2010, 2013, 2016 & Office 365)

Rated 4.50 out of 5 based on 4 customer ratings
(4 customer reviews)

£169.00

Product Description

This intensive hands-on one-day training course has been designed for users with a good understanding of Microsoft Excel 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Enquire Now!

How will I be trained?

Our Microsoft Excel training is tutor-led, interactive and classroom-based, which maximises learning through the ability to ask questions and discuss specific issues.

How big will my class be?

Maximum class size for Microsoft Excel courses is 10 delegates. This ensures that you will get adequate time for personal attention from the instructor.

We never cancel our scheduled classes — even if there are only one or two delegates — so once you have booked, your place is assured.

If you want training for larger groups at your offices, we can deliver exactly the same content (though with a little less interactivity) for classes of up to 15 delegates, provided they have their own PCs or laptops.

These “large class” courses are a great choice if you need to get a lot of people trained in a short space of time, and the cost per delegate allows you to get more people upskilled within a limited budget.

How do I book my place?

  • Decide on the Microsoft Excel course you want, the date(s) you can attend, and the number of delegates involved
  • Decide whether you want training at your offices or at our centre
  • You can use the ‘Enquire’ Now option to contact us for a quick price, or you can book online on this website
  • Call us at any time if you want help or advice. If you would like to book on the telephone, just call us on 01189 587763 to speak to one of our friendly course advisors
    Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.
  • If you are a private individual you must pay by credit card at the time of booking.
  • You will receive an official confirmation, with joining instructions (and directions if it’s at our centre)
  • Note: Please allow 1 – 2 working days for your confirmation.

What happens on the day?

If you are coming to our centre, dress code is smart casual. Tea/coffee/ water will be provided for morning and afternoon breaks, but please note that we do not provide lunch. The timetable is as follows:

9:15
Arrival time

9:30
Training starts

11:00
Mid-morning break

1:00
30 minute lunch break

3:15
Mid-afternoon break

4:30
Review and close

Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions!

For training at your offices, this itenerary can be varied by prior arrangement.

What do I get?

With every Microsoft Excel training course with Enliven Training, you get a free workbook with follow-on exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge.

Every delegate on a Microsoft Excel course also gets an Enliven Training Course Attendance Certificate.

This course covers Microsoft Excel.

Content covered:

Grouping & Outlining and Subtotals

  • Outlining and Grouping Data
  • Using the Subtotals Tool

What-If Analysis

  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver

PivotTables

  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers
  • Charting Pivoted Data
  • Getting Started with PivotCharts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart

Advanced Excel Tasks

  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks

Creating HLOOKUP and VLOOKUP Functions

  • Using the VLOOKUP Function
  • Using the LOOKUP Function

Introduction to Macros in Excel

  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros

4 reviews for Excel Advanced (2010, 2013, 2016 & Office 365)

  1. Rated 5 out of 5

    Viv R

    Great seminar! I learned a lot. Manager

  2. Rated 5 out of 5

    Alan T

    Learning new ways to use Excel will help me in my role – Alan T, Operations Manager

  3. Rated 4 out of 5

    Ollie A

    I would be able to put this training into practice – Ollie, Comms Manager

  4. Rated 4 out of 5

    Geoff G

    More knowledge of Excel gained – Geoff G, Clerk of the Course

Add a review

Your email address will not be published. Required fields are marked *