by Nate Moore | Mar 29, 2010 | Conditional Formatting
Welcome to the next set of Excel Videos. We’ve covered Pivot Tables and Tables in Excel 2007 in depth. Excel Video 44 begins a new series on Conditional Formatting. Conditional Formatting is an Excel tool that allows you to set up a variety of rules or criteria for a...
by Nate Moore | Mar 24, 2010 | Tables
Excel Video 43 simplifies the way Excel references cells inside a table in formulas. When you look at the table reference in a formula it looks hairy, but if you simply arrow over (or click on) the table cell you want to reference, Excel does all of the syntax for...
by Nate Moore | Mar 22, 2010 | Tables
Excel Video 42 demonstrates the three options in the Tools section of the Table Tools Design tab, in the Tools area. First, there’s an easy way to convert the table you’ve been working on to a Pivot Table. Even if you’ve filtered the data in the table, Excel brings...
by Nate Moore | Mar 17, 2010 | Tables
Excel Video 41 is another short, straight-forward video, this time on table style options. Table style options is a section of six check boxes in the Table Tools Design tab that let you control how your table is formatted. Even better, the options carry over to the...
by Nate Moore | Mar 15, 2010 | Tables
Excel Video 40 is a short, simple presentation on table styles in Excel 2007. There are a variety of easy to use pre-formatted styles you can apply to your table to make it look much more professional and make it easier to read at the same time. Best of all, it...