Home Tags Excel

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...
Add Second Axis to Excel Chart

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...