Microsoft Office Tutorials and References
In Depth Information
Tips and Where to Find Them
Tips and Where to Find Them
Tip 158
Using the Table Feature . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 335
Tip 159
Working with Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 338
Tip 160
Using Formulas with a Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 341
Tip 161
Numbering Rows in a Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345
Tip 162
Using Custom Views with Filtering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 347
Tip 163
Putting Advanced Filter Results on a Different Sheet . . . . . . . . . . . . . . . . 349
Tip 164
Comparing Two Ranges by Using Conditional Formatting . . . . . . . . . . . 350
Tip 165
Randomizing a List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353
Tip 166
Filling the Gaps in a Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 355
Tip 167
Creating a List from a Summary Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 357
Tip 168
Finding Duplicates by Using Conditional Formatting . . . . . . . . . . . . . . . . 360
Tip 169
Creating a Quick Frequency Tabulation . . . . . . . . . . . . . . . . . . . . . . . . . . . . 362
Tip 170
Controlling References to Cells within a Pivot Table . . . . . . . . . . . . . . . . . 365
Tip 171
Grouping Items by Date in a Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . . . 366
Tip 172
Unlinking a Pivot Table from Its Source . . . . . . . . . . . . . . . . . . . . . . . . . . . . 369
Tip 173
Using Pivot Table Slicers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .371
 
Search JabSto ::




Custom Search