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

January 2022

Microsoft Excel Advanced

January 26
|Recurring Event (See all)

One event on 14/12/2021 at 00:00

One event on 26/01/2022 at 00:00

One event on 15/03/2022 at 00:00

One event on 08/06/2022 at 00:00

One event on 17/08/2022 at 00:00

One event on 11/10/2022 at 00:00

One event on 14/01/2023 at 00:00

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

February 2022

Excel Advanced

February 15
|Recurring Event (See all)

One event on 05/05/2022 at 00:00

One event on 25/07/2022 at 00:00

One event on 10/10/2022 at 00:00

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

March 2022

Microsoft Excel Advanced

March 15
|Recurring Event (See all)

One event on 14/12/2021 at 00:00

One event on 26/01/2022 at 00:00

One event on 15/03/2022 at 00:00

One event on 08/06/2022 at 00:00

One event on 17/08/2022 at 00:00

One event on 11/10/2022 at 00:00

One event on 14/01/2023 at 00:00

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

Excel Advanced

March 16
|Recurring Event (See all)

One event on 15/09/2022 at 00:00

One event on 12/12/2022 at 00:00

Edinburgh, 4 Queen Street
Edinburgh, EH2 1JE United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

May 2022

Excel Advanced

May 5
|Recurring Event (See all)

One event on 05/05/2022 at 00:00

One event on 25/07/2022 at 00:00

One event on 10/10/2022 at 00:00

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

June 2022

Microsoft Excel Advanced

June 8
|Recurring Event (See all)

One event on 14/12/2021 at 00:00

One event on 26/01/2022 at 00:00

One event on 15/03/2022 at 00:00

One event on 08/06/2022 at 00:00

One event on 17/08/2022 at 00:00

One event on 11/10/2022 at 00:00

One event on 14/01/2023 at 00:00

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

July 2022

Excel Advanced

July 25
|Recurring Event (See all)

One event on 05/05/2022 at 00:00

One event on 25/07/2022 at 00:00

One event on 10/10/2022 at 00:00

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

August 2022

Microsoft Excel Advanced

August 17
|Recurring Event (See all)

One event on 14/12/2021 at 00:00

One event on 26/01/2022 at 00:00

One event on 15/03/2022 at 00:00

One event on 08/06/2022 at 00:00

One event on 17/08/2022 at 00:00

One event on 11/10/2022 at 00:00

One event on 14/01/2023 at 00:00

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

September 2022

Excel Advanced

September 15
|Recurring Event (See all)

One event on 15/09/2022 at 00:00

One event on 12/12/2022 at 00:00

Edinburgh, 4 Queen Street
Edinburgh, EH2 1JE United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

October 2022

Excel Advanced

October 10
|Recurring Event (See all)

One event on 05/05/2022 at 00:00

One event on 25/07/2022 at 00:00

One event on 10/10/2022 at 00:00

Glasgow, First Floor 82 Union Street
Glasgow, G1 3QS United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

Microsoft Excel Advanced

October 11
|Recurring Event (See all)

One event on 14/12/2021 at 00:00

One event on 26/01/2022 at 00:00

One event on 15/03/2022 at 00:00

One event on 08/06/2022 at 00:00

One event on 17/08/2022 at 00:00

One event on 11/10/2022 at 00:00

One event on 14/01/2023 at 00:00

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

December 2022

Excel Advanced

December 12
|Recurring Event (See all)

One event on 15/09/2022 at 00:00

One event on 12/12/2022 at 00:00

Edinburgh, 4 Queen Street
Edinburgh, EH2 1JE United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »

January 2023

Microsoft Excel Advanced

14/01/2023
|Recurring Event (See all)

One event on 14/12/2021 at 00:00

One event on 26/01/2022 at 00:00

One event on 15/03/2022 at 00:00

One event on 08/06/2022 at 00:00

One event on 17/08/2022 at 00:00

One event on 11/10/2022 at 00:00

One event on 14/01/2023 at 00:00

Aberdeen, 469 Union Street
ABERDEEN, AB11 6DB United Kingdom

For individuals who are already using Excel to an advanced level. This course will teach you how to use excel to analyse, collaborate…

Find out more »
+ Export Events

Flexible Workforce Development Fund (FWDF)

Claim up to £15,000 for Training your employees

This fund provides Levy Paying Companies an opportunity to up-skill or re-skill Employees and in turn, support economic growth.

Eligibility Criteria:

  • You must be a Levy Paying Employer
  • The Company must be based or operate in Scotland, wholly or partially
  • Employees must reside in Scotland

For more information on applying for this funding, contact our Course Advisors by clicking below:

———–

A funded training opportunity is now available to those facing redundancy or those who have been made redundant from March 2020 onward.

The National Transition Training Fund aims to tackle the rise in unemployment caused by Covid-19 by offering short sharp training opportunities for people to learn in-demand skills.

If you are currently under threat of redundancy, or have been made redundant at any time from the 1st March 2020 and are aged 25 or over, you can access an industry recognised qualification to help you gain employment.

For further information on how to proceed then contact us referencing the course(s) you are interested in.

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?