Financial Spreadsheet Techniques – Part One

4 Comments / By /

Course Information

This is a course for users of Excel who have had some experience with Excel. It focuses on the financial aspects and capabilities of Excel!

Course Instructor

icpdadmin icpdadmin Jon Heales
 

Fin Spreadsheet Tech 1

FREE
Enroll

Introduction

Getting Started
Basic Techniques
Terminology and Navigation
Spreadsheet Modelling Procedures
Modifying Worksheets

Spreadsheet Modelling and Financial Functions

Review of Spreadsheet Functions
Loan Pricing – Efficient Spreadsheets
Interest Schedules
Growth Variables
Depreciation Schedules

Links, Advanced Formulae and Solver

Links
Advanced Formulae
Income Tax Rates

Capital Budgeting and Risk

Capital Budgeting Analysis
Risk Analysis and Optimisation

Interrogation

Budget Formulation
Financial Forecasting and Budgeting
Financial Data Analysis Functions
Descriptive Statistics
Regression and Beta
Monte Carlo Simulation

Databases, Filtering, Pivot Tables

Databases
Filtering
Pivot Tables

Macros and VBA

Macros
Visual Basic for Applications

4 thoughts on “Financial Spreadsheet Techniques – Part One”

Leave a Reply

Your email address will not be published. Required fields are marked *