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

We're all about QuickBooks this morning. First, read this late-breaking news from John Stokdyk, editor of AccountingWEB (U.K.), who is attending the QuickBooks Connect conference in San Jose, California. Then, for more...
Technology—specifically internet technology—has a record of disrupting tried-and-true methods of operation in ways that we often don't foresee. Look no further than the recent HBO announcement that they *gasp...
If you're thinking that bitcoin and digital currency generally are merely some one-off flash in the pan, the new Digital Currency Council would argue otherwise. The council launched in September and already had 400...

Already a member? log in here.

Upcoming CPE Webinars

Oct 23Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.
Oct 30Many Excel users have a love-hate relationship with workbook links.
Nov 5Join CPA thought leader and peer reviewer Rob Cameron and learn ways to improve the outcome of your peer reviews while maximizing the value of your engagement workflow.
Nov 12This webcast presents basic principles of revenue recognition, including new ASU 2014-09 for the contract method. Also, CPAs in industries who want a refresher on revenue accounting standards will benefit.