Jump directly to main contentJump directly to menu

Advanced Excel

Apply or Enquire

The course covers some of the advanced features which Excel has available to its users.

The last section of the workshops gives you the opportunity to work on Excel in relation to your specific work related requirements. You may have a spreadsheet which is not fit for purpose, or is too complicated to understand. You may have ‘inherited’ a spreadsheet from a colleague who is no longer with your company, or you may be using a process which is pen/paper/calculator based and could be converted into Excel.
Please bring along your ‘troublesome’ spreadsheets to the workshop on a USB drive, removing any confidential information beforehand, and be prepared to outline your requirement to the other delegates on the course and to devise a solution for each scenario.


  • Duration

    1 day, 9.00 am - 4.00 pm

The course covers –
Conditional Formatting Using Formulas
Format Using a Formula – Check One Column
Format Using a Formula – Check the Whole Column
Apply to Whole Row
Apply Across Columns
Sorting Coloured Cells to the Top
Conditional Formatting to Text
Use of Sparklines
Create a Sparkline
Change the Style of, or Format Sparklines
Timeline Slicer
Create a Time Slicer
Filter the Data
Formulas / Functions INDEX/MATCH
OFFSET
Logical Operators – IF, AND, OR and NOT
PROPER, LOWER, UPPER TRIM
CONCATENATE
TEXT TO COLUMNS
LEFT, RIGHT, MID
IFERROR
NESTED IF Data
Data Validation with Formulas
Variable Length Named Ranges
What If – Scenario Manager, Goal Seek, Data Table
Forecast Sheet

 

Apply or enquire about this course

Please use the following links to make an application or enquiry about this course.

Apply online Make an enquiry 01724 294030

Course Fees

Course Fees - £130.00

Information for EU Students

From January 2021, how you apply for a course will change. For more information, read the UK Government's guide for the UK points-based immigration system for EU students (pdf).

Visit our International pages for more information and contact details