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

May 2020

Excel Advanced

May 7 @ 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

May 22 @ 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

June 4 @ 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

June 4 @ 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

July 2 @ 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

August 6 @ 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

August 18 @ 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

September 10 @ 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

October 8 @ 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

October 9 @ 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

November 12 @ 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

November 26 @ 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

December 8 @ 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

Register for a course

Choose Centre (required)
Name (required) Telephone (required) Email (required) Which course are you interested in? (required) Enquiry Allow Future Contact?