Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.
Conditional formats help you make judgments about your data quickly, but you might find that one or more of the rules you created that are no longer useful. If that's the case you can delete rules individually from the Conditional Formatting Rules Manager or get rid of them all by using the controls on the Home tab of the Ribbon. If you want to delete a single rule then on the hometown of the Ribbon click Conditional Formatting and then click Manage Rules. Then in the Conditional Formatting Rules Manager dialog box you can select the rule that you want to delete.
So for example if we wanted to delete the rule that identifies the top seven values then I could click it and then click Delete Rule. You should always verify that any remaining rules operate the way you want them to. For example, if the rule you got rid of, how to Stop If True condition, you might have disrupted the rules logic and cause Excel to apply rules it shouldn't. When you are done managing the rules inside this dialog box you can click OK to save your changes or Cancel if you want to close the dialog box without saving your changes.
If you want to remove a particular set of conditional formats then you can do so by once again on the Home tab clicking Conditional Formatting and then pointing to Clear Rules and when you do a number of choices come up. Clearing rules from just the selected cells works as advertised. It removes conditional formats from just those cells that you've selected. Clearing rules from the entire sheet removes all conditional formats in the worksheet, not just the PivotTable. When the active cell lies within an Excel table then clearing rules from this table option deletes conditional formats from that Excel table.
In this case the active cell isn't within an Excel table so that option is grayed out here. Finally, clearing rules from this PivotTable removes rules from the PivotTable, but doesn't affect any rules elsewhere on the worksheet. So for example if I were to click Clear Rules from this PivotTable, then Excel would remove those rules but wouldn't affect anything else within the worksheet if other rules were applied. Getting rid of conditional formats you no longer need reduces the visual input you have to process when you view a PivotTable. If you find the conditional format is more of a distraction than help, don't hesitate to get rid of it.
There are currently no FAQs about Excel 2010: Pivot Tables in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.