Making the Most of Excel

Our Excel Training Courses are tailored to meet your specific needs, from short 'bite-size' 2 hour individual sessions to group workshops, taking you through all the features of Excel you require, often focussing on a specific business requirements. Deatiled below are a selection of the subjects which can be covered during training.

Features include - Excel Foundation

• Understand and use basic formulae and the AutoSum function
• Have the ability to use specific data formats (e.g. currency)
• Customise a spreadsheet using colours, patterns and borders
• Be aware of the easy-to-use time-saving features within Excel
• Know how to generate charts and graphs

Excel Intermediate

• Effectively use worksheets inside spreadsheets
• Understand how to validate data, i.e. ensure that cells can only contain specific values
• Know how to sort and filter data and use sub-totals
• Know how to automatically transfer data between worksheets and spreadsheets
• Devise a spreadsheet which is specifically required by your organisation

Excel Advanced

• Understand how to use the ‘Lookup’ features
• Know how to analyse data using Pivot Tables
• Be aware of how to automatically perform commands or actions using Macros
• Use the Date / Time / IS functions
• Devise a complex spreadsheet which is specifically required by your organisation

For further information, please call 0114 236 4062 or  Contact Us.