On Demand (eLearning)

Advanced Excel Formulas

FEB 27 - Mar 31, 2019

Online

DATE

FEB 27 - MAR 31

2019

TIME

2:00 PM - 11:30 PM

WHO CAN ATTEND

All

PD HOURS

4 Hours

ETHICS HOURS

0 Hours

STATUS

Registration closed on

Mar 31, 2019

EVENT DESCRIPTION

This event has now passed, please click here to view all available upcoming events and courses

Learn advanced formulas, functions and financial analysis to be an Excel power user. This course is designed for proficient spreadsheet users looking to take their skills to the next level.

You will set up a template to structure an intelligent design for financial analysis. By using advanced functions, you will build financial statements and perform analysis. Once complete, you’ll create data tables and pivot tables to display information and charts and graphs to show results. To speed up analysis, you’ll record macros, and create additional user interfaces.

LEARNING OBJECTIVES:

By the end of this course, you will be able to:

  • create auto-updating Excel spreadsheets
  • build dynamic financial statements
  • perform financial analysis
  • draw on advanced functions for insightful analysis
  • PRICING

    $60.00 Personal Passport

    $60.00 Organization Passport

    $60.00 Member

    $60.00 Student

    $60.00 Public

    Status: Registration closed on Mar 31, 2019

    LOCATION

    Online

    SPEAKER(S) BIO

    Tim Vipond is an entrepreneur, financial analyst and former investment banker. He has worked across a wide range of corporate finance, financial modelling and forecasting roles at CIBC World Markets and Goldcorp Inc. Tim is the CEO of the Corporate Finance Institute®.

    Lisa Dorian has designed and delivered courses for the financial services and corporate sectors in strategy and analysis to numerous organizations, including Bank of Montreal, Deutsche Bank, and ATB Financial. Lisa is a CPA and Managing Director of MDA Training Inc.

    Scott Powell has over 15 years of experience designing and delivering Wall Street training programs for many of the world’s large investment banks. His clients include Allied Irish Bank, Bank of America and Merrill Lynch. Scott specializes in financial modeling, business valuations, and asset management.

    SPECIAL INSTRUCTIONS

    This eLearning course is divided into several online modules which you can access on any device. You are encouraged to complete the course in sections to accommodate your schedule.

    This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.

    However, you will only have access to the course for 30 days after REGISTRATION closes.