Select Page

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 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...

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 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...

Excel Video 344 Data Tables Tips and Tricks

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...