Microsoft Excel training
Microsoft Excel training

1 day
In centre:
£please call
Live online:
£please call

Key details

Key details

Introduced in 1987, Microsoft Excel is the quintessential spreadsheet app. It contains more functions and features than the competition, and offers powerful filters for displaying data exactly as you want.

Armada offers Excel training courses to users at all levels:

Microsoft Excel training is arranged on-request, i.e. one-to-one training or a ‘closed course’ for your group. Your training can be tailored to take into account any existing knowledge you have, and the work you’re going to be doing.

You can, for example, build your own Excel course, choosing some introductory-level topics, and some intermediate, some advanced, and even topics not listed on our standard syllabuses.

Exercises provide activity-based experience, helping you build 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.

In-class or online

This course is available in-class at eight centres or live online.

Expert Microsoft Excel trainers

Microsoft Excel training is hosted by highly experienced instructors. See Expert trainers.

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.

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. For further details, see Support.

Excel version

Training can be based on any recent version of Excel.

General information

General information

Course times

Standard course times are 9.30am–4.30pm.

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

Payment

Payment for Microsoft Office training can be made by:

  • Bank transfer. Please call 01527 834783 for our bank details.
  • Card. All major credit and debit cards accepted. Payment can be made securely online or over the phone. Card payments are processed by Stripe. Armada doesn’t record or store your card details.

Purchase orders

We accept purchase orders from UK-registered companies and public sector organisations.

Accommodation

See Accommodation local to our training centres.

Cancellations and postponements

If an on-request Microsoft Excel course booking is cancelled giving less than 20 working days’ notice, a cancellation fee is payable. View cancellation terms.

If an on-request Microsoft Excel course booking is postponed giving less than 20 working days’ notice, a postponement fee is payable. View postponement terms.

Terms and conditions

Training course bookings are subject to our terms and conditions.

 

Expert trainers

Expert trainers

Microsoft Excel training courses are hosted by:

Lynne Telfer

Lynne Telfer Autodesk Certified Instructor

Lynne Telfer is highly experienced instructor with over 25 years’ experience working as a professional trainer.

In the late nineties, Lynne worked for Adobe as a trainer and consultant, hosting courses in FrameMaker and other applications at all levels for Adobe’s clients. She’s provided training in Adobe’s Technical Communication and Creative applications ever since.

Lynne has expert knowledge of:

  • Adobe FrameMaker – both Unstructured and Structured use.
  • Adobe RoboHelp.
  • Adobe Creative Cloud applications: InDesign, Photoshop, Illustrator and Acrobat.
  • Adobe’s e-Learning tools – Captivate and Presenter.
  • Microsoft Office suite of applications, covering the mainstream applications Word, Excel and PowerPoint to advanced level.

Lynne has a BA Hons in Educational Practice from Oxford Brookes University.

Claire Squibb

Claire Squibb Autodesk Certified Instructor

Claire has used spreadsheets since the launch of VisiCalc, when she fell in love with its structured simplicity – and the fact that it always got the maths right!

She started training professionally in 1987 for Harlow Information Technology Centre where she obtained teaching certification.  She has always focused on spreadsheets and data, and now specialises in Microsoft Excel and Power BI, keeping up with new updates and features as they arrive and, where appropriate, adding them into her training material.

Although Claire teaches to all levels, she has not lost sight of the fact that her learners are not experts.  She has a lively and engaging manner and is able to explain things clearly and logically, while still giving the opportunity for more advanced learners to experiment.

Wendy Sprakes

Wendy Sprakes Autodesk Certified Instructor

Wendy Sprakes is a Microsoft Master Instructor (MMI) and a qualified teacher (QTS).

Wendy began her working life as a CAD operator, working through the ranks of trainee draughtsman, graduating as a professional Mechanical Engineer, through to Project Engineer in the CAE Industry.

She then went on to qualify as a teacher, and has been hosting Microsoft Office courses since 2000. Wendy trains all applications in the Office suite, including Word, Excel and other, more niche applications such as Visio and Project, from beginner to advanced and customised level. Wendy has been a staff member, delivering IT and Project Management modules for Chesterfield College, and a course leader for Microsoft Project at Sheffield Hallam University for five years.

Away from training, Wendy is an accomplished jazz musician. Her music enjoys regular airplay on both regional and national stations including BBC and JazzFM.

Doug Fisher

Doug Fisher Autodesk Certified Instructor

Doug is a skilled instructor with over 25 years’ experience of delivery training in Microsoft Office and related applications, including Project, SharePoint, Teams and VBA.

In recent years, Doug has delivered training to a wide range of blue-chip companies and public sector organisations including the United Nations, the RAF, Police, NHS, Etihad Airways and Astra Zeneca.

Doug holds an MBA, and he has numerous professional and training accreditations, including:

  • Microsoft Certified Trainer (MCT)
  • Microsoft Certified Professional (MCP)
  • Microsoft Office Specialist (MOS): Office and SharePoint
  • European Computer Driving Licence (ECDL) to Advanced Level
  • Microsoft Certified Application Specialist Instructor (MCASI)

Simon Lambourne-Wills

Simon Lambourne-Wills Autodesk Certified Instructor

Simon has been a Microsoft Trainer and Consultant since 2007.

He has expert knowledge of a wide range of applications in the Office family. As well as the mainstream products such as Word, Excel, PowerPoint, Teams, Power BI, etc., Simon hosts courses in the more niche tools including Yammer, Sway, Office365 Video and Planner.

When training, Simon strives to build confidence in all attendees. He achieves this by engaging and interacting with them, creating good rapport and enabling them to be involved.

Tim Price

Tim Price Autodesk Certified Instructor

