Depending on your version of Excel, you have nearly 500 different worksheet functions at your disposal. Some worksheets functions are like the chainsaw in my garage. I don't use them very often, but when I do, no other tool will suffice.
When you access Microsoft Excel's help window, the content is typically derived from a remote server on the Internet, which can cause a delay while the help window loads. David Ringstrom explains how you can eliminate this annoying wait that can break your stride.
Depending upon your version of Excel, the Recent list on the File menu can streamline access to both files and folders. If you work on numerous spreadsheets, this list offers marginal value in Excel 2003 and earlier.
In an unlikely mash-up, Matt Parker of Think Maths offers a free tool that converts a digital photo of your choice into an Excel spreadsheet. If you have Excel 2007 or later, you can try the technique yourself.
Some time ago, I explained how to use Excel's Text to Columns Wizard for separating text within a spreadsheet into columns. Although this approach is helpful for data that's in a spreadsheet, in other cases, you may wish to link spreadsheets to text files that change periodically.
Whenever column headings within a worksheet span two or more rows, a cascade of issues can occur. Fortunately, a simple technique can help you avoid frustration and save time when working in Microsoft Excel.
Periodically, you may encounter numbers in Excel that you can't sum or use arithmetically. A common cause for this is numbers formatted as text. David Ringstrom describes three ways you can convert numbers that appear trapped under glass into a usable format.
Working in an Excel spreadsheet can be somewhat like the Wild West – unless other provisions are made, users can enter any value in any cell. One way you can restrict users to a predefined set of values is by way of Excel's Data Validation feature.
My unscientific observation is that the SUM function is the most widely used function within Excel spreadsheets. This function makes it easy to add up multiple cells at once without laboriously adding multiple cells together individually.
It's a frustrating experience when a simple Excel spreadsheet displays #VALUE! in a worksheet cell rather than the expected result. Many times the problem is obvious, but sometimes the culprit is harder to track down.
Many users rely on the Subtotal feature in Excel to instantly insert totals, averages, counts, or other statistics into a list. As you'll see, the feature is easy to use – until you want to copy or format just the total rows.
IBM recently announced that Lotus 1-2-3 will no longer be available for purchase. Most readers of this article will likely have one of two reactions: "What is Lotus 1-2-3?" or "Lotus 1-2-3 was still on the market?"
It's frustrating when Excel acts as if the active area of a worksheet is significantly larger than the actual area where you have data. Suddenly your scroll bars move you into uncharted areas, such as column TX or row 5,000.
You can't easily tell at a glance if a cell is locked or not, but Excel expert David Ringstrom shows you how to add a visual aid. As an added bonus, the technique also makes it far easier to lock and unlock worksheet cells.
By its very nature as a spreadsheet, it's easy to create a series of numbers in Excel. But most users don't realize that you can configure Excel to create a series of letters in a similar fashion. Excel expert David Ringstrom explains how.
Cary Walkin, a CA and video game enthusiast in Canada, found a novel way of using Excel for something other than number crunching. Walkin, who is also an MBA candidate at the Schulich School of Business, created a video game using nothing but Excel.
Spreadsheet users frequently insert rows and columns into spreadsheets, but for most users, it's a multiple-step process. Excel expert David Ringstrom explains how you can create your own custom shortcut to insert rows or columns with a single keyboard shortcut or mouse click.
It's every spreadsheet user's worst nightmare – you've worked on a workbook for a period of time, and then accidentally close it without saving. Or the power goes out, or Excel crashes . . . the list of spreadsheet hazards goes on and on.