Excel tips

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.
1365
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..
1715
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.
1676
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.
2492
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.
5540
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.
5818
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.
7420
Technology

Excel Tip: Calculating Interest

In his latest article in our Excel Tips series, expert David Ringstrom explains how to calculate interest within a single worksheet cell.
12973
Technology

Managing Excel Add-ins

In his latest article in our Excel Tips series, expert David Ringstrom explains how to manage Excel add-ins, including all the toolbars, ribbons, and headaches that come with them.
6196
Technology

Is This Excel Worksheet Protected?

David Ringstrom's latest Excel tip will show you how to make sure your worksheets are protected.
6087
Technology

Using Clip Art in Excel Charts

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
4769
Technology

Automating Excel Chart Titles

In this, his latest article in our Excel Tips series, expert David Ringstrom shows you how you can further automate your chart with a self-updating title.
13992
Technology

Automate Excel Charts in Two Keystrokes

David Ringstrom shows you the typical way most users add data to a chart. He then shares a simple technique that eliminates this mundane need.
8211
Technology

Excel Tip: Calculating Straight-Line Depreciation

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
5774
Technology

Excel Tip: Automatic Backup of Key Excel Workbooks

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
6307
Technology

Excel Tip: Data Entry Shortcut

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
2984
Technology

Excel Tip: Pasting Text into Excel 2010

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
5925
Technology

Excel Tip: Using Today() versus NOW()

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
3300
Technology

Excel Tip: Text Centering Trick

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
2816
Technology

Excel Tip: Text Boxes

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
1356

Pages

Voice of the Editor

Results from a recent AICPA survey disclosed the two top priorities for CPA firms as they plan for the future: bringing in new business and finding talent. Our goal at Sift Media is to help our readers deal with the issues most important to them. One way in which we are doing this is through the launch of our new recruitment/placement service, Going Concern Jobs. Check it out today for your talent needs.
Read more
Gail Perry, CPA
Publisher/Editor-in-Chief, AccountingWEB
editor@accountingweb.com
ADVERTISEMENT

Weekly video update

ADVERTISEMENT
ADVERTISEMENT

accountingweb.co.uk

More

Most read

Show more
ADVERTISEMENT