Computer Tutoring Logo
Est. 2002
Menu Button

Excel Classes Online
Instructor Led Online Training Course

Live Online - Instructor Led Training

Upcoming Excel Online Training Class

Date Class Price Length Bookings
Thursday 11th June 2020 Excel - Beginners £40 + VAT 1:30pm - 4:30pm BST

Excel Beginners Online Course Outline

Course Prequisites

This Excel instructor led online training course is for somebody who is an absolute beginner with Excel. You would need to have basic computer skills such as saving and opening files and using a keyboard and mouse. Also, along with our scheduled break, our trainers understand the importance of taking time away from the screen. So, please, if you are feeling you need a quick 5 mins to stretch then do so.

Technical Requirements

This course is designed to be online conducted using the Zoom platform. See below for details. In addition before the course you would need:

Formulas

  • Simple Formula
  • Using Cell References
  • Operators
  • Operator Preference
  • Functions
  • Copying & Renaming Worksheets
  • Calculating between Worksheets
  • Calculating Between Workbooks
  • Absolute References $
  • Change Calculation Options

10 minute break - Stretch your legs - Get your tea

Formatting

  • Formatting Numbers
  • Font Size & Colour
  • Fill Colour
  • Borders
  • Cell Alignment
  • Text Wrapping
  • Cell Styles
  • Format Painter

Printing

  • Selecting the Print Area
  • Margins
  • Printing a Large Spreadsheet 

Excel Intermediate Online Training Course

Course Pre-Requisites

Before attending this online course the student must have at least a basic understanding of Excel. Either having already gone on the Beginners Excel session above or due to previous use.

Formulas

  • Vlookup
  • Index Match
  • If Function
  • COUNTIF
  • SUMIF

10 minute break - Stretch your legs - Get your tea

Pivot Tables

  • Creating a PivotTable
  • Using Slicers & Timelines
  • Creating a Dashboard
  • Formatting
  • Create a Pivot Chart

Data Handling

  • Creating a Table
  • Filtering Data
  • Conditional Formatting
  • Removing Duplicate Data

Review

What do I need to participate?

Technical Requirements

To get the best out of your training sessions it is recommended that you have a:

  • Internet connected Computer
  • Webcam (usually already on most laptops)
  • Microphone (usually on laptops)
  • Nice comfy place to learn
  • Big cup of tea

If you haven't got a microphone you can still take part by dialling in using your phone. Before the training course we will email you with joining instructions which will include the option to dial in.

One more thing, during this Power BI class you will learn more by following along with the instructor. So if you are able to use a second screen this would enable you to follow the one screen while carrying out the exercises on the other. Though this is not absolutely necessary, it would help your learning experience.

Should you need any assistance in setting up zoom for you our your employees you are more that welcome to contact us: info@computertutoring.co.uk.


Excel Booking Form

First Name:
Last Name:
Email:
Phone:
Class:
Date:
Voucher Code:
Join mailing list for tips & tricks: