Take a Picture of Excel Data, Charts, Pivot Tables and More

I am a huge fan of TechSmith’s Snagit and highly recommend it to anyone that needs to take screenshots to another level.  But not all of us want to purchase software just to take a screen shot here and there.  One of my favorite features in Office 2010 is the Insert Screenshot tool.  It’s a… Read More Take a Picture of Excel Data, Charts, Pivot Tables and More

How to apply banded rows in Excel without converting to a table

Excel 2010’s Table feature provides many different Table Styles including options for banded rows and customization.  What if you want to format your data with banded rows without having to convert it to a Table?  You can do this with Conditional Formatting. What’s a banded row?  It’s when every other row has a different shaded… Read More How to apply banded rows in Excel without converting to a table