Microsoft Excel Advanced

Course Duration is 1 Day

From: £295.00 Plus VAT (per person)

Have more than 2 delegates? Talk to us about our closed group courses.

Delivery Method

Open Public Courses – Virtual Delivery Only  Closed Group Courses – Face To Face and Virtual Delivery

Business Benefit

Everyone understands how important spreadsheets are; but being able to  streamline processes within them can save a business time and money.
Learning how to develop key dynamic Functions and use macros / Office scripts to  supports this process.

On completion of this course you may be interested in our Excel Consultancy services

Who Should Attend

Anyone creating large reports / dashboards and need options to automate and streamline the initial build time and refresh time using advanced functions and techniques.

Learning Outcomes

Create dynamic lists and Charts using named ranges
Understand the use and implement array Formulas
Manipulate Text with Excel
Automate spreadsheets and make them interactive for other users
Record repetitive series of keystrokes and commands
Understand the basics of the Excel programming language (VBA or TypeScript)

Course Content

Template Design
Array Formulas
Dynamic Named Ranges
Text manipulation Functions

  • Non 365 version
    Recording Macro
    The Visual Basic Editor
    Editing Macro concepts
  • 365 version
    Recording Office Scripts
    Script Editing / Sharing

How to Book

Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.

 

Measuring The Success

 

The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!

To evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. The cost of the session is £595+VAT delivered virtually and lasts for 2.5 hours.

During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.

We compile this information into a report so that you have evidence of your return on investment.