These advanced functions offer solutions to common dynamic array issues.

Neale Blackwood

• Recorded
• Duration: 75 Minutes
• US$150.00
• Enroll

Learn how to combine tables with a single function.

Neale Blackwood

• Recorded
• Duration: 60 Minutes
• US$150.00
• Enroll

See how to build a flexible loan schedule.

Neale Blackwood

• Recorded
• Duration: 60 Minutes
• US$150.00
• Enroll

Dynamic arrays are a game changer when it comes to creating spreadsheets.

Neale Blackwood

• Recorded
• Duration: 60 Minutes
• US$150.00
• Enroll

This session covers recent developments in Excel that allow you to create custom functions without VBA (macros). You will need the subscription version of Excel to follow along with this session.

Neale Blackwood

• Recorded
• Duration: 90 Minutes
• US$150.00
• Enroll

Learn the basics, plus some powerful techniques to make your range names more dynamic. This session has everything you need to get started with using range names effectively.

Neale Blackwood

• Recorded
• Duration: 60 Minutes
• US$150.00
• Enroll

This session will show you how to achieve improved charts and how to create charts that aren't built-in to Excel.

Neale Blackwood

• Recorded
• Duration: 75 Minutes
• US$150.00
• Enroll

Recorded macros can't interact with the user.

Neale Blackwood

• Recorded
• Duration: 90 Minutes
• US$150.00
• Enroll

Recorded macros have many limitations. Almost all those limitations can be removed by editing the recorded macros and adding programming code.

Neale Blackwood

• Recorded
• Duration: 90 Minutes
• US$150.00
• Enroll

This session will examine and explain 5 different loan schedules.

Neale Blackwood

• Recorded
• Duration: 60 Minutes
• US$150.00
• Enroll

This session examines how you can create a combined Profit & Loss, Balance Sheet and a Cash Flow budget.

Neale Blackwood

• Recorded
• Duration: 75 Minutes
• US$150.00
• Enroll

Learn how to convert a budget into a multiple scenario budget.

Neale Blackwood

• Recorded
• Duration: 60 Minutes
• US$150.00
• Enroll

Discover how to use Power Query to solve two major issues in multi-file budget systems.

Neale Blackwood

• Recorded
• Duration: 60 Minutes
• US$150.00
• Enroll

Excel is the main application used to create budgets for small to medium organizations.

Neale Blackwood

• Recorded
• Duration: 60 Minutes
• US$150.00
• Enroll