Building complex spreadsheets without lookup formulas, such as VLOOKUP, is akin to putting a screw in the wall with a hammer. It’s possible, but the results aren’t pretty, and most probably won’t maintain integrity.
Although the IRS is still madly preparing for the 2013 filing season, one man remains ahead of the curve. Glenn Reeves has released his seventeenth spreadsheet-based version of the US Individual Income Tax Return, commonly known as Form 1040, which taxpayers can download and use for free.
It’s a new year, which brings the promise of fresh starts, and resolutions to work smarter. Keyboard shortcuts are one of the best ways to both save time and reduce wear and tear on your wrists when working in Microsoft Excel.
What do accountants count on most to do their jobs well? Yes, coffee is a good answer. No, I'm not thinking of booze. If you eliminate any and all kinds of medicating, the smart money is on Microsoft Excel.
From time to time, you may need to reinstall Microsoft Office because you purchased a new computer or you're trying to resolve a program error. Or, in Excel 2010 and later, you may need to move between the 32-bit and 64-bit versions.
It's pretty much impossible to use Excel and not notice the Name Box. Most users know this as the space in Excel where you can determine the address of the currently selected cell. A smaller subset of users relies on the Name Box as a navigation aid.
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.