Microsoft Excel training
Microsoft Excel training

1 day £please call

Key details

Key details

Microsoft Excel is the industry standard for spreadsheets. Armada offers Excel training courses to users at all levels:

Excel training is available on-request only, i.e. one-to-one training or a ‘closed’ course for your group. We don’t currently offer scheduled (public) Excel courses.

This approach means that we can tailor your training to take into account any existing knowledge you have, and the type of spreadsheets you use. You can, for example, choose some introductory-level topics, and some intermediate-level topics.

Exercises provide activity-based experience and help build delegates’ confidence using Excel. These exercises can be tailored to deal with issues specific to your business, for example we can base them on your spreadsheets.

We can host the training at one of our centres, or your venue anywhere in the UK.

Introduction to Microsoft Excel training (1 day)

Provides a thorough grounding in Microsoft Excel, teaching the key skills you need to navigate and starting using Excel. The topics covered include:

  • Program fundamentals.
  • Opening, saving and closing a spreadsheet.
  • Basic formulae.
  • Formatting.

Prerequisites: You should have a working knowledge of Windows. No prior Excel knowledge is necessary.

Intermediate Microsoft Excel training (1 day)

Following on from our introductory-level course, this course explores further features including:

  • Creating and working with charts.
  • Managing workbooks
  • More functions and formulas.
  • Working with data ranges.
  • Working with tables.

Prerequisites: You should be familiar with the fundamentals of Excel, i.e. have attended Introduction to Excel training or have equivalent knowledge.

Advanced Microsoft Excel training (1 day)

Delves deeper into Excel, exploring the more advanced features available and teaching techniques for improving speed and efficiency. You learn about:

  • PivotTables/Charts.
  • Data Analysis.
  • Working with the Web and external data.
  • Macros.
  • Advanced LOOKUP.
  • Document collaboration.
  • Customising Excel.

Prerequisites: You should have attended Intermediate Microsoft Excel training or have equivalent knowledge.

Expert trainers

Excel training is provided by highly experienced instructors with 20+ years’ experience writing documents for business.

Training guide and certificate

Course delegates receive:

  • A comprehensive training guide for Excel, to refer to throughout the course, and to use as a refresher back in the work-place.
  • An e-certificate confirming successful completion of a Excel training course. Click here to see an example of the certificate you receive.

After course support

Following Excel training, delegates are entitled to 30 days’ email support from their trainer to help with any post-course issues.

Excel version

Training can be based on any recent version of Excel (2007 and later).

General information

General information

Course times

Standard course times are 9.30am–4.30pm.

As we’d be hosting this course for you/your group, there’s usually flexibility to change these to suit you, e.g. start or end 30 minutes earlier or later.

Payment

Payment for Microsoft Excel training can be made bank transfer or card. View training course payment options.

We accept purchase orders from UK-registered companies.

Accommodation

See Accommodation local to our training centres.

Cancellations

If a company or delegate cancels an Microsoft Excel training course booking giving less than 10 working days’ notice, a cancellation fee is payable. View cancellation terms.

Terms and conditions

Training course bookings are subject to our terms and conditions.

 

Course content

Course content

Introduction to Microsoft Project

Program Fundamentals

  • Starting Excel 2016
  • What’s New in Excel 2016
  • Understanding the Excel Program Screen
  • Giving Commands
  • Using Command Shortcuts
  • Creating a New Workbook
  • Opening a Workbook
  • Previewing and Printing a Worksheet
  • Saving a Workbook
  • Closing a Workbook
  • Using Help
  • Exiting Excel

Getting Started with Worksheets

  • Navigating a Worksheet
  • Entering Labels and Values
  • Selecting a Cell Range and Entering Data in a Cell Range
  • Overview of Formulas and Cell References
  • Entering Formulas
  • Entering Content Automatically
  • Referencing External Data

Editing a Worksheet

  • Editing Cell Contents
  • Copying and Moving Cells
  • Controlling How Cells Are Moved or Copied
  • Collecting Items to Move or Copy
  • Checking Your Spelling
  • Inserting Cells, Rows, and Columns
  • Deleting Cells, Rows, and Columns
  • Using Undo and Redo
  • Finding and Replacing Content
  • Adding Comments to Cells
  • Tracking Changes

Formatting a Worksheet

  • Formatting Text
  • Formatting Values
  • Adjusting Row Height and Column Width
  • Working with Cell Alignment
  • Adding Cell Borders and Background Colours
  • Copying Formatting
  • Applying and Removing Cell Styles
  • Creating and Modifying Cell Styles
  • Using Document Themes
  • Applying Conditional Formatting
  • Creating and Managing Conditional Formatting Rules
  • Finding and Replacing Formatting

Intermediate Microsoft Project

