Advanced Microsoft Excel 2016 Training Courses

4.5
20 opinions
  • A great course to make you stop, think and re-address
    |
  • Extremely useful, excellent and approachable trainer
    |
  • Excellent trainer, very easy to understand and follow instructions
    |

In Twickenham

£ 295 + VAT

Description

  • Typology

    Short course

  • Location

    Twickenham

  • Duration

    1 Day

  • Start

    Different dates available

Description

This course aims to give delegates an in-depth knowledge of Excel 2016 features.



                              

Facilities

Location

Starts

Twickenham (Middlesex)
12 Northcote Road, TW1 1PA

Starts

Different dates availableNow taking bookings

To take into account

On completion of the course delegates will have advanced skills in using Microsoft Excel 2016. They will be able to:

Link multiple workbooks
Print workbooks
Use one and two-way data tables
Audit a worksheet
Create and use PivotTables and reports
Use Solver, Scenario Manager and Goal Seek tools
Use Excel workgroup features
Create and use macros

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Opinions

4.5
excellent
  • A great course to make you stop, think and re-address
    |
  • Extremely useful, excellent and approachable trainer
    |
  • Excellent trainer, very easy to understand and follow instructions
    |
100%
4.6
excellent

Course rating

Recommended

Centre rating

Graham Portors

4.0
09/10/2016
What I would highlight: A great course to make you stop, think and re-address
What could be improved: Nothing.
Would you recommend this course?: Yes

Jyoti Raunyar

4.0
19/07/2016
What I would highlight: Extremely useful, excellent and approachable trainer
What could be improved: Nothing.
Would you recommend this course?: Yes

Reuben Narayan

3.5
30/06/2016
What I would highlight: Excellent trainer, very easy to understand and follow instructions
What could be improved: Nothing.
Would you recommend this course?: Yes

Constance Leong

4.5
20/05/2016
What I would highlight: The course is good if you want it tailor-make the content to your organisation
What could be improved: N/A.
Would you recommend this course?: Yes

Karelle Leroy

4.5
15/05/2016
What I would highlight: Elly was very approachable and answered all our questions
What could be improved: Everything was positive.
Would you recommend this course?: Yes
See all
Reviews gathered by Emagister & iAgora

Achievements for this centre

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 11 years

Subjects

  • MS Excel
  • Excel
  • Microsoft excel training
  • Microsoft Excel
  • Recording macros
  • Running macros
  • Editing macros
  • SmartArt graphics
  • PivotTables
  • Tracing errors
  • Worksheet
  • Templates
  • Sorting
  • Accepting
  • Rejecting
  • Protection<br /> <br /> <br /> <br />

Course programme

Using multiple workbooks

Using a workspace
Printing workbooks

Printing and previewing multiple worksheets
Custom views
Display

Using one-input or two-input data tables
Protection

Protecting and unprotecting a worksheet with a password
Protecting and unprotecting designated cells in a worksheet with a password
Security

Adding password protection to a workbook
Removing password protection from a workbook
Creating a shared workbook

Tracking changes

Highlighting
Accepting
Rejecting
Sorting

Sorting data by multiple columns
Performing custom sorts
Querying/filtering

Creating a single or multiple criteria query using available options
Using advanced query/filter options
Templates

Using a template
Editing a template
Auditing a worksheet

Tracing errors
Tracing dependents
Tracing precedents
Adding, removing and editing worksheet comments
PivotTables and Reports

Creating a PivotTable report
Creating a PivotChart report
Resetting a summary function in a PivotTable report
Creating a PivotTable report for the World Wide Web
Data Analysis Tools

Goal Seek
Solver
Scenario manager
SmartArt graphics

Creating a SmartArt graphic
Formatting SmartArt
Changing SmartArt graphic layout
Changing SmartArt graphic colours
Macros

Recording macros
Running macros
Editing macros

Additional information

Course Type Cost per day
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT

Advanced Microsoft Excel 2016 Training Courses

£ 295 + VAT