Computer Tutoring Logo
Est. 2002
Menu Button

Excel Classes Online
Instructor Led Online Training Course

Excel 
Live Online - Instructor Led Training

Excel Instructor Led Online Training Session

How will attending Microsoft Excel Classes Benefit me?

A Microsoft Excel 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 crucials 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.

Analysis

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?

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.

Visualise 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 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, subtotalling 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 canhighlight 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 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

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 data according required criteria

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

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 AutoSum data within a certain criteria

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

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

Practical Examples:

  • Reduce RSI (Repetive Strain Injury)
  • Improves accuracy
  • Increases speed
Charts

Create:

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

Practical Examples:

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

Format:

  • Dates
  • Currency
  • Numbers
  • Colours

Practical Examples:

  • Visually Identify Trends
  • Compare Trends & Figures
  • Forward Planning Goals
Managing Page Layout Preparing to print or to convert to PDF

Practical Examples:

  • Manage long documents
  • Exporting to PDF
  • Make spreadsheets easy to read
Data Validation Pre-determine data values

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.

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

Practical Examples:

  • Visuall 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!

Subscribe