Excel Training: Analysis & Reporting for Finance

Course Delivery

Live Instructor-Led Training

Course Description

The course Analysis & Reporting for Finance (Excel Training) teaches you how to use MS Excel to present, analyze and format financial data. The training includes data layout, basic math & financial functions and advanced financial analysis with MS Excel. You learn about present value and future value, WACC, IRR, cash flow calculations & interest considerations. Become a financial wizard with MS Excel.

Course Dates and Pricing

Mar 6 - 9, 2018$2,775.00Apr 10 - 13, 2018$2,775.00May 8 - 11, 2018$2,775.00Jun 5 - 8, 2018$2,775.00

Course Outline

Microsoft Excel Essential Skills Revised

Identifying and Referencing Cells
Working with Cell Contents
Formatting Cells
Working with Formulas
Business Graphics
Exercise: Setting up the Business Data

Working with Data

Characteristics of a Database Layout
Using Cell Names to Prepare the Data
Using Filters to Sort and Filter the Data
Creating Custom Filters to Find the Data you need
Using Search and Find Functions to Locate the Data you need
Using Subtotals to Summarize the Data
Removing Duplicates
Using Custom Functions to Clean the Data
Exercise: Summarizing the Data with Excel Functions

Advanced Functions: Conditional Logic

Using Conditional Formatting
Planning for Conditional Logic
Using a Single If Function to Implement Conditional Logic
Using Multiple If Functions to Implement Complex Conditional Logic
Using the AND and OR Functions to Implement Complex Criteria
Using Negation and DeMogan?s Theorem to Simplify Logic
Exercise: Implementing Complex Logic in Support of Data Cleanup

Performing a Preliminary Analysis of Financial Data

Determining Maximum and Minimum Values
Calculating Measures of Central Tendency: Average and Median
Calculating Dispersion Measures: Variance and Standard Error
Creating Frequency Distributions: Frequency, Relative Frequency and Cumulative Relative Frequency
Displaying Category Totals and Subtotals
Using Pivot Tables for Effective Presentation

Financial Essentials part I: Interest and Payments

Essential Terms and Concepts: Discount Rate, Compound Interest and Net Present Value
Calculating Compound Interest and Factoring In Compounding Frequency
Establishing an Appropriate Discount Rate
Calculating the Future Value of an Investment
Calculate Loan Payments for a Present Value
Calculating the Payback Period and the Discounted Payback Period
Calculating the Present Value of Future Cash Flows
Exercise: Essential Financial Calculations

Financial Essentials part II: Net Present Value and Internal Rate of Return

Essential Definitions: Net Present Value and Internal Rate of Return
The Role of the Discount Rate
Determining a Project?s Net Present Value (NPV)
Determining a Project?s Internal Rate of Return
Decision Rules for IRR and NPV: When they Agree and When they Disagree
Calculating NPV with Variable Interest Rates
The Multiple NPV Problem
Practical Exercise: Calculating the Net Present Value and the Internal Rate of Return of Future Cash Flows

The Weighted Average Cost of Capital (WACC)

WACC and Financial Justification
Definitions and formula for the WACC
Determining the Cost of Debt
Factoring in Taxes Payable
Determining the Cost of Equity
Calculating the WACC for an Organization
Calculating the WACC for a Project
Using the WACC to make Project Decisions
Using the WACC to determine an Appropriate Discount Rate
Practical Exercise: Calculating the Cost of Debt and the Cost of Equity
Practical Exercise: Using the WACC to make Decisions

Earned Value Management

The EVM Template
The Basics the Earned Value Management
Defining a Method for Measuring Progress
The Basics: Earned Value, Present Value and Actual Cost
About Estimate At Completion and Budget At Completion
Determining Progress: Cost Variance and Schedule Variance
Useful Ratios: CPI, SPI and TCPI
Forecasting: The Art and Science
EAC Forecasts: Budgeted Rate, Present CPI and Present CPI/SPI
Practical Exercise: Using EVM to Assess Progress

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related Microsoft Excel Training

Excel Training: Data Analysis for Business Users

The course Data Analysis for Business Users (Excel Training) teaches you to organize, analyze, validate and present data using Microsoft Excel. Starting with data layout, the course explores basic and advanced functions. The training includes a detailed discussion of conditional, math & logic functions, PivotTables, Charts and a comprehensive introduction to Macro development. Training course titled Excel Training: Data Analysis for Business Users that will allow you to hone your professional skills.

Apr 16 - 17, 2018$1,150.00May 14 - 15, 2018$1,150.00Jun 11 - 12, 2018$1,150.00

Excel Training: Cells, Workbooks and Graphs

The course Cells, Workbooks and Graphs (Excel Training) teaches you how to work efficiently with cells, worksheets & workbooks. The training includes working with multiple worksheets, useful keyboard shortcuts & functions, absolute & relative references and custom functions. You learn to set your data so that it can be easily sorted and filtered. The course also covers how to create, edit & format graphs in MS Excel. Maximum productivity is within your grasp with Microsoft Excel. Training course titled Excel Training: Cells, Workbooks and Graphs that will allow you to hone your professional skills.

Apr 30 - May 1, 2018$1,150.00May 28 - 29, 2018$1,150.00Jun 25 - 26, 2018$1,150.00

Excel Training: Data Analysis & Reporting

The course Data Analysis & Reporting (Excel Training) teaches you to analyze & report on data using Microsoft Excel. The course covers data layout using multiple Excel worksheets and custom & advanced functions. The training includes Excel graphs, PivotTables and the use of custom functions, sorting & filtering to analyze & report on data. Training course titled Excel Training: Data Analysis & Reporting that will allow you to hone your professional skills.

Apr 23 - 24, 2018$1,150.00May 22 - 23, 2018$1,150.00Jun 18 - 19, 2018$1,150.00

Excel Training: Mastering Task Automation

The course Mastering Task Automation (Excel Training) provides business participants with the skills they need to automate almost any business task. Starting with a review of essential concepts in data analysis using Microsoft Excel, the course quickly proceeds to a complete and in depth study of macros and VBA development. The course covers every aspect of VBA development including the Excel object model, looping, functions, conditional logic and database access amongst others. If you need to use Microsoft Excel to automate your business tasks, this SETC certified course will teach you the skills you need. SETC Training - Formation SETC provides advanced Microsoft Excel training in Ottawa, Montreal, Toronto, Quebec and Calgary. Training course titled Excel Training: Mastering Task Automation that will allow you to hone your professional skills.

Apr 25 - 27, 2018$1,675.00May 23 - 25, 2018$1,675.00Jun 20 - 22, 2018$1,675.00