Training for the Future

Advanced Excel for Business Executives

Course Code: AEFE

Dates: 12 Dec - 16 Dec | 17 Apr - 21 Apr | 17 Jul - 21 Jul | 9 Oct - 13 Oct | 11 Dec - 15 Dec


Duration: 1 Week /s

Course Objective

This course is designed to make delegates gain mastery of the most advance tools provided on the Excel platform. Delegates will be able to build interactive financial and quantitative models for bespoke business solutions. The use of result driven case study, taught in the context of actual business problem, will make delegates join the tiny echelon of elites who can do virtually anything with Microsoft Excel

Who Should Attend?

Managers, business/marketing executives, financial/management accountants and financial analyst

Prerequisite Courses

Basic Excel skill

Course Overview
  • Mastering advance features of the latest versions of Microsoft Excel

  • Creating and manipulating the new Excel dynamic tables

  • Implementing complex business rules using function-driven routine validations

  • Using sophisticated functions to solve real world business problem

  • Using advance Excel skills to publish a inclusive web site from a work-book

  • Eradicate errors using Excel’s advanced formula auditing outfit

  • Construct intuitive user interfaces using forms controls

  • Understanding the vertical and horizontal look-ups (V & H LOOK-UP)

  • Execute what-if analysis to model and evaluate business scenarios

  • Recording macros and then executing them from remote button control

  • Understanding and using all of Excel’s security features

  • Generating and using dynamic and table-based range names

  • Designing advanced Pivot Tables and Pivot Charts

  • Creating hyperlink among Microsoft Excel, power point and other Microsoft office programs

  • Learning Goal

    After completing this course, delegates should be able to:

  • Create Sophisticated worksheets for presentation to top level management

  • Apply Excel to solve financial problems by developing models for tailored use

  • Create simple computer program on the Excel platform to model business and financial process

  • Develop a network of hyperlink for a comprehensive Microsoft office integration

  • Display a comprehensive know-how of the most sophisticated spread sheet application in world

  • Course Materials

    Course notes, case study / exercise materials

    Book This Course Cancel Top of Page