TurnĀ Business Data Into Insights.

Start hereĀ ā†’

Grant instant access to learn 30+ impactful Excel chart tips and tricks with all practice files forĀ FREE.Ā You'll alsoĀ receiveĀ emails to discover the Excel Analytics OS Course.

 

SLW #020: SUM+XLOOKUP

weekly newsletter

Two exciting things to announce. First, I've upgraded all students who purchased the Excel Analytics OS pack (with 2 digital products) to a "Lifetime Membership." You'll enjoy my new topics and training in the future (if there are any).

Second, I'll be releasing "Masterclass - Creating Insightful Business Dashboards" to membership students next week! You'll learn how to use only "3 functions", no VBA and PivotTable, to build a business dashboard in just 1.5 hours! I hope you'll enjoy it!

For those who want to join, Click this link to enroll now!

I shared this cool trick about SUM+XLOOKUP on LinkedIn a few days ago, and it received a lot of love from my followers.

Basically, I used the array that XLOOKUP provides and added a SUM function to the mix, creating this handy combo I like to call 'SUM+XLOOKUP.'

Dynamic arrays, my friends, are like the superheroes of spreadsheets. They're changing the game and opening up a whole world of possibilities to simplify our daily work.

I'll be exploring more new combinations involving XLOOKUP and new dynamic array functions. Stay tuned for my upcoming posts!

Go watch SUM+XLOOKUP

That's all for this week.

See you next week. 

-----------------------------------

Whenever you're ready, this is the way I can help you:

  • Digital course: Excel Analytics OS for business professionals

    Excel Analytics OS Course

    Zero risk, 30-day money back guarantee, no questions asked.

I Help You Master Excel for Business Analysis in Just One Course!ā˜€ļø Become a Data-Driven Pro. Start Now!

Get 30+ Charts Power Tips for FREE!

Learn 30+ impactful tips and tricks with all practice files. Power up your Excel Chart skills in 30 mins.Ā You'll alsoĀ receiveĀ emails to discover the Excel Analytics OS Course. Many people love it.