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

September 2021

Excel Advanced

September 6 @ 09:00 - September 7 @ 17:00
|Recurring Event (See all)

One event on 23/02/2021 at 09:00

One event on 08/02/2021 at 09:00

One event on 17/03/2021 at 09:00

One event on 13/04/2021 at 09:00

One event on 14/05/2021 at 09:00

One event on 14/06/2021 at 09:00

One event on 23/06/2021 at 09:00

One event on 16/07/2021 at 09:00

One event on 28/07/2021 at 09:00

One event on 23/07/2021 at 09:00

One event on 06/09/2021 at 09:00

One event on 14/10/2021 at 09:00

One event on 10/11/2021 at 09:00

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

IT Tutor Led Timetable 2021: Classroom training delivered face to face in Glasgow and Edinburgh centres throughout the year. We also offer…

Find out more »

Microsoft Excel Advanced (1 day)

September 15 @ 09:00 - 17:00
|Recurring Event (See all)

One event on 11/03/2021 at 09:00

One event on 08/04/2021 at 09:00

One event on 12/05/2021 at 09:00

One event on 16/06/2021 at 09:00

One event on 06/07/2021 at 09:00

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

One event on 14/10/2021 at 09:00

One event on 18/11/2021 at 09:00

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

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

Classroom (attending in person) or Virtual Classroom (delivered remotely) training delivered with one of our tutors, running throughout 2020/2021 in Aberdeen. All…

Find out more »

October 2021

Excel Advanced

October 14 - October 15
|Recurring Event (See all)

One event on 23/02/2021 at 00:00

One event on 08/02/2021 at 09:00

One event on 17/03/2021 at 09:00

One event on 13/04/2021 at 09:00

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

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

One event on 23/06/2021 at 09:00

One event on 16/07/2021 at 00:00

One event on 28/07/2021 at 09:00

One event on 23/07/2021 at 09:00

One event on 06/09/2021 at 09:00

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

One event on 10/11/2021 at 09:00

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

IT Tutor Led Timetable 2021: Classroom training delivered face to face in Glasgow and Edinburgh centres throughout the year. We also offer…

Find out more »

Microsoft Excel Advanced (1 day)

October 14 @ 09:00 - 17:00
|Recurring Event (See all)

One event on 11/03/2021 at 09:00

One event on 08/04/2021 at 09:00

One event on 12/05/2021 at 09:00

One event on 16/06/2021 at 09:00

One event on 06/07/2021 at 09:00

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

One event on 14/10/2021 at 09:00

One event on 18/11/2021 at 09:00

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

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

Classroom (attending in person) or Virtual Classroom (delivered remotely) training delivered with one of our tutors, running throughout 2020/2021 in Aberdeen. All…

Find out more »

November 2021

Excel Advanced

November 10 @ 09:00 - November 11 @ 17:00
|Recurring Event (See all)

One event on 23/02/2021 at 09:00

One event on 08/02/2021 at 09:00

One event on 17/03/2021 at 09:00

One event on 13/04/2021 at 09:00

One event on 14/05/2021 at 09:00

One event on 14/06/2021 at 09:00

One event on 23/06/2021 at 09:00

One event on 16/07/2021 at 09:00

One event on 28/07/2021 at 09:00

One event on 23/07/2021 at 09:00

One event on 06/09/2021 at 09:00

One event on 14/10/2021 at 09:00

One event on 10/11/2021 at 09:00

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

IT Tutor Led Timetable 2021: Classroom training delivered face to face in Glasgow and Edinburgh centres throughout the year. We also offer…

Find out more »

Microsoft Excel Advanced (1 day)

November 18 @ 09:00 - 17:00
|Recurring Event (See all)

One event on 11/03/2021 at 09:00

One event on 08/04/2021 at 09:00

One event on 12/05/2021 at 09:00

One event on 16/06/2021 at 09:00

One event on 06/07/2021 at 09:00

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

One event on 14/10/2021 at 09:00

One event on 18/11/2021 at 09:00

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

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

Classroom (attending in person) or Virtual Classroom (delivered remotely) training delivered with one of our tutors, running throughout 2020/2021 in Aberdeen. All…

Find out more »

December 2021

Microsoft Excel Advanced (1 day)

December 14 @ 09:00 - 17:00
|Recurring Event (See all)

One event on 11/03/2021 at 09:00

One event on 08/04/2021 at 09:00

One event on 12/05/2021 at 09:00

One event on 16/06/2021 at 09:00

One event on 06/07/2021 at 09:00

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

One event on 14/10/2021 at 09:00

One event on 18/11/2021 at 09:00

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

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

Classroom (attending in person) or Virtual Classroom (delivered remotely) training delivered with one of our tutors, running throughout 2020/2021 in Aberdeen. All…

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?