School Event

Advanced Excel - Microsoft Excel Level 3

Overview

The role of managers in companies today is expanding. The program MS-Excel is used by many departments, but most users only “scratch the surface” of the many ways Excel can be used to perform analysis.

This intensive 2-day course has been developed to introduce managers to the many ways that Excel can be used as a support tool for management decisions. The course is filled with practical exercises that allow delegates to find out how to get the most out of Excel with the least additional effort.

Course Outline

  • Using Excel to take control of financial data and put it into a format that can be used for effective decision making
  • Taking advantage of Excel’s many specialised features to produce management reports, quickly and easily
  • Using Excel’s advanced features to import data directly from other systems, sources and applications
  • Methods for implementing profit/cost tracking to help identify possible problems before they occur
  • Developing projections and trend analysis spreadsheets to assist with management decision making
  • Automatic creation of graphs and charts to help illustrate key financial issues and trends
  • Writing and using Excel Macro’s and Formulae to save time by automatically doing repetitive work.

Learning Outcomes

  • Set up Excel databases and pivot tables to effectively use the same data for different purposes
  • Utilise Macros and advanced functions to save time when manipulating data and setting up reports
  • Develop projection and trend analysis spreadsheets to assist with management decision making
  • Understand how to import data directly from other applications to make a wider range of information available for analysis
  • Conduct profit and cost variation, sensitivity and margin analysis to help highlight problems before they occur
  • Manage risk by checking the effect that external factors (such as inflation) may have on costs, profits and results
  • Produce easy to understand reports and charts, highlighting critical management information

Who should attend?

Line Managers,
Commercial Managers,
Accounts assistants,
Estimators,
Strategic Managers,
Project Managers
and anyone involved in management decision makers.

Dates and Times:
  • Thu 8 June 2017  08:30 to 16:30
  • Fri 9 June 2017  08:30 to 16:30
Type: Course
Venue: CESA Training Centre, Johannesburg , Paulshof
Fee: R 6 096.49 excl. VAT
R 6 950.00 incl. VAT
R500.00 discount incl. VAT for CESA members
CESA Validation Num: CESA-846-03/2019
CPD Points: 2
Coordinator: Blessings Banda
Provider: Technology Financial Services
Presenter: Alex Nortje