CALL FREE ON 0800 220454

Excel Advanced – Tutor led

The Microsoft Excel Advanced training course is available at the Edinburgh, Glasgow, Aberdeen and Inverness Pitman Training Centres.

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate and validate data. These tools are extremely useful for auditing and streamlining your workflow.

Course Duration: 1 Day

The Adobe Acrobat training course is available at the Edinburgh, Glasgow, Aberdeen and Inverness Pitman Training Centres.

In this course you will learn how to create, convert and share documents through the universal Acrobat PDF format to produce interactive, media rich and secure publications for Print or Web.

This course is designed for people who are collating documents with multiple contributors or publishing to a variety of mediums.

Course Duration: 1 Day

Microsoft Excel

Streamlining Workflow: Create & edit macros, Visual Basic for Applications, Visual Basic Editor Window, customising Access to Excel commands, applying conditional formatting, adding data validation criteria, update workbook’s properties, modifying excel’s default settings

Collaborating with Others: Protecting files, sharing workbooks, setting revision tracking, review tracked revisions, merge workbooks, adjust macro settings, digital signatures, digital certificates

Auditing Worksheets: Trace cell Precedents, trace cell dependants, locate errors in formulas, invalid data, error checking, watch and evaluate formulas, group and outline data

Analysing Data: Trend lines, scenarios, goal seek, solver, PivotTable reports, PivotChart reports, Analysis ToolPak

Working with Multiple Workbooks: Workspaces, data consolidation, link cells in different workbook, edit links

Importing and Exporting Data: Export to Microsoft Word, import Word table, import text files

Structuring XML Workbooks: Develop XML maps, import/add/export XML data, manage XML workbooks, apply XML view options

On successful completion of this workshop you will be able to support other users and analyse your data in greater detail.

Loading Events

Upcoming Events › Excel Advanced

Events Search and Views Navigation

Event Views Navigation

November 2019

Excel Advanced

November 27 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 10/10/2018 at 09:30

One event on 01/02/2019 at 09:30

One event on 08/04/2019 at 09:30

One event on 05/06/2019 at 09:30

One event on 12/08/2019 at 09:30

One event on 11/10/2019 at 09:30

One event on 23/05/2019 at 09:30

One event on 27/11/2019 at 09:30

One event on 13/01/2020 at 09:30

One event on 05/02/2020 at 09:30

One event on 07/04/2020 at 09:30

One event on 22/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 18/08/2020 at 09:30

One event on 09/10/2020 at 09:30

One event on 26/11/2020 at 09:30

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
Find out more »

January 2020

Excel Advanced

13/01/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 10/10/2018 at 09:30

One event on 01/02/2019 at 09:30

One event on 08/04/2019 at 09:30

One event on 05/06/2019 at 09:30

One event on 12/08/2019 at 09:30

One event on 11/10/2019 at 09:30

One event on 23/05/2019 at 09:30

One event on 27/11/2019 at 09:30

One event on 13/01/2020 at 09:30

One event on 05/02/2020 at 09:30

One event on 07/04/2020 at 09:30

One event on 22/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 18/08/2020 at 09:30

One event on 09/10/2020 at 09:30

One event on 26/11/2020 at 09:30

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
Find out more »

February 2020

Excel Advanced

05/02/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 10/10/2018 at 09:30

One event on 01/02/2019 at 09:30

One event on 08/04/2019 at 09:30

One event on 05/06/2019 at 09:30

One event on 12/08/2019 at 09:30

One event on 11/10/2019 at 09:30

One event on 23/05/2019 at 09:30

One event on 27/11/2019 at 09:30

One event on 13/01/2020 at 09:30

One event on 05/02/2020 at 09:30

One event on 07/04/2020 at 09:30

One event on 22/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 18/08/2020 at 09:30

One event on 09/10/2020 at 09:30

One event on 26/11/2020 at 09:30

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
Find out more »

Excel Advanced

06/02/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

March 2020

Excel Advanced

12/03/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

April 2020

Excel Advanced

02/04/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

Excel Advanced

07/04/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 10/10/2018 at 09:30

One event on 01/02/2019 at 09:30

One event on 08/04/2019 at 09:30

One event on 05/06/2019 at 09:30

One event on 12/08/2019 at 09:30

One event on 11/10/2019 at 09:30

One event on 23/05/2019 at 09:30

One event on 27/11/2019 at 09:30

One event on 13/01/2020 at 09:30

One event on 05/02/2020 at 09:30

One event on 07/04/2020 at 09:30

One event on 22/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 18/08/2020 at 09:30

One event on 09/10/2020 at 09:30

One event on 26/11/2020 at 09:30

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
Find out more »

May 2020

Excel Advanced

07/05/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

Excel Advanced

