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.