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 20th August 2020 Excel - Beginners £40 + VAT 1:30pm - 4:30pm BST
Thursday 27th August 2020 Excel - Intermediate £40 + VAT 1:30pm - 4:30pm BST
Thursday 17th September 2020 Excel - Beginners £40 + VAT 1:30pm - 4:30pm BST
Thursday 24th September 2020 Excel - Intermediate £40 + VAT 1:30pm - 4:30pm BST

Excel Beginners Online Course Outline

Course Highlights:

On completion of this course you will be able to:

  • Create and Use Excel Formulas and Functions
  • Work with Multiple Spreadsheets
  • Use Formatting Tools to Enhance the Look of your Spreadsheet
  • Gain Control Over Printing your Spreadsheet

Course Benefits:

  • Live Instructor Led Training
  • Comprehensive Online Courseware
  • E-Certificate of Completion
  • No Need to Travel

Course Outline:

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 a cup tea or coffee

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 

Course Pre-Requisites:

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 Excel installed on your computer

Excel Intermediate Online Training Course

Course Highlights:

On completion of this course you will be able to:

  • Use Lookup and Reference Functions to Bring your Data Together
  • Consolidate Data from Multiple Worksheets
  • Create & Work With Pivot Tables & Pivot Charts

Course Benefits:

  • Live Instructor Led Training
  • Comprehensive Online Courseware
  • E-Certificate of Completion
  • No Need to Travel

Course Outline:

Formulas

  • VLOOKUP
  • INDEX MATCH
  • IF Function
  • COUNTIF
  • SUMIF

10 minute break - Stretch your legs - Get a cup tea or coffee

Data Handling

  • Creating a Table
  • Filtering Data
  • Removing Duplicate Data

Pivot Tables

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

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.

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 Excel installed on your computer

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:

  • Stable Internet Connection
  • 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 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.

Check out our blog for more Zoom hints and tips. We also have free Zoom tutorial videos.

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

Zoom Tutorials

Preparation will help you get the best out of your online training course. So please take the time to look through these Zoom tutorials.



Don't have the time for videos? Our blog has loads of Zoom tips to help you get the best out of your training course.

Instructor Led Online Power BI Courses

Power BI Courses Available

We are currently running regular online Power BI training sessions - £95 per person.



Excel Booking Form

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