Overview

See how to build a flexible loan schedule. Learn how to access rows and columns within spill ranges. Discover how formatted tables and dynamic arrays work together to create flexible and auto-updating reports. See how to change lists from rows to columns and vice-versa.

Why you should Attend

Are you still manually copying formulas as ranges extend? See how to make your formulas and reports dynamic using functions that expand automatically. 

See how formatted tables and dynamic arrays seamlessly work together to make ranges dynamic. 

Want to change a row-based list to a column-based list? Now it is easy. 

Areas Covered in the Session

• New dynamic array functions explained and demonstrated
  
• SEQUENCE, CHOOSECOLS, CHOOSEROWS, TAKE and DROP
  
• Flexible loan schedule and flexible budget example
  
• Formatted tables and dynamic arrays
  
• Old functions that work well with spill ranges
  
• TRANSPOSE and INDEX

Who Will Benefit

• Accountants and Finance Staff