Skip to page content
Tel 01892 830111

Select Technology Prestige Microsoft Training July 2020: Online Training

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 – 21st July 2020 – 9:30 am – 10:30 am

Fill Series

  • Fill Series – Standard
  • Fill Series – Custom

Styles and Formatting

  • Inserting & Deleting Cells, Rows and Columns

Formula and Functions

  • BODMAS
  • 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 – 22nd July 2020 – 9:30 am – 10:30 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 – 23rd July 2020 – 9:30 am – 10:30 am

FlashFill

  • FlashFill – Text to Columns

Data Validation

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

NameRanges

  • 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 – 24th July 2020 – 9:30 am – 10:30 am

Charts

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

SubTotals

  • Sorting
  • Settings
  • Expand & Collapse

PivotTable Basics

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

Finish

* 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.

FAQs

How do I access this event?

  • We will shortly send you an email 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?

  • Please feel free to contact Sally Kerby on 01892 830111 or skerby@select-technology.co.uk with any questions you may have.

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

Toolbank

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.

Accreditations

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