Microsoft Excel Logo Training

Onsite Microsoft Excel Training

Onsite Microsoft Excel Training Sessions

If you or members of your team need online Microsoft Excel Training in Sussex, Kent, Surrey or London, we can help. We offer Microsoft Excel training courses for 2016 & Office 365, however can cater for older versions of the software. We visit clients in Sussex, Kent, Surrey & London and we’d love to help you at your offices so that your staff can fully utilise MS Excel and improve productivity.

The Microsoft Excel training courses in Sussex, Kent, Surrey & London that are listed below are our structured 1 day sessions. These Excel training courses will revolutionise the way your employees operate, so to speak to us about how we can help please call us on 01892 665 353 to chat through what suits your business or send us an email.

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.

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

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

  • 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 Onsite Courses

Clare ChaffeyClare 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 LowAlexander 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 mulhollandhelen 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 mottkatherine 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 EstibeiroLucio Estibeiro
14:38 28 Jan 18