Formulas and functions: An introduction to the power of Excel

Discover a wide range of powerful tools within Excel to maximize the functionality and impact of your financial spreadsheets.

Event Details

Location and date:
Online On-Demand Event

The more you know about Excel formulas and functions, the better equipped you will be to present financial information in meaningful ways. This online course delves into a beginner’s level of formulas, and shows you how to take Excel from a static sheet of paper to a dynamic calculator with simple formulas to sum up columns and rows.

You will learn how to build spreadsheets for inventory analysis, income forecasting and cash flow and balance. You’ll be able to follow allow along with extensive course resources, ebooks and practical examples, all of which will be yours to keep.

View Table of Contents

Additional options and pricing may be available. See pricing and registration for more details.



$145.00

2 CPD hour(s)
Pricing & registration

You will learn about:

  • the difference between Excel formulas and functions
  • creating simple formulas, including those that use ranges as inputs
  • the differences between absolute and relative cell referencing
  • using functions within formulas
  • the concept of nesting formulas
  • basic uses of mathematical and logical functions

Who should attend?

  • advanced Excel users
  • IT professionals
  • business intelligence educators
  • consultants
  • financial analysts

More Details:

Session Descriptions

Introduction
Welcome

Formula Basics
• What We Will Cover
• Formula Basics
• Using Ranges

Function basics
• Function Basics
• Using Ranges in Functions
• Function Basics Pt. 2
• Five Common Functions
• Logic Functions
• Logic Functions Pt. 2

Case study #1: Analyzing the weekly sales reports
• Analyzing The Weekly Sales Reports
• Continuing the Weekly Sales Report
• Extracting High’s and Low’s of the Weekly Sales Reports

Case study #2: Building an income forecast
• Building An Income Forecast
• Completing the Income Forecast

Case study #3: Building a cash flow statement
• Building A Cash Flow Statement
• Continuing to Build the Cash Flow Statement
• Financing Aspects of the Cash Flow Statement
• Continuing Financing Aspects and Completing the Cash Flow Statement

Case study #4: Building a projected balance sheet
Building A Projected Balance Sheet

Conclusion
• In Review
• Conclusion
• Final Quiz

Speakers/Presenters

You may also be interested in:

Contacts

Please contact:

CPA Canada Professional Learning and Development Customer Service
Tel: 1-888-337-3242
Email: pld@cpacanada.ca

Highlights

Update your knowledge and strengthen your network at this must-attend conference covering the most important issues and trends affecting audit committee members.

It’s probable that someone you know is deep in debt. If you are observant, you might see one of these seven signs.