More pivot table secrets revealed

Pivot tables return by popular demand! Consultant David Carter is back at AccountingWEB with another of his vital guides to using pivot tables in Excel.

David's previous tutorial on this invaluable Excel tool was the most visited part of AccountingWEB last year, and this second rundown, on sales analysis, should prove to be just as much of a hit.

David's second tutorial lets you analyze complicated sales data quickly and easily from accounting packages such as Sage, Pegasus, SunAccount, Navision etc.

Online students will learn how to import data in a Text file, the lowest common denominator file format, using Excel’s Import wizard, then break it down with pivot tables.

Go to the sales analysis tutorial now!

Go to the original Excel Pivot Table Tutorial.

You may like these other stories...

Continuing its efforts to simplify accounting procedures, the FASB has issued a proposed Accounting Standards Update on customer fees paid in a cloud computing arrangement. The newly-proposed update (Intangibles—...
How are you planning? What tools do you use (or fail to use) for forecasting? PlanGuru is a business budgeting, forecasting, and performance review software company based in White Plains, N.Y. AccountingWEB recently spoke...
Event Date: October 30, 2014, 2 pm ETMany Excel users have a love-hate relationship with workbook links. For the uninitiated, workbook links allow you to connect one Microsoft Excel spreadsheet to other spreadsheets, Word...

Already a member? log in here.

Upcoming CPE Webinars

Aug 26
This webcast will include discussions of recently issued, commonly-applicable Accounting Standards Updates for non-public, non-governmental entities.
Aug 28
Excel spreadsheets are often akin to the American Wild West, where users can input anything they want into any worksheet cell. Excel's Data Validation feature allows you to restrict user inputs to selected choices, but there are many nuances to the feature that often trip users up.
Sep 9
In this session we'll discuss the types of technologies and their uses in a small accounting firm office.
Sep 11
This webcast will include discussions of commonly-applicable Clarified Auditing Standards for audits of non-public, non-governmental entities.