IT and Digital Developing Skills

Advanced Excel

Event Information:

Date: Tuesday, 19 January 2021

Time: 9:30am - 4:30pm

Available To: Members and Non Members

Member Price: £205.00+VAT

Non-Member Price: £290.00+VAT


Please note: This training course is planned to run online and is fully interactive.

_________________________________________________________________________________________________________________________________

This one-day course deals with automation and productivity features. It includes such areas as conditional formatting, validation and consolidation methods, data analysis tools such as pivot tables and data summarising.

Course Programme in Detail

  • Custom Views
  • Working with Comments
  • Conditional Formatting
  • Advanced Filtering
  • Statistical Functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, MODE, MEDIAN, LARGE and SMALL)
  • Validating Data
  • Pivot Tables
  • Creating and using Macros

Course Timings

The day will be split into five sessions, with breaks inbetween to allow time away from the screen.

Session 1 - 9.00am - 10.00am

Session 2 - 10.30am - 11.30am

Session 3 - 12.00pm - 1.00pm

Session 4 - 2.00pm - 3.00pm

Session 5 - 3.30pm - 4.30pm

Course Outcome

On completion of this course you should be able to analyse and present your data visually, use advanced filtering techniques, validate and consolidate data; analyse your data using data summarising and pivot tables, use 'what-if' tools and automate repetitive tasks.

Who Should Attend

Users who are familiar with and have a good understanding of Excel. Those who use it regularly and write their own basic formulas. This is a "packed" course and due to the level of content, not all topics may be covered (to be agreed during training).

Course Delivery

This course is being delivered online and is fully interactive, you will be expected to have your camera on during the training.

A joining link will be sent around a week before the course start date. It is suggested that delegates take notes throughout. Time will be provided for practicing and recapping along with Q & A.

Prerequisites

A laptop or PC running the latest version of Excel will be required

About the Trainer

The tutor for the course is Martin Perry who has many years' experience as an IT Trainer. Martin's courses are geared to ensuring all delegates walk away with new skills regardless of their ability when they arrived. All courses are delivered in such a way that delegates continually use Excel throughout the day ensuring maximum hands-on experience.

Other Courses You May Benefit From

  • Foundation Excel
  • Intermediate Excel
  • A variety of Microsoft packages are available on a bespoke basis, including MS Word, PowerPoint etc. Please contact us for more information.

Book Your Place

Submit your booking today using the form below.

NOTE: All fields are required

Back