22/05/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 10/10/2018 at 09:30

One event on 01/02/2019 at 09:30

One event on 08/04/2019 at 09:30

One event on 05/06/2019 at 09:30

One event on 12/08/2019 at 09:30

One event on 11/10/2019 at 09:30

One event on 23/05/2019 at 09:30

One event on 27/11/2019 at 09:30

One event on 13/01/2020 at 09:30

One event on 05/02/2020 at 09:30

One event on 07/04/2020 at 09:30

One event on 22/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 18/08/2020 at 09:30

One event on 09/10/2020 at 09:30

One event on 26/11/2020 at 09:30

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
Find out more »

June 2020

Excel Advanced

04/06/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 10/10/2018 at 09:30

One event on 01/02/2019 at 09:30

One event on 08/04/2019 at 09:30

One event on 05/06/2019 at 09:30

One event on 12/08/2019 at 09:30

One event on 11/10/2019 at 09:30

One event on 23/05/2019 at 09:30

One event on 27/11/2019 at 09:30

One event on 13/01/2020 at 09:30

One event on 05/02/2020 at 09:30

One event on 07/04/2020 at 09:30

One event on 22/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 18/08/2020 at 09:30

One event on 09/10/2020 at 09:30

One event on 26/11/2020 at 09:30

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
Find out more »

Excel Advanced

04/06/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

July 2020

Excel Advanced

02/07/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

August 2020

Excel Advanced

06/08/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

Excel Advanced

18/08/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 10/10/2018 at 09:30

One event on 01/02/2019 at 09:30

One event on 08/04/2019 at 09:30

One event on 05/06/2019 at 09:30

One event on 12/08/2019 at 09:30

One event on 11/10/2019 at 09:30

One event on 23/05/2019 at 09:30

One event on 27/11/2019 at 09:30

One event on 13/01/2020 at 09:30

One event on 05/02/2020 at 09:30

One event on 07/04/2020 at 09:30

One event on 22/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 18/08/2020 at 09:30

One event on 09/10/2020 at 09:30

One event on 26/11/2020 at 09:30

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
Find out more »

September 2020

Excel Advanced

10/09/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

October 2020

Excel Advanced

08/10/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

Excel Advanced

09/10/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 10/10/2018 at 09:30

One event on 01/02/2019 at 09:30

One event on 08/04/2019 at 09:30

One event on 05/06/2019 at 09:30

One event on 12/08/2019 at 09:30

One event on 11/10/2019 at 09:30

One event on 23/05/2019 at 09:30

One event on 27/11/2019 at 09:30

One event on 13/01/2020 at 09:30

One event on 05/02/2020 at 09:30

One event on 07/04/2020 at 09:30

One event on 22/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 18/08/2020 at 09:30

One event on 09/10/2020 at 09:30

One event on 26/11/2020 at 09:30

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
Find out more »

November 2020

Excel Advanced

12/11/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »

Excel Advanced

26/11/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 10/10/2018 at 09:30

One event on 01/02/2019 at 09:30

One event on 08/04/2019 at 09:30

One event on 05/06/2019 at 09:30

One event on 12/08/2019 at 09:30

One event on 11/10/2019 at 09:30

One event on 23/05/2019 at 09:30

One event on 27/11/2019 at 09:30

One event on 13/01/2020 at 09:30

One event on 05/02/2020 at 09:30

One event on 07/04/2020 at 09:30

One event on 22/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 18/08/2020 at 09:30

One event on 09/10/2020 at 09:30

One event on 26/11/2020 at 09:30

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom
Find out more »

December 2020

Excel Advanced

08/12/2020 @ 09:30 - 16:00
|Recurring Event (See all)

One event on 23/10/2018 at 09:30

One event on 22/03/2019 at 09:30

One event on 23/08/2019 at 09:30

One event on 06/02/2020 at 09:30

One event on 12/03/2020 at 09:30

One event on 02/04/2020 at 09:30

One event on 07/05/2020 at 09:30

One event on 04/06/2020 at 09:30

One event on 02/07/2020 at 09:30

One event on 06/08/2020 at 09:30

One event on 10/09/2020 at 09:30

One event on 08/10/2020 at 09:30

One event on 12/11/2020 at 09:30

One event on 08/12/2020 at 09:30

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom
Find out more »
+ Export Events

For more information on this or any of our courses complete the form

Course Enquiry

Choose Centre (required)

Name (required)

Email (required)

Telephone (required)

Which course are you interested in? (required)

Enquiry

Terms & Conditions: We will only use the information you have provided to contact you regarding your enquiry about our courses.

Tick here to accept the term of this form submission

Future ContactTick here to also allow us to keep in touch with you about available funding, new courses and future dates

You are human aren't you?