613-454-8097
Contact
SETC Training - Formation SETC
Search
Toggle navigation
Management and Leadership
Professional Development
Programming
Servers & Networks
Pricing
About Us
Toggle navigation
Book a Course
Ask a Question
Pricing
Get PDF
Back
Microsoft Excel for Financial Professionals: Analysis and Reporting
(EXCFIN, Live Instructor-Led Training, 4 days)
Dates and Pricing
Jan 9 to Jan 12, 2018
$2,500/person
Feb 6 to Feb 9, 2018
$2,500/person
Mar 6 to Mar 9, 2018
$2,500/person
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
Toggle navigation
Book a Course
Ask a Question
Pricing
Get PDF
Back
Toggle navigation
Management and Leadership
Toggle navigation
Agile Training
Agile SCRUM
Change Management
Process Management
Financial Management
Project Management
Risk Management
People Management
Leadership Training
Entrepreneurship
Professional Development
Toggle navigation
IT for Everyone
Business Analysis
Testing
Business Writing
Conflict Resolution
Presentation Skills
Time Management
Microsoft Office
Program Evaluation
Problem Solving
Data Analytics & Metrics
Customer Service
Consultation and Engagement
Programming
Toggle navigation
.NET
Java
C++
HTML
JavaScript
PLSQL
Servers & Networks
Toggle navigation
Linux
Server 2016
IT Security
SharePoint
BizTalk
Oracle
SQL Server
zOS & DB2
Windows 10
TFS
IIS
IPv6
VOIP
Cisco
Telecom
Project Server
About Us