Advanced Spreadsheets


Advanced Spreadsheets

Course Aims

The aim of this course is to give candidates a comprehensive training in the specialised features of this powerful spreadsheet software, focusing on practical business applications such as:

  • sales figures, budgets, forecasts, etc.
  • databases
  • analysing statistical or numerical possibilities presenting statistical reports, etc.

Course Content

  • Creating spreadsheets
    • Inserting data
    • Inserting Formulas and Functions
    • Formatting and Editing Data
    • Formatting the layout of the spreadsheet
  • Relative and absolute cell address
  • Editing between worksheets and workbooks
  • Organising and analysing data
    • Sorting data
    • Filtering Data
    • Database Functions
  • Auditing a Worksheet
  • Creating Reports using Subtotals, Consolidation Scenarios, Goal Seek and Solver Utilities, etc.
  • Using advanced Functions e.g.; If Function, VLookup
  • Advanced Formatting. e.g. Styles, Templates, Conditional Formatting
  • Working with Pivot Tables
  • Linking between worksheets and workbooks
  • Sharing data between Microsoft Excel and Microsoft Word
  • Charts
  • Objects and Drawing

10am – 3pm, 2 days

Entry Requirements
Knowledge of Microsoft Excel basic features and calculations.


Powered by Netfirms