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...
by Nate Moore | Dec 16, 2013 | Tables
Excel Video 392 has one more clever advanced filtering trick for 2013. This is the last Excel Video I’ll publish for 2013, so let me pause for a moment and thank each of you for watching and for publicizing the videos. I’ve had well over half a million videos watched...
by Nate Moore | Dec 9, 2013 | Tables
In Excel Video 391 we’ll filter dates and then make the filter more powerful by adding the same field twice to our filtering criteria. First, the easy part. It’s easy to filter by date. You don’t need any of the funny text syntax we’ve talked about in previous Excel...
by Nate Moore | Dec 2, 2013 | Tables
Excel Video 390 will make our advanced filtering more powerful with wildcards. We’ll discuss two different wildcards, an asterisk (*) and a question mark (?). The asterisk filters any number of any character. In the video a* will filter for any patient whose last name...
