Microsoft Excel

On-Site MS Excel Training Courses

If you or members of your team need on-site Microsoft Excel training in Sussex, Kent, Surrey or London, we can help. We offer Excel training for versions 2003-2013, with 2007, 2010 and 2013 being the most popular. We often visit clients in Guildford, Croydon, Crawley, Brighton and we’d love to help you at your offices so that your staff can fully utilise Excel and improve productivity.

The Excel training courses listed below are our structured 1 day sessions. We also offer 1, 1.5 and 2 hour modular on-site Excel training and bespoke/custom IT training packages in Sussex, Kent, Surrey and London, plus instructor-led online excel training (UK-wide). These Excel training courses will revolutionise the way your employees operate. 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.

Download this course information as a PDF file.

What is Excel

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

Entering Data in a Worksheet

  • 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

Building Formulae

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

Worksheet Formatting

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

Formatting Data

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

Printing a Worksheet

      • 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

Introducing List Management

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

Introducing Graphs

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

Please note that 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.

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 this course information as a PDF file.

Multiple Worksheets

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

Naming Ranges

      • 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

Creating Functions

      • 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

Protecting Worksheets & Files

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

Conditional Formatting

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

Excel Table/List Feature

      • 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

Creating Graphs

      • 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 this course information as a PDF file.

Pivot Tables

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

Sparklines (2010/2013)

  • What are Sparklines
  • Creating Sparklines
  • Modifying Sparklines
  • Clearing Sparklines

Cell Styles

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

Templates

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

File Linking & Data Consolidation

  • 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

Sharing Workbooks

  • Setting up Shared Workbooks
  • Bullet point
  • Tracking changes
  • Merging Workbooks

Outlining

  • Creating an Outline
  • Working in Outline
  • Removing an Outline

Custom Views

  • Creating a View
  • Displaying a View
  • Deleting a View

What If Analysis

Scenario Manager

  • Adding a Scenario
  • Displaying Scenarios
  • Merging Scenarios
  • Creating a Scenario Report

Solver

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

Worksheet Auditing

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

Macros

  • Macro Storage
  • Recording a Macro
  • Running a Macro
  • Assigning a Macro to a button
  • Assigning a Macro to a Keystroke
All Onsite Courses
Microsoft Access
Access VBA
Microsoft Excel
Excel VBA
Microsoft Outlook
Microsoft PowerPoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Windows
Microsoft Word
Word VBA
Microsoft Office 2013 Upgrade

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