Creating and Working with Charts

  • Choosing and Selecting the Source Data
  • Choosing the Right Chart
  • Inserting a Chart
  • Editing, Adding, and Removing Chart Data
  • Changing Chart Data
  • Changing Chart Layout and Style
  • Working with Chart Labels
  • Changing the Chart Gridlines
  • Changing the Scale
  • Emphasising Data
  • Using Chart Templates
  • Changing Chart Type
  • Using Sparklines

Managing Workbooks

  • Using Workbook Views
  • Selecting and Switching Between Worksheets
  • Inserting and Deleting Worksheets
  • Renaming, Moving, and Copying Worksheets
  • Splitting and Freezing a Window
  • Creating Headers and Footers
  • Hiding Rows, Columns, Worksheets, and Windows
  • Setting the Print Area
  • Adjusting Page Margins and Orientation
  • Adding Print Titles, Gridlines, and Row and Column Headings
  • Adjusting Paper Size and Print Scale
  • Printing a Selection, Multiple Worksheets, and Workbooks
  • Working with Multiple Workbook Windows
  • Creating a Template
  • Protecting a Workbook
  • Protecting Worksheets and Worksheet Elements
  • Sharing a Workbook

More Functions and Formulas

  • Formulas with Multiple Operators
  • Inserting and Editing a Function
  • AutoCalculate and Manual Calculation
  • Defining Names
  • Using and Managing Defined Names
  • Displaying and Tracing Formulas
  • Understanding Formula Errors
  • Using Logical Functions (IF)
  • Using Financial Functions (PMT)
  • Using Database Functions (DSUM)
  • Using Lookup Functions (VLOOKUP)
  • User Defined and Compatibility Functions
  • Financial Functions
  • Date & Time Functions
  • Math & Trig Functions
  • Statistical Functions
  • Lookup & Reference Functions
  • Database Functions
  • Text Functions
  • Logical Functions
  • Information Functions
  • Engineering and Cube Functions

Working with Data Ranges

  • Sorting by One Column
  • Sorting by Colors or Icons
  • Sorting by Multiple Columns
  • Sorting by a Custom List
  • Filtering Data
  • Creating a Custom AutoFilter
  • Using an Advanced Filter

Working with Tables

  • Creating a Table
  • Adding and Removing Data
  • Working with the Total Row
  • Sorting a Table
  • Filtering a Table
  • Removing Duplicate Rows of Data
  • Formatting the Table
  • Using Data Validation
  • Summarising a Table with a PivotTable
  • Converting to a Range

Advanced Microsoft Project

Working with PivotTables

  • Creating a PivotTable
  • Specifying PivotTable Data
  • Changing a PivotTable’s Calculation
  • Filtering and Sorting a PivotTable
  • Working with PivotTable Layout
  • Grouping PivotTable Items
  • Updating a PivotTable
  • Formatting a PivotTable
  • Creating a PivotChart
  • Using Slicers
  • Sharing Slicers Between PivotTables

Analysing Data

  • Creating Scenarios
  • Creating a Scenario Report
  • Working with Data Tables
  • Using Goal Seek
  • Using Solver
  • Using Text to Columns
  • Grouping and Outlining Data
  • Using Subtotals
  • Consolidating Data by Position or Category
  • Consolidating Data Using Formulas

Working with the Web and External Data

  • Inserting a Hyperlink
  • Importing Data from an Access Database or Text File
  • Importing Data from the Web and Other Sources
  • Working with Existing Data Connections

Working with Macros

  • Recording a Macro
  • Playing and Deleting a Macro
  • Adding a Macro to the Quick Access Toolbar
  • Editing a Macro’s Visual Basic Code
  • Inserting Copied Code in a Macro
  • Declaring Variables and Adding Remarks to VBA Code
  • Prompting for User Input
  • Using the If…Then…Else Statement

Customising Excel

  • Customising the Ribbon
  • Customising the Quick Access Toolbar
  • Using and Customising AutoCorrect
  • Changing Excel’s Default Options
  • Creating a Custom AutoFill List
  • Creating a Custom Number Format
Testimonials
“Carol quickly got to grips with my ability and ensured I got the help where needed. I have more confidence now using Excel in the future. Many thanks.”

Gareth H

“Carol was brilliant, very knowledgable and thorough with the demonstrations and explanations. The course content was very relevant. Carol delivered the course fantastically.”

Emma M

“All the contents of the course were more than helpful.”

Asad A

“Well-paced and informative at a level that was relevant to my experience. Have greatly benefited from this training.”

Martin L

“Tim was an excellent instructor and was content to alter the course if/when required.

Cez W

“A real eye opener. Loads of tips that will save time when creating, linking using and presenting information through excel. Lots of new things presented that will be very useful

Dave C

“Another really useful course from Armada. Tim is a very patient trainer and is happy to repeat info to help delegates progress through the training.”

Geraldine T