Home
Flowerdew


Courses
Accelerated courses
T.N.A. (Training Needs Analysis)
Bespoke


Contact us
About

Backback

Intermediate Microsoft Excel

This is a one-day course for people who have an understanding of the topics listed in the Overview or Introductory course and who wish to increase their productivity through the use of additional features. The course can be run using Excel 2010, 2007, XP or 2000, and will be adapted to make the most of the features available in the software.

Outline:

  • Range Naming
  • Using Outlining features
  • Working in group mode (multi-sheet)
  • Using Style
  • Creating and using Template
  • Advanced Charting
  • Creating automatic subtotals
  • Protecting a workbook or parts of worksheets
  • Using cell notes
  • Consolidating data
  • Linking and embedding data
  • Using additional functions
  • Introduction to macros