From the course: Excel Data Visualization: Designing Custom Visualizations
Unlock this course with a free trial
Join today to access over 23,100 courses taught by industry experts.
Visualizing percentages with arrays - Microsoft Excel Tutorial
From the course: Excel Data Visualization: Designing Custom Visualizations
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Setting expectations1m 8s
-
(Locked)
Image overlay chart6m 1s
-
Binary ranges5m 2s
-
(Locked)
Automation with OFFSET and COUNTA7m 8s
-
(Locked)
Interactivity with form controls12m 30s
-
(Locked)
Animating changes over time14m 3s
-
(Locked)
Building a dynamic dashboard, part 116m 10s
-
(Locked)
Building a dynamic dashboard, part 212m 8s
-
(Locked)
Value-based formatting10m 10s
-
(Locked)
Dynamic series selection10m 26s
-
Custom pacing chart10m 23s
-
(Locked)
Custom gauge chart9m 58s
-
(Locked)
Visualizing percentages with arrays7m 16s
-
(Locked)
-