How To Use Slicers To Edit PivotTable Data in Microsoft Excel Tutorial

March 16, 2012 | Kyle Fordrung

Slicers are visual controls that let you quickly filter data in a PivotTable in an interactive, intuitive way. If you insert a slicer, you can use buttons to quickly segment and filter the data to display just what you need.

Read More

12 Time-Saving Tips in Microsoft Excel 2010

March 2, 2012 | Kyle Fordrung

Excel 2010 – 12 Time Saving Tips

1. Add content or formatting to multiple sheets at once

You can add content or apply formatting to two or more of the sheets on a multisheet worksheet by “grouping” the sheets together. When you group multiple sheets, any content or formatting that you add to one sheet also gets added to all the other sheets, so you can add a row of headers to one sheet and have it automatically appear on all the sheets that are grouped together with it.

Read More