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...
by Nate Moore | Apr 1, 2013 | Uncategorized
Excel Video 344 has three things you should know about Data Tables. The first tip is that the values in a Data Table can’t be manually changed. You can’t delete individual values either. The only way to get rid of values in a Data Table is to select all of the values...
