Excel Sales Data Calculations | Learn Addition, Subtraction, Multiplication, Division & Percentage

Описание: Description (detailed)
In this step-by-step Excel tutorial we use a simple sales dataset (Notebook, Pen, Bag, Water Bottle, Calculator) to teach the five basic operations you need for the assignment: Addition, Subtraction, Multiplication, Division and Percentage. This video is perfect for beginners and students completing an Excel assignment.

What you’ll learn (with exact Excel formulas & examples):

1. Set up columns — A: ProductID, B: ProductName, C: Unit Price, D: Quantity Sold, E: Discount (%).

Enter discounts as 5%, 10% etc. and format column E as Percentage; format price columns as Currency.



2. Multiplication — Total price before discount (per row)

Formula (row 2): =C2*D2 → put this in F2 and drag down.

Example (Notebook): =50*25 → 1250.



3. Percentage — Discount amount (per row)

Formula: =F2*E2 → put in G2 and drag down.

Example (Notebook): =1250*5% → 62.50.



4. Subtraction — Price after discount (per row)

Formula: =F2-G2 → put in H2 and drag down.

Example (Notebook): =1250-62.50 → 1187.50.



5. Addition / SUM — Totals for the whole table

Total before discounts: =SUM(F2:F6) → 19,850.

Total discounts: =SUM(G2:G6) → 1,437.50.

Total after discounts: =SUM(H2:H6) → 18,412.50.



6. Division — Average selling price

Simple average of unit prices: =AVERAGE(C2:C6) → 302.00 (simple mean of listed unit prices).

Recommended (weighted) average selling price per unit (accounts for different quantities):
=SUM(H2:H6)/SUM(D2:D6) → 122.75 (this tells you how much, on average, a sold unit brought in after discounts).



7. Quick tips

Use the Fill Handle to copy formulas down.

Lock references if needed with $ (e.g. if referring to a fixed cell).

Check formatting (Currency / Percentage) so Excel displays numbers clearly.




Example row results (from our dataset shown in the video):

Notebook: before = 1,250, discount = 62.50, after = 1,187.50

Pen: before = 600, discount = 0, after = 600

Bag: before = 8,000, discount = 800, after = 7,200

Water Bottle: before = 7,500, discount = 375, after = 7,125

Calculator: before = 2,500, discount = 200, after = 2,300


If you follow along you’ll finish your assignment fast and understand how each formula works. Don’t forget to like and subscribe for more quick Excel lessons!

#Hashtags
#Excel #ExcelTutorial #SalesData #ExcelFormulas #Discount #SUM #AVERAGE #BeginnerExcel