Excel Expert Live Challenge | Celia Alves & The Cupcake Challenge

/in /by

Celia Alves, MVP, Developer and content creator at @CeliaAlvesSolveExcel is the next one to step up for an Excel Experts Live Challenge!

Here, we have cupcake orders and flavors, and need to tally how many of each flavor needs to be made. But, it’s not that easy. There are twists. 😉

Check it out!

Watch how Celia uses color and borders to stay organized. She explores different randomization options, and regularly takes advantage of Dynamic Arrays to write 1 formula to generate multiple results. You’ll also see MATCH nested in CHOOSECOLS inside SUM! 🤯

FANTASTIC WORK!

How would you go about this solution?

#ExcelChallenge
#CeliaAlves
#DynamicArrays

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book co-written with Mr. Excel, Bill Jelen: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
My old blog: http://datascopic.net/blog-2-2