Excel training

Become fully proficient in using Excel. Our one-to-one training sessions will clarify and explain all you need to know about constructing and formatting spreadsheets, how formulas and cell referencing work and how to prepare great looking lists and records.

Versions covered: Excel 2016, Excel 2013 and all older versions 2010 2007, 2003, XP or 2000

Includes autofill, charts, workbooks, formatting and all the useful productivity features that make it quicker and easier to use.

Starting with Excel

Rows and columns, entering text and numbers in a cell

How to edit text in a cell; formatting cells and data

Apply borders to cells and ranges

How to use AutoFill

Simple addition formula; the SUM function

Copy and Paste, and how to use Paste Special

Absolute cell references

Page setup options

 

Charts and data

How to sort data in Excel

Create an Excel chart

Move and resize your chart

Chart styles and layouts, and formatting charts

Filter data in a table

Functions in Excel

Average, Count

Date and time functions

financial functions

The IF function

Conditional Formatting

CountIF and SumIF


Intermediate / Advanced Excel 

Improving the appearance of a spreadsheet

Create and use labels and names in a workbook
Hyperlinks in Excel

Object Linking and Embedding

Linking to other Worksheets

Insert Drawing Objects

How to use Lookup and Reference functions

Protect data in worksheets and workbooks

Create recorded macros in Excel

Also available, other Office tools

Word Processing - Microsoft Word
Presentations and graphics - PowerPoint
Email, calendar and contact management - Outlook

We are based in south Buckinghamshire and serve an area between Chesham and Marlow, and between Princes Risborough and Gerrards Cross. Please look at our Map page for more details of who’s covered by our services.


For more information, contact us with your requirements or questions.
And please explore the information on other parts of this website.

Subpages (1): How to use Excel