Avatar of WeThotUWasAToad
WeThotUWasAToad
 asked on

Useful and best Excel tools for analyzing sales data

Hello,

This is a general question about how to most simply & efficiently use Excel tools to analyze sales data contained in a spreadsheet. My goal is to obtain some general guidelines which I can then begin to learn and apply. And I'm sure that process will spawn additional, more specific EE threads.

For example, suppose you've got a spreadsheet containing sales transactions (numbering in the thousands) in which each row represents a single transaction and column headings are as follows:

Trans #
Trans ID
Amount (USD)
Date
Time
Invoice #
First Name
Last Name
Address
City
State
ZIP
Country
Phone
Email
Custom1 (Yes/No)
Custom2
Custom3
Custom4

From that data, suppose you want to create a summary chart(s) showing information such as the following:

• Number of transactions per month.

• Number of customers making purchases per month.

• Number of new vs. established customers making purchases per month.
      a) where "established" is defined as existing in a separate spreadsheet
      b) where "established" is defined as existing earlier in the same spreadsheet

• Characteristics of dollar amount per sale (eg average dollar amt per sale, etc)
      a) including chart showing distribution curve

• Purchase patterns vs. time of day.

• Any of the above broken down by, for example, Custom1 Yes vs. No

What would be the best way to approach this?

Thanks
Microsoft Excel

Avatar of undefined
Last Comment
WeThotUWasAToad

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Simon

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
WeThotUWasAToad

ASKER
Thanks.
Your help has saved me hundreds of hours of internet surfing.
fblack61