Recently Added / Updated Articles & Lessons

Module Twenty-Five - The LET Function for More Complex Array Calculations (Login reuired) 

In this module, the lookup functions are introduced, and their usage demonstrated. The use of lookup functions is compared and contrasted to reference functions.

Module Twenty-Four - Dynamic Array Formulas for Analysis and Tabulation (Login reuired) 

This module introduces the use of dynamic array formulas for building analytical reports, including tabulating summaries and building cross-tabulations.

T01 - Function and Formula Fundamentals (Login reuired) 

This module of the Key Topic Lecture Series introduces important fundamental information about working with functions and formulas in Excel. It introduces and demonstrates the use of key formula entry and effective ways to simplify and streamline conditional expressions. It introduces the use of key functions for deriving values in models and analyses.

Module Four - Consolidating Multiple Worksheets (Login reuired) 

In this module, we will complete the model commenced in the previous task. It demonstrates a technique for working with consolidation of workbooks with multiple sheets all sharing a common layout. It reinforces the learnings from the previous module about pointing techniques when building formulas.

Module Five - Range Addresses and Reference Absoluteness (Login reuired) 

In this module we will discuss and explore the issues around address modes and the use of absolute, row-absolute, column-absolute, and relative addresses.

Module Six - Understanding and Working with Value Types (Login reuired) 

In this module we examine the different value types supported by Excel, and how values implicitly coerced or explicitly converted between value types. We discuss when coercion of type will occur due to the way an expression is built.

Full List of Recent Changes