Excel has changed in recent years, and this video is all about helping you step confidently into the world of modern Excel. We’ll explore a set of new, powerful formulae that behave very differently from the traditional functions many people still rely on.

These modern functions are designed to be simpler, clearer, and far more intuitive — perfect for anyone starting their Excel journey today.

A key part of this lesson is understanding dynamic arrays, one of the most exciting updates Excel has ever introduced. Instead of copying formulas down a column, you write a single formula and let Excel “spill” the results automatically.

We’ll also look at the strength of Excel Tables, which turn your data into a structured, responsive foundation for everything else you do. Tables make formulas more reliable, formatting more consistent, and your entire workflow more flexible.

You can download the exact Excel file I’m using via the link below and follow along step‑by‑step.

This is modern Excel — clearer, calmer, and designed to help you work with confidence.

WATCH THE VIDEO HERE

DOWNLOAD FILE LINK HERE

DOWNLOAD THE EXCEL SUCCESS CHEATSHEET HERE

(your email will be added to our marketing email list from which you can unsubscribe anytime)

PLAYLIST: YEAR OF YOUR EXCEL SUCCESS

ABOUT THE YEAR OF YOUR EXCEL SUCCESS

The Year Of Your Excel Success is a unique, free set of resources comprising videos, Excel files, PDFs and live sessions, released here on YouTube over 12 months to help you transform your career through better Excel skills.

The Year Of Your Excel Success Playlist includes:

✅ an invitation to consider your 'why' - what's your story and why do you want to get better at Excel?

✅ a unique general framework ('The Four Excel Personalities') for tackling Excel problems

✅recorded videos on specific Excel topics supported by Excel download files and PDFs, with 'workalong' demonstrations based on real-world examples

✅non-technical videos offering practical advice and insight on advancing your career with better Excel skills, from somebody who has done it

✅live sessions where viewers 'check in' and share progress and problems on The Year Of Your Excel Success

You are encouraged to interact with Chris and other viewers on the journey to their Excel Success in the comments!

JOIN THE EMAIL LIST HERE

Join the email list by getting our free Excel Success Cheatsheet

(your email will be added to our marketing email list from which you can unsubscribe anytime)

 ABOUT TIGER SPREADSHEET SOLUTIONS

Founded in 2009 by Chris Mortimer, Tiger Spreadsheet Solutions helps organisations across the world save thousands of hours of time and millions of dollars of money by auditing, organising and automating spreadsheet processes

CONSULTING ENQUIRIES