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
Lesson 1 of 5 within section Introduction.
Basic Techniques
Lesson 2 of 5 within section Introduction.
Terminology and Navigation
Lesson 3 of 5 within section Introduction.
Spreadsheet Modelling Procedures
Lesson 4 of 5 within section Introduction.
Modifying Worksheets
Lesson 5 of 5 within section Introduction.

Spreadsheet Modelling and Financial Functions

Review of Spreadsheet Functions
Lesson 1 of 5 within section Spreadsheet Modelling and Financial Functions.
Loan Pricing – Efficient Spreadsheets
Lesson 2 of 5 within section Spreadsheet Modelling and Financial Functions.
Interest Schedules
Lesson 3 of 5 within section Spreadsheet Modelling and Financial Functions.
Growth Variables
Lesson 4 of 5 within section Spreadsheet Modelling and Financial Functions.
Depreciation Schedules
Lesson 5 of 5 within section Spreadsheet Modelling and Financial Functions.

Links, Advanced Formulae and Solver

Links
Lesson 1 of 3 within section Links, Advanced Formulae and Solver.
Advanced Formulae
Lesson 2 of 3 within section Links, Advanced Formulae and Solver.
Income Tax Rates
Lesson 3 of 3 within section Links, Advanced Formulae and Solver.

Capital Budgeting and Risk

Capital Budgeting Analysis
Lesson 1 of 2 within section Capital Budgeting and Risk.
Risk Analysis and Optimisation
Lesson 2 of 2 within section Capital Budgeting and Risk.

Interrogation

Budget Formulation
Lesson 1 of 6 within section Interrogation.
Financial Forecasting and Budgeting
Lesson 2 of 6 within section Interrogation.
Financial Data Analysis Functions
Lesson 3 of 6 within section Interrogation.
Descriptive Statistics
Lesson 4 of 6 within section Interrogation.
Regression and Beta
Lesson 5 of 6 within section Interrogation.
Monte Carlo Simulation
Lesson 6 of 6 within section Interrogation.

Databases, Filtering, Pivot Tables

Databases
Lesson 1 of 3 within section Databases, Filtering, Pivot Tables.
Filtering
Lesson 2 of 3 within section Databases, Filtering, Pivot Tables.
Pivot Tables
Lesson 3 of 3 within section Databases, Filtering, Pivot Tables.

Macros and VBA

Macros
Lesson 1 of 2 within section Macros and VBA.
Visual Basic for Applications
Lesson 2 of 2 within section Macros and VBA.

4 thoughts on “Financial Spreadsheet Techniques – Part One”

Leave a Reply

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