Excel Training courses • Intermediate tutor led Excel training courses

Trainers are all Microsoft Certified. We have a new Excel course - Advanced Chart, Pivot Table and Dashboard Concepts for more details

Please enquire if you are interested in achieving Microsoft Office Certification

Check Scheduled course dates for training in Sheffield or Chesterfield or organise a bespoke course for your organisation.

Excel Intermediate - What will I cover?

 

By the end of the course, using practical hands-on tuition, you will have an understanding of the following features and techniques:

  1. Naming ranges-Navigating to cells and ranges quickly and use names to calculate.
  2. Conditional formatting:-Formatting cells according to their contents - highlight figures below and above a certain value automatically
  3. Conditional Logic-IF, AND and OR.
  4. Automatic subtotals:-Creating subtotals without altering the layout of your spreadsheet.
  5. Sorting and filtering:-Ordering your data, usinge filters to view certain data.
  6. 3D Formulae and linking:-Pulling data from other worksheets. Calculating between multiple worksheets.
  7. Pivot tables:-Tables from listed data in a worksheet.
  8. Charts:-Create graphical representations of your worksheet data.

 

 



The above outlines are intended as a guide only, topics may not be covered in this order. Actual course content can be tailored to suit client's needs.

Please contact us for charges and further details on either bespoke or scheduled courses.