MS Office Training - Excel Advanced

The Excel Spreadsheet application, which forms part of the Microsoft Office
suite, is a remarkably powerful tool, yet sits on many people’s PCs with most of its capabilities unused. In particular, Excel’s formula language and function libraries can do things normally associated with specialised applications.

Duration

1 day

Objectives

Explore the facilities available to construct understandable, robust and re-usable workbooks, as required by Managers, Financial/Business Planners, Analysts and similar.

Prerequisites

Delegates should have experience of using Excel to an intermediate, and have a need to develop new workbooks, or enhance existing ones.

Topics

  • Named ranges
    • Creating
    • Using in formulas
       
  • Linking workbooks
    • Inter-workbook formulas
    • Hyperlinks
       
  • Addressing functions
    • OFFSET, ADDRESS, INDIRECT, etc
    • Dynamic named ranges
       
  • Using Excel lists (record sets)
    • Advanced filter
    • Database functions
    • Pivot tables
       
  • Array formulas
    • Copy, transpose
    • Array calculations
       
  • Structuring large or complex workbooks

A separate page on this site explores some of the technical issues and offers suggestions.
[Roy MacLean - IT] [VBA Training - Introduction to VBA] [VBA Training - Excel VBA] [VBA Training - Access VBA] [VBA Training - Word VBA] [VBA Training - Advanced VBA] [VBA Training - Excel Access Integration] [MS Office Training - Excel Advanced] [DITA Training - Introduction]