Excel tips

Technology

Seven Quick Excel Tips

Here are seven quick Excel tips for: converting data, amortizing tables, spanning Excel across multiple monitors, filtering for blank rows in Excel 2010, recovering unsaved workbooks in Excel 2010, identifying duplicate values in Excel 2007/2010, and recovering damaged Excel workbooks.
12734
Technology

Free Spreadsheet-Based Form 1040 Available for 2011 Tax Year

Glenn Reeves of Burlington, Kansas, recently released his fifteenth annual spreadsheet-based version of the U.S. Individual Tax Return, commonly known as Form 1040. Since 1997, Reeves has pursued this "labor of love," which means he allows any taxpayer to download and use the spreadsheet for free.
24405
Technology

Excel Tip: Table Feature Enables Effective Analysis

Excel 2007 and 2010 users often overlook the useful Table feature, which can streamline data analysis. The feature is a major overhaul of the List feature that has been on the Data menu of earlier Excel versions. This article will introduce you to the Table feature and show you how it can help you work faster.
7307
Technology

Everything you need to know about Excel range names

Are you familiar with the range names feature in Excel? It is one of the most powerful tools that even the most basic Excel user can easily master. Name a cell or a block of cells and then work with those cells in formulae and searches throughout the workbook.
34713
Technology

Excel Tip: Multiple criteria SUM, MIN, and MAX formulas

Most Excel users are familiar with the SUM, MIN, and MAX functions in Excel. Used in their traditional fashion, you provide a range of cells to the function to derive a result. However, in certain cases you may wish to use this functions based on multiple criteria.
35772
Technology

Free spreadsheet-based Form 1040 available for 2010 tax year

Glenn Reeves of Burlington, Kansas, has created a free Microsoft Excel-based version of the 2010 U.S. Individual Tax Return, commonly known as Form 1040.
25779
Technology

Under the Radar Part 1: Five new features in Excel 2010

I have to admit, I was underwhelmed when Office 2010 was released. You’d think that an Excel expert would like nothing more than a shiny new version of Excel, but my initial experience with the new user interface in Excel 2007 left me feeling chastened.
6033
Technology

Under the Radar Part 2: Five new features in Excel 2010

I introduced you to five subtle changes that Microsoft added in Excel 2010 that I’ve found quite helpful in part one of this two-part series. In this second part of the series, I’ll discuss five more features that have boosted my productivity in Excel.
5274
Technology

What to do when Excel won't let you insert columns

From time to time you might encounter the prompt that appears when Excel thinks you can't add additional columns or rows.
43027
Technology

Sales/Tax by shipping state in Excel – The power of pivot tables, Part 1

This is the first of two articles wherein Chuck Vigeant demonstrates several ways of approaching Sales and Tax by Shipping State within Excel – one without a pivot table, and one with a pivot table.
6527
Technology

Sales/Tax by shipping state in Excel – The power of pivot tables, Part 2

This is the second of two articles wherein Chuck Vigeant explores the ability to generate a Sales by Shipping State report in Excel.
5630
Technology

Transform multiple-line cell contents into columns in Excel

Sometimes in Excel you may encounter a situation where each cell contains multiple lines of data. In this article I'll explain some simple techniques that can make quick work of transforming this data into columns.
31300
Technology

Understanding the Undo option in Excel

One of my favorite features in Excel is the Undo feature, which as you might expect, allows you to undo the last action that you carried out in Excel. Indeed, you can generally undo multiple steps in Excel. However, there are some caveats to this functionality, as well as a couple tricks you may not know.
7610
Technology

Excel Tip: Converting numbers formatted as <1> to -1

In this article I'll discuss two approaches you can use to convert text-based inputs to negative numbers. I'll also share a formatting technique you can use if you want to enclose negative numbers in such brackets instead of parentheses.
4767
Technology

What's the FREQUENCY? Using Excel's FREQUENCY function

From time to time you may want to determine how items fall within specific ranges. For instance, a real estate portfolio manager may wish to know how many buildings fall within ranges of 250,000, 500,000, and one million square feet.
36288
Technology

Some unlikely uses for Excel's SUMPRODUCT function

While you may not be aware of Excel's SUMPRODUCT function, those in the know often use it for its stated purpose: multiplying two ranges together and then summing the total. Although this is helpful, you might not be aware that SUMPRODUCT also can function like VLOOKUP or SUMIF on steroids.
63938
Technology

Three tricks for formatting rows in Excel

I'm sure that you've worked with data sets in Excel where the information starts blurring together. In this article I discuss several techniques that I use avoid getting lost in the forest.
23283
Technology

Three Excel menus you may have overlooked

By David H. Ringstrom, CPASheet NavigationEveryone is familiar with using the arrow buttons in the lower left-hand corner of the Excel screen to push worksheet tabs back and forth across the screen. However, try right-clicking on these buttons instead, and you'll see a menu similar to Figure 1. Simply click on a sheet name to instantly activate that worksheet.&nbsp;
2162
Technology

Managing Excel Add-Ins

By David H. Ringstrom, CPAAdd-ins are programs that plug-in into Microsoft Excel to add additional functionality. Some add-ins expand Excel's core functionality, while others allow third-party products to add features to Excel's environment. In this article I'll discuss how to enable some of Excel's hidden features, as well as give you some pointers on what to do when third-party add-ins vanish from Excel.Hidden FeaturesExcel ships with several add-ins that you can manually enable. Some of these include:&nbsp;
6387
Technology

Buried gold: Excel's Form command

By David H. Ringstrom, CPAMany users are not aware that Excel has long had a feature that enables you to browse through a table of data one record at a time. As shown in Figure 1, the Form command provides an easy way to navigate through a table of data. This command is easy to access in Excel 2003 and earlier versions, but is deeply buried in Excel 2007. In this article I'll show you how to use the Form command to make quick work of reviewing a list of records.&nbsp;
2940

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