Microsoft Excel

Microsoft Excel Instructor Led Online Training Courses across the UK

If you or members of your team need online Microsoft Excel instructor led training in Sussex, Surrey, Kent, London or across the UK, we can help. We offer engaging Excel tutor led training for versions 2003-2013, with 2007, 2010 and 2013 being the most popular. Your staff will soon be fully utilising Excel and productivity will increase.

The sessions shown below are brought direct to your PC or lapop using GoTo Training. They are live instructor led sessions, where you can ask questions and practice, using the exercises provided, whilst the tutor is there to help you. All you need is a broadband connection and, ideally, a headset.

These are all separate sessions and you can register for any one or all of them. If you want to register for more than one session, we recommend that you take them in their numbered order.

We also offer 1, 1.5 and 2 hour modular on-site Excel training and a bespoke/custom IT training package that will revolutionise the way your employees operate. These services are offered across Sussex, Kent, Surrey and London. Please call us on 01892 665353 to chat through what suits your business or send us an email.

Download this course information as a PDF file

E1: Formatting & Printing Worksheets

Duration 1 hour – Introductory Level
  • Clearing Formats Only
  • Formatting Cells – Numbers, Dates, Text
  • Borders & Shading
  • Using Table Formats
  • Printing A Worksheet – Fitting to Page, Page layout view, Headers & Footers
  • Using Page Break Preview
  • Printing an Area of the Worksheet

E2: DataEntry & Basic Formulae

Duration 2 hours- Introductory Level
  • Entering Text, Values and Dates
  • Using AutoFill to copy contents and formats
  • Automatically enter a sequence of dates and/or numbers
  • Building Formulae, Add, Subtract, Multiply & Divide
  • Adding up using the Sum Function
  • Using the Min, Max, Average, Count Functions
  • Excel’s order of calculation
  • Absolute & Relative cell referencing

E3: Working with Charts

Duration 1.5 hours – Intermediate Level
  • Creating & Editing Charts
  • Working with Colours, Gridlines, Legends & Titles
  • Adding Text
  • Adding more data to a chart
  • Placing data on a secondary axis
  • Removing data from the chart
  • Adding data from more than one sheet
  • Moving a Chart, Copy a Chart from Excel to Word
  • Changing the Default Chart Type

E4: Multiple Worksheets v Workbooks

Duration 1 hour – Intermediate Level
  • Copying, Deleting, Moving & Naming Sheets
  • Building a Formula across sheets
  • Using Group Mode
  • Building a linking formula across workbooks
  • Editing Links
  • Saving a Workspace

E5: Database/List Management

Duration 1 hour – Intermediate Level
  • Principles of an Excel List
  • Freezing Panes
  • Sorting and Filtering a List
  • Producing Subtotals
  • Formatting as a Table
  • Entering Data in the table
  • Adding Totals to the Table
  • Filtering in a Table

E6: Pivot Tables

Duration 2 hours – Advanced Level
  • Create a PivotTable Report
  • Add/Remove Pivot Table Fields
  • Reorganise the PivotTable
  • Hide Rows and Columns
  • Format the Report
  • Use Layout Options
  • Add/Remove Subtotals
  • Group and Sort Items
  • Use Advanced Data Field Options
  • Use different functions in the Data Area
  • Use the “Show Data As” Option
  • Create Calculated fields within the Pivot Table
  • Using the Report Filter

E7: Advanced Functions

Duration 2 hours – Advanced Level
  • Using Range Names
  • COUNTIF & SUMIF Functions
  • Using IF- Enter data into cells based on the result of a test
  • Text functions – UPPER, LOWER, PROPER, LEN, CONCATENATE
  • Using VLOOKUP and MATCH – Find data based on a lookup value
  • Date Functions (TODAY, NOW, WEEKDAY, YEARFRAC)

E8: Working with Large Worksheets

Duration 1 hour – Advanced Level
  • Freezing & Splitting panes
  • Creating Outlines
  • Working with large worksheets
  • Collapsing rows and columns
  • Creating Charts from collapsed data
  • Creating Custom Views
  • Saving views within the workbook
All Online Courses
Microsoft Excel
Microsoft PowerPoint
Microsoft Word

What Clients Say

About Oregen Training

The go to supplier for effective IT training solutions.

For over 20 years we have been providing quality instructor led IT training to the corporate and small business market place ...

- read more

Contact Information

Telephone: +44 (0) 1892 665353
Email: info@oregentraining.com