by Nate Moore | Jan 27, 2014 | Tables
Excel Video 396 has two things to know about the total row in Tables. The first thing to know is that the total row respects filters. In other words, the amount shown in the total row takes into account the filters you apply. It’s easy to get the total number of...
by Nate Moore | Jan 20, 2014 | Tables
Excel Video 395 shows you an easy way to put a total row at the bottom of your table. With one click, you can add a total row to the bottom of your table. Even better, Excel will include a drop-down box for you to automatically create formulas in the total row. It’s...
by Nate Moore | Jan 13, 2014 | Tables
We’ll use advanced filtering to start thinking about predictive analytics in Excel Video 394. First we’ll compress the formulas that took four columns in Excel Video 393 to one column in Excel Video 394 by using the OR and AND functions. The formulas look complex, but...
by Nate Moore | Jan 6, 2014 | Tables
Happy New Year everybody! Welcome back to another year of Excel Videos at mooresolutionsinc.com. We’ll start the year with a different approach to advanced filters in a table in Excel Video 393. Instead of putting complex formulas and syntax above the table, we’ll add...
