Computer Tutoring Logo
Est. 2002
Menu Button

Excel Classes Online
Instructor Led Online Training Course

Live Online - Instructor Led Training

Excel Instructor Led Online Training Session

Excel Online 365 Beginners Half Day Course

In today's fast-paced world, time is irreplaceable. Our Excel Online 365 beginners course, a dynamic 3 hour half day session, is an efficient way to master Excel 365 quickly. We understand learning doesn't end in the classroom, so we offer a full month of post-training support for real-world application of your new skills.

Beginners Excel 365 in 3 Hours - is it Possible?

  • Quick Excel Brilliance:Think you can't become a whiz in half a day? Challenge accepted! We pack more learning into 3 hours than you'd think possible. Perfect for spreadsheet skeptics and time-pressed professionals alike.
  • Practical with a Dash of Fun: Forget dull lectures – our training's as interactive as a game show. Our live instructors will help you immediately apply what you've learnt.
  • Aftercare That's Actually There: Think of us as your Excel guardian angels. Struggling post-course? We've got your back for a whole month.
  • Split a Full Day's Course: Want a comprehensive full day course, but only have time for half day at a time?


Get in touch for prices, outlines and other details:

Minimum of 4 persons on each course.

View Excel 365 Beginners Half Day Course Outline

Back to top

How will attending Excel Online classes benefit me?

Attending an instructor led Excel Online class will give you skills that are needed more than ever before. Excel skills are necessary today, not only in the office, but pretty much every industry has a use for this amazing tool. Advanced Excel skills are crucial for in-depth data analysis and decision making. The skills you will learn in an Excel training course will enable you to become more efficient, saving you time. Moreover, those very same skills may also open new doors of opportunity for you.

Speed up your work

Excel and data go hand-in-hand. Everything you enter in an Excel spreadsheet is classed as data. The key is learning the right skills to handle this data effectively, to get the data to work for you.

If you feel like you are wasting a lot of time on repetitive tasks or spending too much time trying to get basic results from your data, then you'll greatly benefit by the automation functions and formulas within Excel. This alone will increase your output and will free up more of your time.


So, what is the point of data? Is it purely to bamboozle you? In fact, data is recorded for many purposes, but can probably be boiled down to one ultimate reason. Analysis.

You see, data analysis is a vital component to decision making, business intelligence and planning. For instance, perhaps you want to know which month recorded the highest sales? Or maybe you need to calculate the percentage increase over the previous month? Our Excel Online classes Online will help you.

Maybe you need to know what the lead product was in any given period? Or which employees met a goal within a certain time frame? These are just a few basic examples of data analysis. So long as data is entered correctly the results will be available in a couple of clicks. And if you want to make sure that data is entered in the correct manner, Excel can help you with that as well.

So you have no need to dread being asked any tricky questions about your spreadsheet. Because what you have learned about Excel will greatly help you get the results and insight you need to make well informed decisions.

Data Presentation

No one wants to look at a messy spreadsheet, so transform your mammoth spreadsheet into eye catching, clean, reports, charts and Pivot Tables.

Visualize your data with dynamic charts. Use a series of charts to showcase your data. Bar charts, column charts and pie charts.

Excel Live Online Training Charts

Learning how to use charts and pivot tables will equip you with the skills to:

  1. Create well organised, easy to read Excel reports.
  2. Turn messy data into clear and helpful charts.
  3. Create interactive reports.
  4. Make your data look professional.
  5. Create charts with flexible interactive parameters.
  6. Quickly and easily print a spreadsheet or convert it to PDF.

How do I know which version of Excel I am using?

Before you embark on an Excel Online training course, it is a good idea to know which version of Excel you are using. Knowing the correct Excel version will enable you to choose a course best suited to your needs. You will also be able to take full advantage of all the tools available on your version of Excel.

If you want to know how to find out which version of Excel you are using do the following:

  1. Open Microsoft Excel.
  2. Click on the File button. (Top-Left)
  3. Click on Account.
  4. The version you are using is available to view in the dialog box that appears.

How to know which version of Excel you're using

If you are unsure as to which version of Excel you are using, please contact us. We will be happy to help you find the version of Excel you are currently using.

Back to top

Microsoft Excel Beginners Course Summary

Microsoft Excel Beginners (live online and face-to-face training) is for those wanting to learn Excel from scratch, or for those who are self-taught and would like to fill in the gaps.

You will learn the correct way to input data. This is key to unlocking the data tools that Excel has to offer. Along with learning the correct way to input data you will also learn the correct formula for the right task. For instance, you can use a screwdriver to hammer in a nail, but it's much easier with a hammer. In the same way you need to learn what the tools within Excel do. This way you can choose the right function, feature of formula for any given task. On completion of the beginner's course, you will feel confident and comfortable designing simple but powerful spreadsheets.

Highlights - What Will I Learn in a Beginners Excel Course?

View Full Course Outline

Back to top

Microsoft Excel Intermediate Course Summary

Take your Excel skills to the next level by handling data efficiently. Delve into Excel data tools to summarise and analysis data. These will include grouping, subtotaling and filtering data.

