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

Rated 4.67 out of 5 based on 3 customer ratings
(3 customer reviews)

£189.00

Product Description

​This interactive one-day training course has been designed for delegates with a solid understanding of, and experience with, Microsoft Excel who want to increase their ability in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advanced 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:

Advanced Conditional Formatting

  • Editing Standard Formatting Rules
  • Using Formulas in Conditional Formatting
  • Using Form Controls and Templates
  • Using Form Controls
  • Creating Templates

Advanced Lookup Functions

  • Using the Index Function
  • Using the Match Function
  • Using Index and Match Together
  • Using Index and Match with Array Formula
  • Using the Indirect Function

Advanced Functions in Excel

  • Using Error Functions
  • Using Logical Functions
  • Using Array Formulas
  • Using Rounding Functions

Advanced Pivot Table Tools

  • Importing Pivot Table Data
  • Calculated Fields in Pivot Tables
  • Showing Pivot Data as a Percentage
  • Creating Custom Pivot Tables Styles

Introduction to User Defined Functions Using VBA

  • Creating a User Defined Function
  • Creating an Interactive Procedure
  • Create and Share a Function Add-in

3 reviews for Excel Professional (2010, 2013, 2016 & Office 365)

  1. Rated 5 out of 5

    Edward D

    Really improved my Excel skills. I’m a guru at work now! Edward D, Engineer

  2. Rated 5 out of 5

    Connie

    Really enjoyed learning Pivot tables!

  3. Rated 4 out of 5

    Sharon M

    Good overview of Excel plus learnt new things, eg. IF functions, lookups – Sharon M, Accounts

Add a review

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