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 offers several tips to manage your array formulas. It’s easy to delete or move an entire...

Watch Excel Video 348 to see how to enter constants in array formulas. Constants are numbers, like 6 or 10,...

Excel Video 349 has a practical example of using constants in an array formula. The example is a weighted...

Today we’ll simplify the formula we created in Excel Video 349 by naming an array in Excel Video 350. If...

If you need to make the named array constants we created in Excel Video 350 a little more flexible, watch...

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 has our first trick with arrays. I’ll show you a quick way to get the name of range of...

Excel Video 354 has a practical example of an array formula. We’ll write a formula that loops through a...

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 offers one more complicated formula, but once that formula works, it’s very powerful. ...

As promised, there’s an easier array example in Excel Video 357 today. In today’s example we’ll assume...

Excel Video 358 has another way arrays might make your life easier. I have five clinical measures that...