Skip to content

Home
Courses
Your Progress
- Courses and Progress
- Assessment Test Reports
About
- Information
  - Why Take the CertFM?
  - Recent Posts
- Customer Support

Username or Email Address

Password

Remember Me

Username or Email Address

Password

Remember Me

Home
I.d Excel Functions and Applications (II)

I.d Excel Functions and Applications (II)

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

Course Content

Expand All

Array Calculations and Dynamic Output Arrays

Chapter 1: Array Calculations and Bespoke Array Functions 10 Topics

Expand

Chapter Content

0% Complete 0/10 Steps

1.1 Introduction

1.1c Introduction -genal array uses withour trl shft enter e.g. sumproduct REWREITE as not used yet

1.1b Introduction to Bespoke Array Calculations

1.2 Counting Cell Types Using Array Functions to overcome countblank error

1.3 Worked Example I – sun of items for non blank – done in course 1

1.4 Montenegero TBBC count of text fields or of non-blank

1.5 Replication of MAXIF or MINIF

1.5c bepokse array – mn calculations +minif before

1.x SUM(ABS())…from triangel to scuplt average depreciation +perhaps Solver as GS can be used

1.x count(if<0...) using example frmo Jean frmo 03.02.22 for time ordering

Chapter 2: Dynamic Output Ranges 5 Topics

Expand

Chapter Content

0% Complete 0/5 Steps

2.1 Introduction

2.2 Example (I): The UNIQUE Function

2.3 Using Dynamic Outputs as Inputs to Other Functions

2.4 Example (II): The TRANSPOSE Function

2.5 Introduction to Dynamic Input Ranges

Introduction to Lookup Functions

Chapter 3: Overview of Common Applications: Scenario Analysis, Breakeven Modelling, and Data Integration 6 Topics

Expand

Chapter Content

0% Complete 0/6 Steps

3.1 Introduction to Lookup and Reference Functions TBC

3.2 Introduction to Scenario Analysis

3.3 Principles of Scenario Analysis and Its Implementation

3.4 Scenario Identification and Definition

3.5 Introduction to Payback Periods TBC

3.6 Data Integration

Chapter 4: MATCH and XMATCH 6 Topics

Expand

Chapter Content

0% Complete 0/6 Steps

4.1 Introduction to MATCH and XMATCH

4.2 Files for Work Along and Exercises

4.3 Example: The MATCH Function and Its Paramters

4.4 Exercise for Self-Working: Sensitivity Analysis of Breakeven Times

4.5 Example: The XMATCH Function and Its Parameters

4.6 Dealing with Errors and Other Best Practices

Chapter 5: CHOOSE and SWITCH 6 Topics

Expand

Chapter Content

0% Complete 0/6 Steps

5.1 Scenario Data Selection Using CHOOSE

5.2 Files for Work Along and Exercises

5.3 Alternatives to Link Scenario Data into the Main Model

5.4 Using Data Validation to Restrict Scenario Selection

5.5 Scenario Data Selection Using SWITCH

5.6 Exercise: Running Scenarios

Chapter 6: INDEX and LOOKUPs 10 Topics | 1 Assessment Test

Expand

Chapter Content

0% Complete 0/10 Steps

6.1 Search and Reference Processes

6.2 Introduction to the INDEX Function

6.3 Files for Work Along and Exercises

6.4 Example: Using INDEX

6.5 Benefits of One-dimensional Arrays

6.6 Combining INDEX with MATCH or XMATCH

6.7 Using Separate or Embedded Cells for Linked Processes

6.8 Introduction to XLOOKUP and Embedded Combinations

6.9 The Treatment of Input Types

6.10 Using Other Combined Processes: LOOKUP, HLOOKUP, VLOOKUP and Best Practice Issues

Assessment Test 2.a.1 Arrays, Dynamic Ranges, Paybacks, Lookups and Scenarios

Further Function-Based Calculations and Structures

Chapter 7: Further Common Calculations and Structures 6 Topics

Expand

Chapter Content

0% Complete 0/6 Steps

7.1 Introduction

7.x Flags in Time Series Models

7.2 Scenario Decks for Time Series Models

7.3 Scenario-Driven Variance Analysis

7.4 Triangles with Lookups

7.5 Integrating od Data Sets and Creating Flat Tables – XRate Example

Home
Courses
About
- Information
- Customer Support
  - Privacy Policy
  - Contact Us
Your Profile

Home
Courses
About
- Information
- Customer Support
  - Privacy Policy
  - Contact Us
Your Profile

Copyright © 2023 Certificate in Financial Modelling | Web Design

Start typing and press enter to search

Search …

This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteXAccept View Policy

Scroll to Top

error: Alert: Content is protected !!

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?