Advanced Professional Excel Certification Program

Advanced Professional Excel

PROFESSIONAL ADVANCED EXCEL 2016

Excel Training
GBT SOLUTIONS INC.
2 ROBERT SPECK PARKWAY
SUITE 750
MISSISSAUGA, ON
L4Z 1H8
CANADA
Email : www.gbtsolutions.ca

Course Overview

The power of Microsoft Excel is its ability to allow users to manipulate texts and numbers, through build in or custom functions. This course will focus on the core competence of Microsoft Excel functions and formulas. The objective of this course is to enable delegate understand the main MS Excel functions and formula, the skill management systems that we provides as part of the course provides simulation and practices that enable delegate master the skill and gives them feedback on their learning progress, the ultimate objectives is to give participant skills and competence

DAY ONE

  • Excel Navigations
  • Workbook and Workbooks customizations
  • Excel Operators
  • Excel Functions
FINANCIAL MODELING
BUSINESS PERFORMANCE ANALYSIS

DAY TWO

  • Text Formula
  • Statistical Formula
  • Logical Formula
  • Lookup Formula
  • Mathematical Formula
  • Financial Formula

DAY THREE

  • Data Analysis and Grouping
  • Data Validations
  • Data Consolidation
  • What if Analysis
  • Macro
  • VBA
business valuation methods
Business Valuation

WHO SHOULD ATTEND

  • CFO’s and Finance Managers
  • Department Managers
  • Financial Professionals
  • HR Professionals
  • Procurement Manager
  • Administrations Staff
  • Management Accountant
  • Financial Accountant
  • Treasury Staff

LEARNING OUTCOMES

1.  Microsoft Excel Navigations
2.  Workbooks and worksheets set up
3.  What is Microsoft Excel Functions
4.  Apply CAPM &Different ways of entering Microsoft functions into the worksheet
5.  Different Excel functions including Text, Statistical, Mathematics, lookup and Financial functions
6.  Macro and VBA

IN-HOUSE

Interested in this course please call us on +1800

IN-CLASS

Interested in joining one of our seminar please call us on +1800

ONLINE -DISTANCE LEARNING

Interested in learning from the comfort of your home or office please call us on +1800