Skip to content

Microsoft Excel Advanced (up to 6 people)


Sandstone Training Ltd

Summary

Price
£950 inc VAT
Study method
Classroom
Duration
1 day · Full-time
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

Location & dates

Location
Address
The Bath & County Club
Queens Parade
BATH
Somerset
BA12NJ
United Kingdom

Overview

Our Excel advanced course is designed for people who are familiar with Excel basics and would like to learn the advanced features to speed up their workflow and find solutions to challenging tasks. The course is led by a highly qualified and Microsoft certified instructor and is held at our venue in central Bath. Price is for training up to 6 people.

Certificates

Certificate of completion

Digital certificate - Included

Description

Our fully qualified instructor will lead the course for up to 6 people providing Excel theory, worked examples and personal guidance when completing practicals, allowing you to put your new knowledge into practice and consolidate your learning.

Below is an outline of the general course contents, which can be tailored to your company's needs:

  • Importing and exporting data
  • Filtering and sorting
  • Conditional formatting and calculations including SUMIFS
  • Sparklines and advanced graphing
  • Pivot tables and graphs
  • Conditional search options including VLOOKUP
  • Statistical formulae
  • Creating a dashboard
  • Reviewing, auditing, sharing and protecting a spreadsheet
  • What-if analysis
  • Working with text strings
  • Macros

Each delegate receives comprehensive course notes and a training certificate.

Who is this course for?

Anyone looking to build upon their knowledge of using Excel for activities such as administration, finance, sales, project management, data analysis and presentation.

Requirements

Basic understanding of Excel. Up to 6 people can attend the course and must be able to travel to our venue in central Bath.

Career path

Suitable for all careers where data entry, analysis or project management is required. Example careers include administrators, project managers, accountants, sales personnel and company directors.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs