Microsoft Introductory Excel 2019 training courses

We are now back to full face-to-face training at client site. We are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.

If you’re looking for really great Introductory Microsoft Excel 2019 training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Microsoft Introductory Excel 2019 training course, at your own premises at the same price as a standard course from elsewhere.

The JMD Training difference is clear:

We come to you. Your Microsoft Introductory Excel 2019 training will be given on your site
You get to keep the manuals. Introductory Excel 2019 training manuals are provided as PDFs
We can train using your own Microsoft Excel workbooks
There will only be people from your company on your course
We offer a money-back guarantee if any delegates are not completely satisfied
The training date is around you, not us!
Our prices are astounding
We can assess all learners in advance for free
Our courses are never cancelled

Visit our blog If Only I’d Known That,. We have called it that because we hear it so many times in training sessions. If only we had an extra £50 for every time someone says “If only I’d known that.” ….!

For example, you may have been working on several Excel workbooks. You have now finished for the day. You want to close all open workbooks and want to save the changes in each of them. With the workbooks open, hold down the Shift key. Click the Close button at the top right of the Excel Title bar. A box appears asking whether you want to save changes to the active workbook. Click Yes To All to save changes to all workbooks and close them all.

Organisations who have benefitted from our Introductory Excel training include:

“Fantastic session – active learning, engaging, well presented” – Sean, Fulham FC

Course Type	Cost per day
1 to 1 training	£315+ VAT
2 to 4 delegates	£495+ VAT
5 to 8 delegates	£645 + VAT

Prices are PER DAY, and NOT per-person! E.g. if there’s 6 people on the course, you pay £645 + VAT.

Provisional course outlines:

If you are new to Office 365, you may also be interested in our Office 365 upgrade training, workshops and floorwalking.

Our Microsoft Excel training courses London, are available not only in London, but Surrey, Middlesex, Richmond, Twickenham, Hounslow, Brentford, Putney, Wimbledon, Staines, Egham, Feltham, Reading, Kingston, Croydon, Epsom, Woking, Banstead, Farnham, High Wycombe, Crawley, Sutton, St Albans, Fulham – in fact anywhere within the Home Counties and M25 corridor.In fact we train anywhere within the Home Counties and M25 corridor. We have Microsoft Excel trainers in Twickenham, Richmond, Ashstead, Lightwater, Ascot, Central London, New Barnet, Ilford, Surbiton, Slough, St Albans, Bushey, Crowthorne, Basingstoke, Whiteley, Wembley, Thatcham, Watford, Wallington, and Romford ! If you are based within 30 miles of any of these locations we would not charge travel expenses for the trainer. We can still provide Microsoft Excel training courses outside these areas. We would then, however, need to charge for the travel expenses of the Excel trainer.

“Course was well planned and seamlessly flowed. Janet was very knowledgeable and friendly. Learned a lot of skills/ hacks. shortcuts, had to previously google”

Course Overview
Course Outline

Aims of the Introductory Excel 2019 course

This course aims to introduce delegates with little or no understanding of the Microsoft Excel software to the basic features of the package.

Course Objectives

On completion of the course delegates should understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. They should also be able to accomplish standard mathematical and logical operations using basic formulae and functions. They should also be able to use some of the more advanced Microsoft Excel applications such as importing objects, and creating graphs and charts.

The course is of one day's duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites

Delegates attending the course should preferably have a basic understanding of the Windows environment and use of the keyboard and mouse.

Getting Started

Opening Excel
Understanding the Ribbon structure
Opening a workbook
Creating a new workbook
Closing a workbook
Using Help functions
Changing spreadsheet view mode
Using the Zoom tool
Modifying the Quick Access toolbar
Saving workbooks - as Excel workbooks and as pdfs

Basic Operations

Inserting Data – numbers, text, symbols, special characters, simple formulae, using undo
Selecting Data - cells, range of adjacent or non-adjacent cells, rows, columns
Copying, Moving, Deleting
Finding and Replacing
Inserting rows and columns
Modifying row height and cell width
Deleting rows and columns
Sorting Data

Formulas and Functions

Arithmetic and Logical Formulae - addition, subtraction, multiplication, division, standard error messages
Cell referencing - relative cell referencing, absolute cell referencing, mixed cell referencing
Working with Functions - SUM, AVERAGE, MIN, MAX, COUNT,

Formatting

Formatting Numbers and Dates - number of decimal places, commas to indicate thousands, number of zeros after the decimal point, date styles, currency, percentages
Formatting Cells - text size, bold, italic, font type, underline, double underline, font colour, wrapping text, text orientation, cell background colour, format painter
Formatting Cell Ranges - centring and aligning cell contents, centring a title over a cell range, adding border effects
Cell styles
Applying table formats

Charts and Graphs

Using charts/graphs – producing different types of graphs and charts to analyse data, editing or modifying charts or graphs, changing chart type, moving and deleting charts or graphs
The Recommended Charts feature

Preparing Outputs

Worksheet Setup – modifying worksheet margin settings, adjusting worksheet setup to fit one page, adding a header and footer, changing document orientation, page size, etc.
Spelling
Print Preview and Page Break Preview
Applying automatic title rows printing on every page of a worksheet
Printing Simple Worksheets – using print options, previewing a spreadsheet, printing a spreadsheet or a worksheet, printing part of a worksheet or a pre-defined cell range

Introduction to Sorting and Filtering

Creating a table
Sorting data
Filtering data

Quick Analysis

Request Course Now »

We provide Microsoft Excel training courses, Microsoft Office training courses, other IT training courses and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Reading, Croydon, Epsom, Banstead, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.

For Microsoft Excel training courses Sydney, Australia, please visit our sister site http://www.jmdtraining.com.au/microsoft-office-training/microsoft-excel-training