Advanced Excel Training Course

Duration :1 DayCost: From £250
Venues :Manchester | Leeds | Birmingham | Glasgow | Online

Advanced Excel Training Course

Learn how to use advanced features of Excel to manipulate data and create detailed, useful spreadsheets on this 1 day, 5-star rated course.

  • 6 No more than 6 delegates
  • 5 star rated courses
  • Practice led learning
  • 3 month online support
  • Lunch & refreshments provided

Select from the tabs below to find out more:

Advanced Excel Course Dates

Browse all public Advanced Excel course dates below or use the filter to show only dates in specific locations.

Filter by venue:
  • Course Dates
  • Venue
  • 03 June 2024
  • Leeds
  • View
Private Course Enquiries

Private Advanced Excel Course

We are happy to run private Advanced Excel courses at your offices, at our Manchester office, or at a venue to suit you.

The course content can be adapted to suit your requirements.  Our trainer will contact you to discuss what you are looking to achieve and the level of prior knowledge the delegates have.

Private Advanced Excel courses are ideal if you have a number of people to train, or you want a different course outline; or simply can't make the dates of the public scheduled courses.

Private Course Costs:

The cost of any private courses is dependent on the number of delegates, the location, the length of the course (Half Day to Two Days) and the degree of adaption of the course. The following are for guidance only:

Private one to one classroom-based courses are available from £590 plus VAT

Private Group Courses in Excel are available from £690 plus VAT 

Online Private Advanced Excel Courses are available from £550 + VAT (6 hours).

To get a quote please complete the form below or call us on 0161 226 6032.

Private Advanced Excel Course Enquiry

google-logo.jpg
5
  • Quick Recap of Useful Introduction Features

    • Customising the quick access bar
    • Basic formulas including AutoSum, Min, Max and Average
    • Relative and absolute cell referencing
    • Naming cells
  • Analysing Data Using Pivot Tables

    • Produce a pivot table
    • Editing a pivot table’s data source
    • Refreshing pivot table data
    • Adding calculated fields
    • Creating slicers
    • Adding timelines (Office 2013 & above)
    • Linking slicers to other pivot tables
    • Filtering
    • Calculating percentages from data using calculated fields
    • Finding and taking care of blanks within a pivot table
    • Producing pivot charts
  • Excel Tables

    • Converting an Excel range into an Excel table
    • Using continuous formatting
    • Freeze panes and quick selection
    • Applying Slicers
    • Finding Duplicates
    • Converting back to Excel range
  • Conditional Formatting

    • Creating a conditional formatting rule
    • Editing the rule
    • Using Icon sets to format reports
  • IF and Nested IF Function

    • Performing calculation using a single-level IF Function
    • Creating calculations using Nested IF function or IFS, dependant on the version.
    • Understanding when to use IF and when to use VLookUp.
  • VLookUp Tables

    • Producing closest and exact match VLookUps
    • How to control errors in VLookUp tables using IFNA/Error function
    • Produce a HLookUp
    • Perform calculations using Index/Match.
    • Understand when to use VLookUp or IndexMatch.
  • Macros

    • Record a new macro
    • Perform basic editing using VBA
    • Add a macro to the quick access bar
    • Save a workbook containing a macro
  • Useful Functions

    • Concatenate
    • Left, Right, Trim and Proper
    • Text to columns
  • Data Validation

    • Applying data validation rules to cells for continuity
    • Adding drop-down arrows to cells for user selection
  • Workbook Security

    • Add a password to a workbook
    • Protecting worksheets
    • Protecting elements of a worksheet
    • Finding cells containing formulas and protecting the contents
    • Applying workbook security
  • Linking Workbooks

    • Create external links between books
    • Edit links
    • Break links
    • Open source workbooks

Manchester Advanced Excel Courses

Our Manchester Venue:

All our Advanced Excel Manchester courses are run from 9.30am to 4.30pm at our head office:

