Microsoft Excel training tailored to you

  • Introduction course, Intermediate & Advanced available too

Who’s it for?

The Microsoft Excel Intro course is for complete beginners who need to understand the functionality of Excel.

Course overview

Learn to work efficiently, producing factual and well formatted spreadsheets.

Course outline

The Basics

The Excel Interface
Using Backstage View
Understanding the Ribbon
Using & customising the Quick Access toolbar

Organise Your Workbooks

Creating, saving & opening a new Workbook
Entering numbers, text & dates in a Workbook
Deleting Cell Contents
Quickly sorting data
Adding, deleting & naming sheets

Layout of Spreadsheets

Inserting Columns & Rows
Deleting Columns & Rows
Using Cut, Copy & Paste
Using Undo & Redo

Defining & Creating Calculations

Writing a basic formula
Understanding the order of BODMAS
The Sum function & AutoSum
Creating statistical functions (Average, Max and Min)
Working with Relative References when Copying Formulas

Presenting Your Data

Font formatting
Borders & Shading
Number formatting (currency etc)
Alignment options
Clearing formats

Printing Worksheets

Setting page margins & page orientation
Creating a Header & Footer
Printing all or part of a worksheet
Setting Print Titles for large Worksheets

Visual Representations of Your Data

Creating a chart
Changing the Chart Type
Basic Formatting of Charts

Learning outcomes

  • Create a spreadsheet from scratch
  • Format text & numbers
  • Learn shortcuts to work efficiently
  • Perform basic calculations
  • Present data visually using charts

Book your Microsoft Excel Intro course

Our Microsoft training is accessible in your office and to people working from home.

Get in touch today >

Follow-on courses

Please contact us to find out more about the intermediate and advanced Microsoft Excel courses.
We will keep you up to date with information on Microsoft training and certification recommendations, tailored to you for your teams and individuals.

Get in touch today >

Other Microsoft courses

Discover a great range of technical Microsoft training and certifications, all delivered by experienced IT trainers who are industry experts. We can source all Microsoft courses for your employees on your behalf including Microsoft 365, Teams, Power BI, Powerpoint and more.

Get in touch today >

Don’t just take our word for it

  • Effective training, well organised, achieving team development goals in Microsoft.DB
    HR Manager, Insurance company

Tell us what you’re looking for and we’ll find it for you

Contact us