by Nate Moore | Apr 17, 2013 | Arrays
Excel Video 349 has a practical example of using constants in an array formula. The example is a weighted average of the past 5 years of revenues. Notice how much space on the Excel spreadsheet it takes to do the weighted average compared to what can be done in one...
by Nate Moore | Apr 15, 2013 | Arrays
Watch Excel Video 348 to see how to enter constants in array formulas. Constants are numbers, like 6 or 10, as opposed to cell references, like A4, that we’ve used so far. I’ll say this in the video, but there are much, much easier ways to fill a range of cells with...
by Nate Moore | Apr 10, 2013 | Arrays
Excel Video 347 offers several tips to manage your array formulas. It’s easy to delete or move an entire array formula, but you can’t delete or move part of an array formula. It’s all or nothing. You can expand an array formula to include more cells, but you can’t...
by Nate Moore | Apr 8, 2013 | Arrays
We’ve created an array formula in one cell. Excel Video 346 shows to create an array formula in multiple cells at the same time. It’s easy to create an array formula in multiple cells. Select the cells that you want to populate with the formula, enter the formula that...
by Nate Moore | Apr 3, 2013 | Arrays
Arrays can make you a real Excel power user. Watch Excel Video 345 to get started. An array is simply a collection of things, and an array formula can make multiple calculations at once on the contents of an array. The important thing to take away from this Excel...