How to Make Daily Sales Report in Excel (With Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for some special tricks to make daily sales reports in Excel, you’ve come to the right place. In Microsoft Excel, there is one way to make a daily sales report. In this article, we’ll discuss every step of this method to make a daily sales report in Excel. Let’s follow the complete guide to learn all of this.


What Is Sales Report?

An organization’s sales report compiles, summarizes, and organizes information about its sales.

A sales report contains:

  • A record of each item’s sales against the target.
  • The number of engaged customers.
  • Continuation or discontinuation of existing customer records.
  • Comparing the new table with the old one is crucial.

How to Make Daily Sales Report in Excel (With Quick Steps)

In the following section, we will use one effective and tricky method to make daily sales reports in Excel. This section provides extensive details on every step of making daily sales reports in Excel. You should learn and apply to improve your thinking capability and Excel knowledge.


Step 1: Import Your Dataset

Here, we will demonstrate how to make daily sales reports in Excel. Let us first introduce you to our Excel dataset so that you are able to understand what we are trying to accomplish with this article. For creating a daily sales report, we have the following dataset of a companies’ s daily items price and total sales in May month. The everyday sales price of the TV, AC, Heater and Pump are shown in respective columns D, E, F, and G. Column H shows the total sales for each day, which we get by adding the columns D, E, F, and G. The following picture indicates the first 17 days sales data for May month of the company.

Import Your Dataset

The following picture indicates the rest of the sales data for the May month of the company.

How to Make Daily Sales Report in Excel

Read More: How to Make Daily Activity Report in Excel


Step 2: Create Pivot Tables

Now, we are going to create a Pivot Table. To do this, we have to follow the following steps:

  • Firstly, select the range of cells B4:H35.
  • Next, select the Insert tab. Then, select PivotTable > From Table/Range.

Create Pivot Tables

  • When the PivotTable from table or range dialog box appears, choose New Worksheet. Then, click on OK.

How to Make Daily Sales Report in Excel

  • As a consequence, there will be a new worksheet. Your Pivot Table Fields will appear on the right.
  • After that, check Day and Total Sales.
  • Then, place Day in Rows, and Total Sales in the Values section.

How to Make Daily Sales Report in Excel

  • As a result, you will be able to create a pivot table containing the day and total sales of the dataset like the following.

Create Pivot Tables

  • The rest of the data in the pivot table are the following.

How to Make Daily Sales Report in Excel

  • If we want to create a pivot table containing each week’s total sales you need to right-click on the previous table and select Group.

Create Pivot Tables

  • Next, check the Starting at. Select Days. Then, enter 7 in the Number of days box.

How to Make Daily Sales Report in Excel

  • As a consequence, you will be able to create a pivot table containing each week’s total sales, like the following.

Create Pivot Tables


Step 3: Inset Slicer

Now, we will insert a slicer into our spreadsheet. It gives us a lot of flexibility while filtering our data. To do this, you have to follow the following steps.

  • Firstly, select the whole pivot table.
  • Go to Pivot Table Analyze and select Insert Slicer.

Inset Slicer

  • Then, select Day in the Insert Slicers dialog box.

How to Make Daily Sales Report in Excel

  • As a consequence, you will be able to create a slicer like the following.

Inset Slicer


Step 4: Insert Charts for Pivot Tables

Now, we are going to create four different charts for the daily sales reports. To do this, we have to follow the following steps.

  • To create a chart, select the range of data and go to the Insert tab. Next, select the 2-D Column chart.

Inserting Charts for Pivot Tables

  • As a consequence, you will get the following chart.

Inserting Charts for Pivot Tables

  • To modify the chart style, select Design and then, select your desired Style 4 option from the Chart Styles group.

How to Make Daily Sales Report in Excel

  • As a consequence, you will get the following modified chart.

  • To create another chart, select the range of data and go to the Insert tab. Next, select the 2-D Line chart.

How to Make Daily Sales Report in Excel

  • As a consequence, you will get the following chart.

  • To modify the chart style, select Design and then, select your desired Style 6 option from the Chart Styles group.

How to Make Daily Sales Report in Excel

  • As a consequence, you will get the following modified chart.

  • To create a Pie chart, select the range of data and go to the Insert tab. Next, select the 3-D Pie chart.

How to Make Daily Sales Report in Excel

  • As a consequence, you will get the following Pie chart.

  • To create another chart, select the range of data and go to the Insert tab. Next, select the 2-D Line chart.

How to Make Daily Sales Report in Excel

  • As a consequence, you will get the following chart.

  • To modify the chart style, select Design and then, select your desired Style 4 option from the Chart Styles group.

How to Make Daily Sales Report in Excel

  • As a consequence, you will get the following modified chart.

Inserting Charts for Pivot Tables

Read More: Create a Report That Displays Quarterly Sales in Excel


Step 5: Generate Final Report

Now, we will create final reports. To do this, we are going to show our charts in a new sheet as a Report.

  • To create a report, at first, you have to create a new sheet and set the name of that sheet as Report.
  • Next, you have to copy every chart by pressing ‘Ctrl+C’ and go to the Report sheet, and press ‘Crl+V’ to paste it.
  • As a consequence, you will get the Daily Sales report like the following.

How to Make Daily Sales Report in Excel

Read More: How to Make Monthly Sales Report in Excel


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

That’s the end of today’s session. I strongly believe that from now on you may be able to make daily sales reports in Excel. If you have any questions or recommendations, please share them in the comments section below.


What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo