Excel

Our Excel Training workshops are tailored to meet your specific needs, taking you through all the features of Excel you require, often focussing on a specific business requirement.  Detailed below are a selection of the topics which can be covered during training:

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 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 Subtotals
  • 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/IF Functions
  • Devise a complex spreadsheet which is specifically required by your organisation.

For further information, please call 0114 4040 160 or Contact Us.