Skip to content

GAC Corporate Academy

Narrow screen resolution Wide screen resolution Increase font size Decrease font size Default font size    Default color brown color green color red color blue color gac color Learning wherever you go
 
You are here: Home arrow Advanced MS Excel (XLA)
Skip to content
Advanced MS Excel (XLA) PDF Print

Do you use Excel regularly? Do you wish you could manage your data (and time) more effectively? Do you need to employ more advanced techniques than you currently use? Join XLA and take control of Excel like never before!

The things you will learn in this course will transform your day to day use of this application. Impress your managers, colleagues and even your customers by becoming a true power user of spread sheets.

Excel is probably the most widely used computer desktop application in the world of business, and how you use Excel in your work role will dramatically improve by taking this course. By completing this GAC corporate academy course you will increase your efficiency and productivity as you use Excel every day. Excel is the ultimate business tool - so become an expert user!

Who this course is for:

This course is designed for all personnel who wish to raise their MS Excel skills to the highest possible level.

What this course covers:

  • Naming areas of your worksheets for more meaningful formula, and use the power of applying relative and absolute references.
  • Linking separate worksheets and workbooks.
  • Application of advanced power formatting techniques.
  • Creation of conditional statements to make automated decisions in your worksheets.
  • Management of large spreadsheets more effectively, through listing techniques, advanced filtering, indexing and lookups.
  • Extensive knowledge of charts and graphs.
  • Creation of pivot tables to enable summarising and manipulation of data in a simple yet sophisticated manner, understand your data more clearly and share summarized views.
  • Use of advanced functions such as goal seeking, problem solving and building interactive scenarios for "What if?" projections.

How this course will be taught:

XLA runs for eight weeks and is delivered via our state-of-the-art interactive online Learning Management System.

Who to contact:

The course is open to GAC employees. For further information, please contact This e-mail address is being protected from spam bots, you need JavaScript enabled to view it , Business Development Manager - GAC Corporate Academy.