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...]
Create a User Defined Function
Excel allows you to create your own "User Defined Functions" (UDF) that can be used the same way as any other built-in function in Excel (i.e. IF, SUM, VLOOKUP, etc.). With a little knowledge of VBA code, you can create your own function to do pretty much whatever you want. To illustrate how to create a UDF, we'll create a function that calculates fuel consumption in miles … [Read more...]