Microsoft Excel is jam packed with cool useful features that tend to go unused by most users, simply because they don't know how to use them, or even that they exist. One of these features is Excel's Goal Seek tool. First, some background on what it does. Goal Seek is essentially the answer to every middle school aged kid's math test word problem. It is best used when you … [Read more...]
Use Excel As A Calculator
OK, I know the tag-line for this website is "...because it's more than just a calculator". Of course this is in reference to the almost endless number of functions that Excel can calculate when compared to a standard calculator. That isn't to say though that Excel can't calculate things just as well as a standard calculator. For example, when balancing a checkbook, you … [Read more...]
Microsoft Office 2010
For all of you out there still wondering where the "File" menu is in Excel 2007 and other Office 2007 products, another twist is in store for you. Microsoft announced earlier this week that they are planning on releasing Office 2010, which includes updates to Word, Excel, PowerPoint, Outlook, OneNote, Publisher, Access, SharePoint Workspace (formerly Groove 2007), and … [Read more...]
Dynamic Chart Labels
Using charts in Excel can be a very powerful tool when used correctly. They can help to quickly visualize trends, and analyze results. The charts, however are useless if the person who is looking at them can't tell what the data is that they are trying to analyze. Excel helps the user by inserting labels in key points to help the user identify what they are looking at. If … [Read more...]
How to Use Paste Special in Excel
Being able to copy and paste a cell's information from one location to another is a great time saving feature, but sometimes you don't need to copy everything from the source cell. Thankfully, Microsoft Excel will allow you to copy a cell and paste only selected information if you wish. The menu below is a screenshot of the Paste Special menu from Excel 2007, which, except … [Read more...]