Excel | AccountingWEB

Excel

A&A

Farewell Peachtree Accounting, Hello Sage 50

After thirty-five years, the venerable software program known as Peachtree Accounting is adopting a new moniker - Sage 50 Accounting.
Technology

Microsoft Excel: Thirteen Double-Click Tricks

The impact of single-clicking on a menu or object in Microsoft Excel is generally intuitive, but double-clicking sometimes reveals hidden shortcuts. In this article I'll discuss a baker's dozen of techniques where double-clicking can save you time and effort.
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.
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.
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.
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.
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.
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.
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.
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.
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.
A&A

QuickBooks 2012: What’s New and Improved

If you or your clients use QuickBooks Pro, Premier, or Enterprise, you'll find that QuickBooks 2012's new features will help you gain new insights into financials, get more organized, and save time and steps.
Tax

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

Microsoft celebrates 25 years of Excel

Microsoft Excel has come a long way from its humble beginnings as a spreadsheet program for the Mac environment. This year, Microsoft is celebrating 25 years of Excel with a Facebook-based contest that encourages users to post their favorite Excel memory.
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.
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.
Technology

Two Ways to Determine Your Top Customers in QuickBooks, Excel

Given the length of the Great Recession, your top customers today might not be the same folks who were your top customers even a couple months ago. In this article I'll demonstrate two ways that you can determine who your top customers are based on total sales.
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.
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.
Technology

Office 2007 Themes Standardize Document Look, Feel

It can be a significant challenge to ensure that your company's documents have the same look and feel, particularly when you're using Excel, Word, PowerPoint, and Outlook together. Fortunately Office 2007's Themes feature can simplify the process.

Pages


Already a member? log in here.