Skip to page content
Tel 01892 830111

Select Technology Prestige Microsoft Online Training October 2020


October 20 - 09:00 am


October 23 - 10:00 am

Event Category:

Prestige Training

Click to Register:

Sally Kerby

Complementary Excel training for Prestige Clients only

Increase productivity and efficiency with our hands on Microsoft Excel. Many business users have been self-taught or informally trained by fellow peers when it comes to using Microsoft Office in the workplace. These courses are a great way learn more about these common business tools and enabling staff to increase their productivity.  What’s more, these courses are included as part of your Prestige Managed Service!*

Please note that spaces are limited to two employees per Prestige Client.

Please be aware that the course content lists are subject to change depending on the actual requirements of those attending the sessions. We also require delegates to attend all sessions.

We will be running this course over 4 days, 1 hour per day.


Session 1 –

20th Oct 2020 – 9:00 am – 10:00 am

Fill Series

  • Fill Series – Standard
  • Fill Series – Custom

Styles and Formatting

  • Inserting & Deleting Cells, Rows and Columns

Formula and Functions

  • Formula – Sum
  • Formula – Average
  • Formula – Min
  • Formula – Max
  • Formula – Count(A)
  • AutoSum

Quick Analysis Tool – Totals

  • Formula – Percentages
  • ACR: Absolute Cell Referencing

Data Entry – Accuracy and Errors

  • Copy & Paste Values

Session 2 –

21st Oct 2020 – 9:00 am – 10:00 am

Sorting Data

  • A-Z
  • Z-A
  • Custom

Format as Table

  • Table – Naming
  • Table – Headings
  • Table – Banding by Rows/Columns
  • Table – Total Row
  • Adding & Inserting Rows/Columns

Conditional Formatting

  • Standard
  • Optional
  • Filtering by Selection
  • Filtering by Checkbox
  • Filtering by Font/Icon/Cell
  • Colour Slicers

Session 3 –

22nd Oct 2020 – 9:00 am – 10:00 am


  • FlashFill – Text to Columns

Data Validation

  • Stop, Warning & Information
  • Values
  • Dates
  • Text Length
  • Lists (Drop Down Lists)


  • Cell, Row, Column and Rows
  • Formula
  • ACR
  • Range (Fixed
  • Headings and Labels

IF Formula

  • Question, True, False
  • Cell Reference, Formula, “Text or Words” V/Hlookups
  • Ordered Lists
  • Unordered Lists
  • No Exact Match

Session 4 –

23rd Oct 2020 – 9:00 am – 10:00 am


  • Types
  • Chart Basics
  • Non-Consecutive Data Selection
  • Adding Chart Data


  • Sorting
  • Settings
  • Expand & Collapse

PivotTable Basics

  • Data Headings
  • PivotTable Creation
  • Data Selection and Placement
  • Calculations
  • PivotCharts


*PLEASE NOTE CANCELLATION POLICY: Registered for the training and now you can’t make it? We won’t take it personally, just get in contact and let us know.  If for any reason you cannot attend the training, please notify us of your cancellation three (3) or more business days before the event. In all other cases, a cancellation fee of £50 will be invoiced to your company. This cancellation fee helps defray costs incurred by Select Technology Systems Ltd for unused event services. If you send someone in your place (swap-out), no fee will be levied.


How do I access this event?

  • We will send you an email the Friday before to the first session with all the information needed to access this event. It will be via Microsoft Teams.

Do I require anything for the session?

  • Pen, paper, refreshments, snacks and yourself.

Where can I contact the organiser with any questions?

Share this post
Case Studies

Success Stories

Bird College

A new Managed Service partner was required, to enhance service quality, improve efficiency, and reduce costs to Bird College.

Cottage Farms

Full Wi-Fi coverage was needed in the new Cold Store to maximise productivity. We came to the rescue


The need to protect customers in the event of a disaster recovery scenario. We offered the stability, flexibility and tools to solve Toolbank's needs.


Partner Accreditations and Certifications

Contact us

Get in touch with us

You may unsubscribe from Select Technology marketing communication at any time. For more information on how to unsubscribe and how we are committed to protecting and respecting your privacy, please review our Privacy Policy