Excel Online 365 Beginners Half Day Course

Beginners Excel 365 in 3 Hours - is it Possible?

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.

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

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.

• Accounts - Use Excel not only to input your receipts and expenses, but use accounting tools within Excel to track increases, decreases, percentages and goals. Computer Tutoring have published a 9-part video series called: "Super Easy Accounts" to give you a taster.

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.

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?

• Become familiar with the Excel environment and terminology (i.e. cells/ranges etc).
• Learn the correct way to input data.
• Know how to set up a spreadsheet - including adding, deleting, moving, and copying rows.
• See how to enter calculations.
• Basic formulas including use of brackets (addition, multiplication, division and subtracting).
• Basic functions in a formula like SUM, AVERAGE, COUNT, MAX and MIN.
• Calculation between worksheets.
• Set up for print, PDF professionally.
• Formatting, changing numbers to currency.
• Using percentages.
• The correct way to enter and handle dates.
• Understanding the difference between absolute ($) and relative references.
• Keyboard Shortcuts and how to use them to not only speed up your use of Excel but to reduce RSI (Repetitive Strain Injury).
• Understanding the difference between the move, selections and fill mouse cursors.
• Handling Colours. (For a sneak preview see our How to make your accounts look pretty? video).

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?

• A Pivot Table is a powerful tool used to extract and summarise large quantities of data.
• There is no need for formulas.
• Summarise data based on values you have selected.
• Once created, you can update a Pivot Table easily, so that it includes any data you have added.
• Multiple Pivot Table Creation.
• Group data by trends, dates, locations etc.
• Use Slicers to create a simple dashboard.

Highlights - What will I learn?

• More advanced formulas and functions.
• Create and work with Pivot Tables.
• Visualise your Excel data with the use or eye-catching charts.
• Create and use VLOOKUP (XLOOKUP - 365 only) and IF functions.
• Work with essential date and time functions.
• Explore the how, where, and why you would share and collaborate on various cloud platforms. The main ones being OneDrive, SharePoint, and Teams.

View Full Excel Intermediate Course Outline

Microsoft Excel Advanced Course Summary

• Further develop you data analysis skills. This will include an introduction to Power Query and PowerPivot.
• Automate tasks through macros. If you develop a love of macros, then you'll love our Power Automate Course.
• Work with advanced formulas, including nested IF statements, multiple VLOOKUP's between workbooks and advanced filter functions.
• Link data to an external website for instant live updates / feeds. This is particularly handy if you need a live exchange rate. Tables of exchange rates, or any other data, can be externally linked to your Excel spreadsheet, so that your figures are always bang up to date.
• Learn how to edit the VBA code created by the macros you've recorded.
• Introduction to Power Query / PowerPivot.

Highlights - What will I learn?

• Creating and working with macros.
• Edit VBA code.
• Work with advanced formulas.
• Link to external data.
• Find out about Power Query and PowerPivot, when to use it and what it can do for you.

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:

• Creating a Pivot Table - Best Practices.
• Using Calculated Items and Calculated Fields to get the results you want from a Pivot Table.
• How to get information out of a Pivot Table.
• Conditional Formatting in a Pivot Table.
• Using Slicers and Time lines to create Dashboards from Pivot Tables.
• Using Pivot Charts in conjunction with Pivot Tables.

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 your data:	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 Auto Sum 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 (Repetitive 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	Predetermine 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: Visual see data at a glance Live Charts Bar & Column Charts Pie Charts