Excel tips

Technology

What to Do When Sparklines Are Disabled

Readers are confused about Excel's Sparklines; explanations and a simple trick make this powerful spreadsheet feature work.
Technology

High Impact Excel: Answers to Three Pivot Table Questions

David Ringstrom shares three of the best Excel-related questions he received during a question-and-answer session after a recent AccountingWEB webinar he conducted, "High Impact Excel: Pivot Table Edition."
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

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

Improving the Integrity of Excel's SUM Function

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

Excel Tip: Determining the Remaining Length of a Loan Using NPER

Learn how to use the NPER function in Excel to determine just how long it will take you to payoff that credit card bill on which you’re making monthly payments..
Technology

Excel Tip: Determining Worksheet Cell Protection at a Glance

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

Creating a Series of Letters in Excel

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

How to Disable Worksheet Animation in Excel 2013

Excel 2013 has arrived, and for the most part, it's much like Excel 2007 and 2010, but with some spiffy new features, such as Recommended Charts and Pivot Tables, Flash Fill, Quick Analysis, Power View, and more.
Technology

Restoring Classic Print Preview in Excel 2010/2013

Excel 2010 introduced a new "Backstage View" where print preview became embedded into the File menu. Excel 2013 continues this tradition, but you can get your "old-school" print preview functionality back with a few quick steps.
Technology

Transposing Data in Excel Worksheets

Excel expert, David Ringstrom, CPA, shows you how you can transform a list of data into a columnar list.

Pages