Tim is a Microsoft Certified Trainer, Microsoft Office Specialist, Master and Expert. He has vast experience training in all recent versions of Office, as well as related applications such as SharePoint, Project and Access.

Tim has worked in the IT Industry for over 30 years. Prior to specialising in Microsoft Office training, he held roles in software development, application design and project management.

Tim is passionate about training and is known for his approachable, relaxed style of delivery. He gets tremendous satisfaction from facilitating in the development of other people.

Course content

Course content

Introduction to Microsoft Excel

Program Fundamentals

  • Starting Excel
  • 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 Excel

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
Live online training

Live online training

Online training lets you participate in a live Microsoft Office course from your place of work or home.

We do everything possible to make your online training experience as close as possible to actually being in the classroom. You can:

  • See and hear our trainer, and the other delegates participating in the course…
    Live online training - see your trainer and the other course delegates
  • Watch our trainer demonstrate techniques in Microsoft Office.
  • Interact by speaking, using chat, or raising your ‘virtual hand’ if you need assistance.
  • Share your screen with our trainer, and allow them to take control to explain something.

Like our in-class courses, online Microsoft Excel courses…

  • Are presented by expert instructors.
  • Give you plenty of opportunity to carry out assisted, practical exercises using Microsoft Office.
  • Offer 30 days’ email support from your trainer.

All you need is an Internet-connected computer with…

  • Microsoft Office installed.
  • A webcam and audio capability. If your computer running Microsoft Office doesn’t have these, you can use a second device, such as another computer or tablet. See Hardware recommendations for live online training for further details.

If there’s anything you’re not sure about we’ll do our best to help you. We won’t, however, be able to assist with your Microsoft Office installation.

We provide everything else…

  • Links to download the files, resources, etc. you’ll use in your course.
  • A training guide. For most courses, you can choose from a printed copy that we post to you, or a PDF.

In the week before your course, we’ll send you an email containing everything you need to prepare for and participate in the training. Then, a couple of days before your course, we’ll give you a courtesy call to make sure you have everything in place and answer any questions you may have.

Please note that we are not able to record scheduled online courses for privacy reasons.

When you attend live online training, you’re participating in a real course, hosted by a real trainer, in real time

 

Testimonials
“Lynne was great, very attentive, took care and time with each individual's needs. Lynne tried to accommodate all needs and provided informative details to help take something away for everyone.”

Alexandra R

“I thoroughly enjoyed my day with Lynne and left feeling that I’d really achieved something. I feel so much more confident in the use of Excel. Lynne was a great trainer - clear, logical and patient. Thank you.”

Justine S

“Really enjoyed, gained a lot of knowledge that will help me in my future development.”

Benn H

“Lynne was a great trainer with a lot of patience and went at a great speed where we can ask a lot of questions and leave feeling confident. Loved using the documents Lynne put together, it was very helpful to do all the different exercises. Very supportive when trying to relate it to the documents we use. ”

Hannah L

“Sufficient breaks and very informative. Overall, a good course and instructor who kept me engaged in the training.”

Adam R

“The trainer went at a nice pace and explained each part in good detail, allowing us to practice before moving onto the next section.”

Jamie G

“Lynne was an excellent trainer, personable and delivered the topic at the pace of individuals. I entered the course with a fairly advanced level of Excel, despite this I learned a new thing about the application at every stage. Learning that Power Query was in excel and getting some practice was my highlight.”

Marcus T

“Really enjoyed all the content and found it super valuable. I've learned a lot more than I expected and can't wait to put everything into practice!”

Caz T

“We covered basics we thought we knew but there was so much I didn't realise that will be so helpful! It's been a really great couple of days. Part of me was dreading Excel training as I thought it would be confusing and boring but not only have I learnt so many valuable things, it's also been really fun!”

Jamie W

“The trainer, Wendy, was really helpful and very easy to understand. All information was very informative and helpful which makes the use of Excel so much easier with all the handy short cuts - Thank you.”

Sophie B

“Lynne tailored the course to match what l do on daily basis which made it easier to understand. I appreciate the training that Lynne gave me today, as I know the knowledge l acquired today will be a game changer for my career. ”

Sharlotte M

“Found the course very informative and the instructor knowledgeable

Zainul H

“Lynne was very nice and helpful. We covered a good amount in the day and i will be applying some of the things we learnt to my everyday work.”

Thomas C

“Very helpful trainer, Wendy made us feel comfortable to ask any questions we had or go over anything we were unsure about again. ”

Kirstie P

“Very useful course and Wendy was very helpful and patient ”

Lizzie W

“As a complete novice the course clearly explained the intricacies of Excel. The pace and manner was good, thoroughly enjoyed

Darren P

“Excellent, well paced course, lots of learning.”

David W

“Very good course. Very informative and I have learnt loads today. Many thanks.”

Melanie P

“Good course - went quite quickly at times so was pleased that the course had less attendees. Will be good to utilise the workbook at home to practice.”

Marina D

“Very informative course, just what was needed to enable me to build on my current Excel knowledge, have plenty of useful tips and 'know how' to take away and apply within my work area. Tim was very clear and concise and met our objectives.”

Sarah W

“Very good content clearly explained and easy to work with. Tim excellent tutor no issue too tough to answer.”

Chris B

“There is always something to learn on these courses and I did learn a great deal. The use of tables was great!”

Chris B

“A great introduction class. Tim was very helpful and introduced us to a good variety of tools which will improve my efficiency when using excel and other Microsoft office software. Thanks a lot.”

Maria K

“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.”

Mark S

“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

“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

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

Cez W

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

Martin L

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

Asad A

“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

“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