Microsoft Excel: Advanced

Loading Events

« All Events

  • This event has passed.

Microsoft Excel: Advanced

February 8th at 9:00 am - 4:30 pm

|Recurring Event (See all)

One event on 18th October 2023 at 9:00 am

One event on 8th November 2023 at 9:00 am

One event on 6th December 2023 at 9:00 am

One event on 12th January 2024 at 9:00 am

One event on 25th January 2024 at 9:00 am

One event on 8th February 2024 at 9:00 am

One event on 29th February 2024 at 9:00 am

One event on 7th March 2024 at 9:00 am

One event on 27th March 2024 at 9:00 am

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham


A 1 Day Advanced Course, aimed at users that have attended the previous stages or experienced users. This course aims to extend the users knowledge with more tools and commands. By the end of the course, users will be able use features including Goal Seek, Data Tables, Scenario Manager and Macros.


Refresh on Formulas

  • Quick refresh on commonly used formulas in Excel
  • VLOOKUP formula
  • IF Logical Tests
  • SUMIF formula
  • COUNTIF formula



  • How to consolidate your excel data from multiple locations
  • Bringing together data from multiple sources
  • Viewing multiple worksheets
  • Viewing multiple workbooks


Text Manipulation

  • Analysing Data from external Sources.
  • Use basic Text Formulas
  • Format data using Text to Columns
  • Connect to an external Data Source using OBDC Connectors


What if Analysis

  • Forecasting return figures for business
  • Goal Seek
  • Data Tables
  • Scenario Manager



  • How to use the form controls to make filling in spreadsheets quicker and easier for your users
  • Command Buttons
  • Check Boxes
  • Scroll Boxes
  • Dropdown lists
  • Data Validation



  • Introduces the user to the basics of macros
  • Creating macros
  • Editing macros
  • Running Macros
  • Macro Security
  • Assign a macro to a command button


Customising Excel

  • Customising excels default settings Modify existing toolbars
  • Create custom toolbars
  • Create and edit menu bars


February 8th
9:00 am - 4:30 pm
Event Categories:
, , , ,


South Yorkshire United Kingdom


Chamber Skills Solutions
01709 386200


Enquiry Only
Is Inquirable

Book this training course