Microsoft Office Tutorials and References
In Depth Information
Chapter 5: Analyzing Excel Data
Highlight Cells That Meet Some Criteria......................................................................... 124
Highlight the Top or Bottom Values in a Range ............................................................ 126
Analyze Cell Values with Data Bars ................................................................................. 128
Analyze Cell Values with Color Scales............................................................................. 130
Analyze Cell Values with Icon Sets .................................................................................. 132
Create a Custom Conditional Formatting Rule .............................................................. 134
Calculate Multiple Solutions to a Formula ..................................................................... 136
Plug Multiple Input Values into a Formula..................................................................... 138
Calculate the Break-Even Point ........................................................................................ 142
Consolidate Data from Multiple Worksheets ................................................................. 144
Filter Table Data.................................................................................................................. 148
Remove Duplicate Values from a Table.......................................................................... 150
Create an Outline Automatically ...................................................................................... 152
Enable the Analysis ToolPak Add-In ................................................................................ 154
 
Search JabSto ::




Custom Search