From the course: Excel Data Visualization: Designing Custom Visualizations

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Visualizing percentages with arrays

Visualizing percentages with arrays - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Designing Custom Visualizations

Start my 1-month free trial Buy for my team

Visualizing percentages with arrays

“

- [Instructor] So one of the more powerful tools in Excel that is typically misunderstood is the array function. And the reason it's so misunderstood and so mysterious is that it operates in a way that's different from any other cell formula or function in Excel. So because of that, they can be very tough to learn and very tough to master, but once you do get a grasp of how array functions actually work, they can be an incredibly powerful tool. I'm going to show you an example of how they can also be used in the context of building data visualizations in Excel. So on the array percentage grid tab, we've got a user-defined value in B2 where you can just type in any particular percentage, and then we have four columns with array functions in columns G through J. Now rather than writing these out from scratch and really not doing them justice, I figured I'd put them in here now so that you can dig in as much or as little as you choose to kind of decode what these functions are actually…

Contents