Skip to content

The objective of this project is to analyze supermarket sales data using formulas in Microsoft Excel.

Notifications You must be signed in to change notification settings

agungbudiwirawan/sales-analysis-using-excel-formulas

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 

Repository files navigation

Sales Analysis using Excel Formulas

Overview

The objective of this project is to analyze supermarket sales data using formulas in Microsoft Excel.

Dataset

I am using dataset from kaggle.com

Question

  1. How much gross income does each branch get?
  2. How many sales quantity for each product line?
  3. How much gross income does the company get each month?
  4. When are the most sales happening?morning/afternoon/night
  5. What is the average rating for each branch?
  6. What is the average product discount given by each branch?
  7. How much cogs of product does each branch?
  8. How is the performance distribution of each branch?
  9. Identify the top 10 transactions based on total transactions!

Algorithm

  • create data in tabular form.
  • create additional columns to assist data analysis.
  • analyze data using excel formulas.
  • create a Dropdown List, so that the results of the analysis become more dynamic.
  • create a progress bar to display the distribution of performance.

Formula

  • IF
  • SUM, SUMIF, SUMIFS
  • COUNTIF, COUNTIFS
  • LOOKUP
  • MATCH
  • INDEX
  • CONCENATE
  • TEXT

Thank You!

About

The objective of this project is to analyze supermarket sales data using formulas in Microsoft Excel.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published