Excel

Technology

Excel: The Indispensable NCAA Bracket Tool

Sports enthusiasts should know that Excel isn't just for accountants: it's for anyone running a Final Four betting pool.
Technology

How to Improve Spreadsheet Integrity with VLOOKUP

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

Spreadsheet-Based Form 1040 Available at No Cost for 2013 Tax Year

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

Resolve to Learn and Use 14 Excel Keyboard Shortcuts in 2014

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

AccountingWEB's Top Five Excel Tips From 2013

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

The Curious Case of Strikethrough in Word and Excel

Excel expert David Ringstrom, CPA, describes a couple of ways that you can streamline access to the strikethrough feature – and pretty much any feature – in both Word and Excel.
Technology

Conditionally Displaying Decimal Places in Excel: Part 2

Excel expert David Ringstrom, CPA, describes how to use Excel's Conditional Formatting feature to handle just about every imaginable situation.
Technology

Conditionally Displaying Decimal Places in Excel: Part 1

In Part 1 of his two-part series, Excel expert David Ringstrom describes how to add decimal places on demand by way of using a custom number format.
Technology

How to Reinstall Microsoft Office When You Don't Have a Disc or Download

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

Twenty-Five Ways to Use Excel's Name Box

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

What To Do When Excel Worksheet Tabs Go Missing

In addition to restoring vanished worksheet tabs, David Ringstrom also describes a couple of techniques for navigating workbooks easier, as well as other ways to find hidden worksheets.
Technology

Creating a "Chainsaw" List of Excel Worksheet Functions

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

Identifying Duplicate Values in an Excel List, Part 2

Once you've identified duplicate values in an Excel list, this technique will show you how to change the format of the second and any subsequent instances of the duplicate value.
Technology

Speed Up Microsoft Excel's Help Window

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

How to Maximize Excel's Recent Items Menu

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

Worlds Colliding: Convert a Digital Photo into an Excel Spreadsheet

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

Microsoft Excel: How to Automate Text File Links

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

Eliminate a Common Spreadsheet Design Flaw

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

Three Ways to Convert Text-Based Numbers to Values

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

Automating Data Validation Lists in Excel

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.

Pages


Already a member? log in here.