Tag: Excel
Pin Frequently Used Documents and Save Time in Office 2007
I have a set of documents that I frequently use in Excel and Word. Most of the time I can find them using the...
Sneak Peek: Access, Excel, PowerPoint, and Word 2010
Like I stated in my previous post, I was able to get a copy of Office 2010 and have been playing with...
How to Enable the Data Analysis ToolPak in Excel
Excel like many of Microsoft's other Office applications are extremely powerful tools that have many 'hidden' features. I stumbled on the Analysis ToolPak when...
How to Add A Second Axis to Your Charts in Excel
When using Excel and working with two data sets that differ greatly in range it can be difficult to chart those values due to...
How to Use Autofilters to Sort Data in Excel
Most of the time I work with a lot of data and I've found that the most effective and simple way of sorting...
Create Hierarchical Maps Like Those Used in ‘Smartmoney’s Map of the Market’
This Excel Add-in allows you to create treemaps which can be used to visually represented for easier interpretation, think of it like a multiple-level...
Keep Your Microsoft Office Data Private
Most computer users are not aware that files created from the Microsoft Office Suite (Word/Excel/PowerPoint) may contain hidden information that you may want...