Online Microsoft Excel Training

Online Microsoft Excel Training Sessions

If you or members of your team need online Microsoft Excel Training we can help. We offer Microsoft Excel training courses for 2016 & Office 365, however can cater for older versions of MS Excel software. we’d love to help improve efficiency in your workplace.

The Microsoft Excel training courses in Sussex, Kent, Surrey & London that are listed below are our structured 1 day sessions. We can mirror our onsite courses online to revolutionise the way your employees operate so speak to us today on 01892 665353 to start the path or revolution in your business or simply email us.

Introductory Level
Intermediate Level
Advanced Level

This course covers all the vital basics of Excel and is suitable for new and existing users who have not received any formal Excel training.

Download Course as a PDF

Toolbars & Menus (2003)
The Ribbon and Dialog Boxes
Changing Views
Getting Help
Cursor Movements & Scrolling
Selecting Text
Creating, Opening and Saving a File

Entering Text and Values
Editing a Cell
Clearing cell contents /formats
Autofill/Pick from List/Autocomplete
Smart Tags
Using Flash Fill for Data Entry (2013)
Moving and Copying data
Undo & Redo

Entering Formula: Add, Subtract, Multiply and Divide
Add up using the AutoSum function
Reading & Understanding Formula
Copy a formula
Using Brackets in Formula (Order of calculation)
Excel Functions: Average, Min, Max and Count
Using the $ sign in Formula (Absolute v Relative)

Applying & removing font formats
Changing the default font & point size
Copying formats with the format painter
Understanding the Indent markers
Automatic paragraph numbering
Bulleting paragraphs
Drawing boxes & lines around paragraphs

Changing Column Widths
Changing Row Heights
Inserting Rows & Columns
Deleting Rows & Columns

Formatting Text Cells
Adding Borders
Using Numeric Formats
Using Date Formats
Format as a Table
Removing Formats

Setting and Clearing a Print Area
Page Layout View
Aligning Text on the Page
Printing in Landscape
Changing Margins and Scaling
Page Breaks
Inserting Headers & Footers

Setting up a List in Excel
Rules for creating a list in Excel
Sorting and filtering a list

Creating a Graph
Modifying and Formatting the Graph
Adding Legends and Titles
Worksheet v Embedded Charts

This course is designed for students who have already attended the introductory course or who already have a good working knowledge of Excel basics.

To attend this course you should be familiar with building basic formulae and you should be confident in using AutoSum and adding, subtracting, multiplying and dividing. If you are not familiar with these please attend the Introductory course before coming on this course.

Download Course as a PDF

Inserting/Deleting/Moving/Copying Worksheets
Naming Worksheets
Grouping & Ungrouping Sheets
Working in Group Mode
Linking worksheets
Printing Multiple Worksheets

Creating & Deleting Range Names
Using a Range Name in Worksheet Navigation
Using a Range Name in Functions
Assigning a Value to a Name
Range Names v Tables

Average, Min, Max, Count and CountA
CountIf, SumIF and IF
Nesting IF, and using AND and OR
Date functions
Text functions
Match and Vlookup functions
Nesting Functions

Sheet Protection
Unlocking a range of cells
Hiding Formula in cells
Workbook Protection
Saving a file with a Password

Using Quick Formatting – Colour Bars/Shading/Icons
Formatting using Existing Conditions
Creating or editing Rules
Clearing Rules

Principles of an Excel List
Sorting & Filtering a List
Printing a List
Producing SubTotals
Formatting as a Table
Advantages to using a Table
Adding Totals to a Table

Embedded v Worksheet Charts
Creating and Modifying a Chart
Chart Types
Legends & Titles
Adding and Removing a Series
Placing data on a secondary Axis
Printing a Chart

There is something for everyone is this one day advanced course. Most users keeping lists in Excel will benefit from Pivot Tables, and Goal Seek, Scenario Manager and Solver will find answers to complex problems.

Students attending this course should be comfortable with the majority of the features on the introductory and intermediate courses.

Download Course as a PDF

Understanding Pivot Tables
Creating a Pivot Table
Editing, Moving and Deleting Fields
Filtering Data
Sub totals in Pivot tables
Creating Groups
Creating Calculated Fields
Inserting Report Filters
Showing Pages in a Pivot Table
Updating Pivot Tables
Use Slicers to Filter a Pivot Table (2010/2013)

What are Sparklines
Creating Sparklines
Modifying Sparklines
Clearing Sparklines

Applying Styles
Modify a Style
Creating a Style
Saving Styles
Merging Styles from Other Workbooks

Creating a Template
Template Storage
Using Templates
Editing Existing & Default Templates
Inserting Sheet Templates
Using the XLSTARTUP folder

Creating linking Formula
Opening & Updating Linked Worksheets
Editing a Link
Opening Target and Source Workbooks
Data Consolidation by Position
Consolidation by Category
Creating Links and Consolidation

Setting up Shared Workbooks
Bullet point
Tracking changes
Merging Workbooks

Creating an Outline
Working in Outline
Removing an Outline

Creating a View
Displaying a View
Deleting a View

Scenario Manager

Adding a Scenario
Displaying Scenarios
Merging Scenarios
Creating a Scenario Report

Use Solver to find a resolution to complex problems
Set Variables
Create Solver Reports

Tracing Precedents & Dependents
Navigating and Removing Tracer Arrows
Tracing Errors
Adding/Deleting/Printing Comments

Macro Storage
Recording a Macro
Running a Macro
Assigning a Macro to a button
Assigning a Macro to a Keystroke

Please note that in there may not always be time to cover both lists and charts and the group will be given the opportunity to choose which of these they wish to cover.

All Oregen Training Online Courses

Microsoft Powerpoint
Microsoft Word

Oregen Computer Training Ltd.

4.8

review us on

Clare Chaffey

12:36 09 Jun 21

Great one day course on MS Project. Basic introduction covered all the fundamentals and friendly teacher with a great teaching style. Would highly recommend.

Alexander Low

13:36 08 Jul 19

I went on an Excel Introductory Course provided by Oregen Computer Training Ltd. It was a small group but actually was just what was needed to get through the workshop. There were enough breaks to allow us to absorb the information which was delivered expertly by our Trainer for the day. The surroundings were quiet and well-suited to the course. I learnt an amazing amount which I have started to put into practice in my business in order to organise my statistics to see how the business is doing very month. I would absolutely recommend Oregen to anyone who wants to start or simply update their software knowledge. Well done to Jo Humphrey for organising and to Oregen Computer Training Ltd for hosting this excellent course. Thank you

helen mulholland

11:00 04 Jul 19

Thanks to Oregen Computer Training for a great one day basic Excel course for beginners. Great content delivered in calm quiet environment. Ideal for learning. Easy to get to nearby free parking

katherine mott

10:43 29 Oct 18

Thank you to Oregen Computer Training for a successful and informative training session in Introductory and Intermediate Excel training.

Lucio Estibeiro

14:38 28 Jan 18