Author Archives: Tepring Crocker

How to Use Slicers in Excel 2010 and 2013

Excel’s Slicer Filter was added in Excel 2010 and enhanced in Excel 2013. This useful feature is excellent for viewing and comparing varied combinations of your data with a simple click. Something like a cross between a button and a filter, Slicers have become a prized tool for analyzing large data sets in dashboards and…
Read More

How to Show Percentage of Total in an Excel PivotTable

Once you learn how to create an Excel PivotTable, you’ll discover that organizing your information is only the first step in getting the most out of this useful feature. PivotTables then give you the ability to further manipulate the organized information. Value Field Settings let you perform different types of summarizations. Calculated Fields and Calculated…
Read More

Grouping Excel PivotTable Data by Month

PivotTables have some useful “hidden” features that can make interpreting your data even easier. One such feature allows you to view data by date groupings (such as month, quarter, even week and hour of day). By grouping within the PivotTable itself, you avoid constantly changing your source data and creating multiple PivotTables from the same…
Read More

Categories

Monthly Archives