
Arrays Part 1 Playlist
Excel Video 345 Introducing Arrays
Arrays can make you a real Excel power user. Watch Excel Video 345 to get started. An array is simply a...
Excel Video 346 Multi-Cell Array Formulas
We’ve created an array formula in one cell. Excel Video 346 shows to create an array formula in multiple...
Excel Video 347 Deleting, Moving, and Expanding Array Formulas
Excel Video 347 offers several tips to manage your array formulas. It’s easy to delete or move an entire...
Excel Video 348 Constants in Array Formulas
Watch Excel Video 348 to see how to enter constants in array formulas. Constants are numbers, like 6 or 10,...
Excel Video 349 Using Constants in an Array Formula
Excel Video 349 has a practical example of using constants in an array formula. The example is a weighted...
Excel Video 350 Naming an Array
Today we’ll simplify the formula we created in Excel Video 349 by naming an array in Excel Video 350. If...
Excel Video 351 Changing Named Array Constants
If you need to make the named array constants we created in Excel Video 350 a little more flexible, watch...
Excel Video 352 Transposing Arrays
If you have a horizontal array and need to use it with a vertical range, Excel Video 352 can make your life...
Excel Video 353 Using Arrays to Copy Data
Excel Video 353 has our first trick with arrays. I’ll show you a quick way to get the name of range of...
Excel Video 354 SUM and IF in an Array
Excel Video 354 has a practical example of an array formula. We’ll write a formula that loops through a...
Excel Video 355 SUM and Multiple IFs in an Array
I hope you don’t have to spend a ton of time rewinding Excel Video 355. The array formula to sum multiple...
Excel Video 356 SUM with OR Criteria in an Array
Excel Video 356 offers one more complicated formula, but once that formula works, it’s very powerful. ...
Excel Video 357 LEN in an Array
As promised, there’s an easier array example in Excel Video 357 today. In today’s example we’ll assume...