Excel

This is just some of what we offer in Microsoft Excel training. Please ask for a detailed Excel Spreadsheets Course Content Sheet to select what you would like to learn. If you're a complete beginner just one day can teach you all you need to create a basic spreadsheet from scratch; if you feel more confident, or are a more advanced user, just mix and match those topics you would like to learn. Click here to see the training rates.

Choose a level or mix and match to select exactly what you wish to learn.

Many people receive Excel spreadsheets with their sales figures and often don't know how it has been put together. Learn what a day's Excel training can do - how to present your work in the best way, centre headings, write formulae, create running totals, insert rows and columns, merge cells, insert charts and graphs, and use its data processing features. Or alternatively, increase your knowledge of how to write formulae, functions, pivot tables and more.

Tell me what you need and I will prepare a day's training just for you.

Beginners

• Introduction to Excel 2000, 2003 or 2007
• Crossover to Microsoft Excel 2007
• Creating, editing and saving an Excel spreadsheet
• Page layout – margins, landscape, portrait, fit to size, gridlines
• Autofill and Autolists
• Column and Row inserting, deleting, moving
• Print features
• Header/footer
• Basic Formula writing - relative and absolute
• Sum, count, max, min functions
• Linking worksheets
• AutoSum and other functions
• Date and Currency formats
• Useful shortcut codes for quick navigation of your text and for editing purposes
• Create charts and graphs
• Autofilter and sorting
• Conditional Formatting

Intermediate

• Excel Spreadsheet Layout enhancements and customisation – formatting cells, spacing, alignment, borders
• Advanced chart and graph presentation – manipulating data, formatting text, enhancing layout
• Custom Number formats
• Using comments
• The MDAS rule
• Use of Function Wizard - writing formulas
• If and lookup functions
• Customised filters and autofilters
• Managing large Excel spreadsheets effectively – linking, naming cells, using names in formulas
• Paste Special
• Freeze panes
• More Printing options
• Validation, lists and input messages
• Custom lists

Advanced

• Creating, editing and running Macros
• Tracking and auditing
• Forms
• Error messages in formulas
• Conditional formatting
• Nested functions
• Match, FV, PMT functions
• Nested if statements
• V and hlookups
• Input Data Tables
• Pivot tables
• Subtotals
• Advanced filters
• Importing external data
• Exporting data
• Inserting pictures and hyperlinks
• Default customisation of Excel spreadsheet layout
• Using styles

If you are unsure of your requirements please contact me

Top of Page