Home
Flowerdew


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


Contact us
About

Backback

Advanced Microsoft Excel

This is a one-day advanced course for those who are already experienced spreadsheet users, knowing most of the introductory and intermediate topics and who wish to become fully familiar with the remaining powerful features of Excel. 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 used.

Outline:

  • Analysing data with Pivot tables
  • Linking to external databases
  • Using Goal Seeker
  • Finding optimum solutions with Solver
  • Creating and using data Views
  • Creating and using Scenarios
  • Further macros
  • Using Form controls
  • Hints and tips