If you’ve ever tried to break an external link in Excel without success, this is for you. External links are sometimes created when copying a worksheet to another file or a new workbook. If the Edit Links button on the Data ribbon doesn’t allow you to delete the external reference the following steps will show… Read More Force a Break to an External Link in Excel
I cannot say enough good things about Excel 2013’s new charting features. Thank you Microsoft for finally giving us some new options! One of the many new features in Excel charting is the Data Callout Label. In previous versions of Excel, one could easily add a data label to their chart, but these labels were… Read More Add a Data Callout Label to Charts in Excel 2013
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
I thought this was worth sharing.
Wouldn’t it be great to get quick access to all of your Windows 8 settings in one place? Think of the time you would save, not to mention the frustration you would avoid by not having to search for each individual setting. GodMode is not a plug-in, it is a hidden shortcut that is available… Read More Put Windows 8 in “GodMode” for Easy Access to All Settings in One Place
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
Office 2010 Quick Access Toolbar Tip – Add a Group of Commands at Once If you haven’t already figured out that the QAT (Quick Access Toolbar) in Office is a true time saver, you’re missing out. The QAT is designed to make commands more easily accessible without having to navigate from tab to tab to… Read More Group commands and free up some QAT real estate!