A huge time saving function is VLOOKUP and XLOOKUP (Excel 365 Only). This function will enable you to consolidate data from two separate sheets. No wasted time copying reams of data. If you are working with data that is recorded in different spreadsheets VLOOKUP and XLOOKUP (Excel 365 only) will be your new best friend. Learn how and when you can use this. You will learn how to compare data from two different tables with Index Match.

As part of the Excel automation process, you will be introduced to Conditional Formatting. Conditional formatting automatically highlights cells based on data. For instance, you can highlight all sales which are above average or highlight all employees who have completed received health and safety training etc.

This course will also leave you wondering how you ever managed without using Pivot Tables.

What is a Pivot Table and how will it help?

Highlights - What will I learn?

View Full Excel Intermediate Course Outline

Microsoft Excel Advanced Course Summary

Highlights - What will I learn?

Further Excel Online Training Courses Available

Maybe an Excel training course isn't what you're looking for. It could be that one of the following courses, also provided by us, could be something you're looking for.

Pivot Tables in Microsoft Excel

That's right! A whole course devoted to Pivot Tables. In fact after completing this course, there will be little about Pivot Tables you won't know. Course highlights include:

Microsoft Excel VBA

VBA - Visual Basic for Applications is the programming language that forms the basis of the macros that you record in Excel. However, once you know a little more about the code you can create customised Excel spreadsheets that can automate repetitive tasks consolidate data from various sources and generate custom forms, graphs and reports. This course will focus on using VBA within the Excel environment to automate tasks.

View VBA Full Course Outline

Power BI with Excel

Power BI is a self service data analysis tool that, initially, is free from Microsoft. Display reports with professional looking visuals with ease using this powerful tool.

View Power BI beginners Course Outline

Back to top

Most Popular Excel Features

Feature Description Benefits in the Work Environment
Data Filters Quickly filter Excel Data by any criteria
Use Filters in Excel Online Training

Practical Examples:

  • Filter customers who live in a certain area (postcode/town etc.)
  • Filter customers who spend over/above a certain amount.
  • Filter expenses
Data Sorting Sort your data:
Sort data in Excel with Filters

Practical Examples:
Sort data according to:

  • Importance
  • Most expensive
  • Sort by Colour
  • Last 2 Months
  • Purchased from UK
  • Top Ten Items
Pivot Tables Group small to large amounts of data with related subtotals:
Pivot Table with Data Grouped by Month and Percentages

Practical Examples:

  • Easy one glance reference
  • Group information according to required criteria. Date or month or year.
  • Sort data within criteria see the best customer for a particular month.
SUMIF & SUMIFS Identify and Auto Sum data within a certain criteria
SUMIF formula in Excel

Practical Examples:

Sum one or multiple criteria within a large amount of data. For Example:

  • Add up all sales from a certain company
  • Sum the amount of sales for a particular product
  • Sum revenue of EU or UK suppliers
  • Work out how much revenue is in Paid or Unpaid invoices
COUNTIF & COUNTIFS Counts the number of instances within a criteria:
The COUNTIF formula in Excel with the formula displayed

Practical Examples:

  • Total how many orders a certain company has made
  • See how many leads generate from a certain place
  • Find out how many people have passed an exam
  • Identify first aiders
Excel Shortcut Keys Keyboard Shortcuts to common actions within Excel
Keyboard Shortcuts and combinations shown

Practical Examples:

  • Reduce RSI (Repetitive Strain Injury)
  • Improves accuracy
  • Increases speed


  • Bar Charts
  • Pie Charts
  • Column Charts
  • Line Charts

Column chart in yellow showing sales by quarter. Qtr one is the best sales.

Practical Examples:

  • Visually Identify Trends
  • Compare Trends & Figures
  • Forward Planning Goals
Cell Formatting


  • Dates
  • Currency
  • Numbers
  • Colours

Format cells box displayed showing the custom formatting of complete date including day of the week.

Practical Examples:

  • Visually Identify Trends
  • Compare Trends & Figures
  • Forward Planning Goals
Managing Page Layout Preparing to print or to convert to PDF
Excel document just about to be printed to PDF

Practical Examples:

  • Manage long documents
  • Exporting to PDF
  • Make spreadsheets easy to read
Data Validation Predetermine data values
Data validation list with product names selected

Practical Examples:

  • Reduce the risk of data entry errors
  • Simplify data entry
  • Ensure data entry is consistent
  • Save time
VLOOKUP Vertical Lookup enables cross referencing between worksheets and workbooks.
VLOOKUP formula in Excel retrieving the supplier from another sheet

Practical Examples:

  • Bring information from multiple sources together to compare data
  • Categorise customers as Gold, Silver or Bronze
  • Create RAG (Red,Amber,Green) sales categories
Pivot Charts Impressively display data with interactive capability:
Excel Pivot Chart displayed as a donut chart with a value in the middle along with a slicer.

Practical Examples:

  • Visual see data at a glance
  • Live Charts
  • Bar & Column Charts
  • Pie Charts

Join mailing list!

Sign up to receive our monthly newsletter including special promotions, hints & tips, and the latest Computer Tutoring news!