Analyze Sales Data With Excel Pivot Tables

istock_RapidEye_excel
istock_RapidEye_excel
Share this content

INTRODUCTION TO THE SALES ANALYSIS TUTORIAL

 

In this tutorial you will learn how to import data in a "Text" file using Excel’s Import wizard, then analyse it via pivot tables.

To get started, you should first download the STARTUP file. This is a Word file (one page). When it appears on your screen, select File - Print to print a hard copy, then return to this point in Accountingweb. To download this file now, double click on Startup.

Using the instructions in STARTUP, now download the two files which you will be using in the tutorial. They are the Word file and SALANAL.TXT.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

About David Carter

About David Carter

Based in Hemel Hempstead, Herts, David Carter is an independent consultant who installs accounting and order processing systems into small and medium size businesses. Since 1996 he has been training people to use Excel pivot tables in areas such as budgetting, cost centre reporting, job costing, sales analysis, order book analysis, and production control. 

Replies

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.