by Nate Moore | Mar 31, 2010 | Conditional Formatting
Excel Video 45 starts at the top of the Conditional Formatting menu with the Highlight Cells Rules. Highlight Cells Rules do exactly that, they highlight or conditionally format cells that meet certain criteria. Excel Video 45 shows several examples, both with numbers...
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...
