IF Commands, Conditional SUMS, and Formatting
Formatting
- Two types of Conditional Formatting
- True / False Statement in Formatting
- Formatting of non-numeric expressions
- Format a grid and highlight both duplicates and/or non-duplicates
- Set up a “checkerboard” pattern in an Excel file plus other colorful and interesting patterns. Also Format alternative coloring rows in your Excel files.
- Highlight positive and/or negative change in two columns
- Many other interesting & Useful Formatting tips / tricks
Conditional Sums
- Conditional Sum Function
- Conditional Sum prompt screen and how to construct Conditional Sums for “scratch”
- Learn when best to use conditional sum Functions and when best to use Pivot Table Functions
IF Commands
- Simple Commands
- Complex (Bundled) Commands
- Conditional Commands
May 17th, 2008
| Coming Soon |
Instructors
Coming Soon
Excel 2007
This session will have 2 large screens:
1 for Microsoft 2003
1 for Microsoft 2007