Formulas and functions: Introduction to Excel

This is the agenda for Table of Contents
Table of Contents


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


• In Review
• Conclusion
• Final Quiz


Chartered Professional Accountants of Canada (CPA Canada) annually offers its views on priorities for the federal budget. Review past submissions of pre-budget briefs and consultations, and post-budget release opinions and commentary.

Our Firm Directory allows you to search for Canadian CPA firms using our interactive map as well as other criteria.

Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.