Alan Fazakerley Computer Training courses for Home and Business, provided by a Microsoft Certified Trainer.
Contact me today on 07753 620242

Excel Introduction

For basic learning of how to build a spreadsheet:

  • Entering data
  • Formatting the cells
  • Create formulae
  • Printing
  • Use basic Functions (SUM / AVERAGE etc)
  • Insert / delete columns & rows
  • Hide columns & rows
  • Create charts

Excel Intermediate

Learn how to enhance your spreadsheets:

  • Calculate across spreadsheets
  • Using Text Functions to manipulate imported data
  • Conditional Format to automatically shade cells based on values
  • Sort / Filter / Sub-totals
  • Use the IF Function
  • Using the VLOOKUP Function
  • Create Pivot Tables to summarise data
  • Protect the spreadsheet

Excel Advanced

For the more advanced user, summarise data with Pivot Tables and create and store Scenarios:

  • Calculate across Workbooks
  • Data Validation (create drop down lists, ensure values are within limits)
  • Create Pivot Tables
  • Using 'What If' Scenarios
  • Goal Seek & Solver
  • Sharing workbooks
  • Macros