Excel

EXCEL INTERMEDIATE - ONE DAY

Microsoft Office Excel training the way you need it, when you need it.

Description

This course is designed for existing Microsoft Excel users, or those that have attended the Microsoft Excel Introduction training course, who wish to explore the application further.

Pre-Requisites

Delegates should be familiar with Microsoft Windows and have a basic understanding of spreadsheets.

Course Content

Review of Excel Basics

  • Basic formulae: +, -, *, /
  • Autosum
  • Autofill
  • Charts
  • Exporting worksheets and charts into a document

Working with Worksheets

  • Renaming, inserting, deleting, moving and copying worksheets
  • Grouping worksheets
  • Creating links between worksheets and performing calculations

Data Lists

  • Sorting & filtering
  • Sub-totals

Functions

  • Min
  • Max
  • Average
  • Basic If

Other Formulae

  • % calculations
  • Absolute cell referencing

Other

  • Freeze panes
  • Word wrap
  • Diagonal text
  • Using autosum for sub totals and grand totals
  • Comments


Click here to download this course outline.