Rutherford House
Manchester Science Park
Pencroft Way
Manchester
M15 6SZ

Public Transport/Parking:

The closest public park is Cecil Street Car Park - 5 min walk

Manchester Oxford Road Train Station - 15 min walk

Manchester Piccadilly Train Station - 30 min walk

Access

Please let us know in advance if you have any mobility issues and will need any assistance.

More Information about our Manchester training courses, along with a map, can be found on our Manchester Training Page

Birmingham Advanced Excel Courses

Our Birmingham Venue:

Our public Advanced Excel courses in Birmingham are usually ran 9.30am to 4.30pm at:

Innovation Birmingham Campus,

Faraday Wharf,

Holt Street,

Birmingham,

B7 4BB

Public Transport /Parking:

Parking is available at Faraday Wharf and is located on Love Lane off Holt Street. Please note that parking here is charged and subject to availability. 

Both Birmingham Snow Hill and Birmingham Moor Street rail stations are situated just a short 15-minute walk away from the Innovation Birmingham Campus.

More Information about our Birmingham training courses, along with a map, can be found on our Birmingham Training page

Online Advanced Excel Courses

The Online Advanced Excel courses are run on Zoom.

You will be sent a link to join the training session the day before the course along with any course materials needed.

The courses run from 9:30 am to 4/4:30 pm. 

Because we limit the number of delegates to a maximum of 6 on our public courses specific timings are flexible, but generally, the day will run as follows:

9.20 am | Sign in

9.30 am | Start - First session

11.00 am | 15 min break

11.15 am |  Second session

12.30 pm  | 30 min break

1.00 pm  | Third session

2.15 pm | 15 min break

2.30 pm | Fourth session

3.50 pm | Finish & Q&A

4.30pm | End

Find out more about how our online courses work on the Online Courses Page

Leeds Advanced Excel Courses

Our Leeds Venue:

Our public Advanced Excel Courses in Leeds are start at 9.30 am and finish at 4 pm.

The courses are either held at:

West One,

100 Wellington Street,

Leeds,

LS1 4LT

(venue subject to change)

 

Public Transport /Parking:

There are a few public car parks close to the venue, the nearest is Wellington Street Multi-Story Car Park.

The venue is also only a 15 minute walk from Leeds Train Station.

More Information about our Leeds training courses, along with a map, can be found on our Leeds Training page

Advanced Excel Course Reviews

35
Other Courses You May Be Interested In
  • Beginners Excel Training Course

    intro-to-excel-banner.png This is a one day training course that gives you an introduction to using Microsoft Excel features and shortcuts. It is designed for anyone who only has a little (or no knowledge) of using Excel.
    Find out more
  • Project Management Course

    project management training manchester - mtraining.jpg A one day theory and practical skills course to enhance your project management skills.
    Find out more
  • Google Analytics

    Google Analytics Course This is a one day training course that will give you a good understanding of how to set up Google Analytics, how it works and what data you can obtain. In addition, it provides guidance on how to use the data to improve your website performance and your marketing.
    Find out more
  • Powerpoint Training Course

    Powerpoint Course Learn how to create a more impressive PowerPoint presentation using the extensive features of PowerPoint.
    Find out more
PEOPLE THAT HAVE ENJOYED OUR COURSES
  • AZ 2.png
  • Amazon
  • barclays-course.png
  • BC 2.png
  • Bt
  • Bupa
  • chanel 2.png
  • Jd Sports
  • Jet2com
  • Manchester client logo 8.png
  • Manchester City training 2.png
  • nestle training 2.png
  • Next
  • nhs-logo.png (1)
  • M Training Clients 10.png (1)
  • PTL-Manchester-training-client-logo-200.png
  • skym-courses.png (1)
  • client logo leeds.jpg
  • coop manchester 2.png
  • Tui
  • liverpool training 2.png
  • Siemens
  • Kraftheinz
  • HM Government
Click here to sign up for offers, advice and industry news Subscribe