All language subtitles for 9. Mathematical Formulas Case Study

In this video we will learn about mathematical formulas in Excel we will use a case study to learn these

formulas come is a store manager of a mobile phone retailer in Bangalore.

The store sells for products mobile phone phone cover pen drive and headphone come is going to meet

his boss for a review of last year's sales performance becomes assistant has prepared this spreadsheet

with data about last year's sales performance will come now needs to complete this before he meets his

boss let us help become complete this spreadsheet income needs to calculate the net price and salesmen

for each product in a recorded as you can see the sales data is organized by quarters therefore quarters

here.

Quarter on quarter to quarter three and quarter for is a quarter started and the quarter ended for each

quarter for each product we have unit sales.

How many units were sold in that quarter have the list price of the product that is a multiple of the

product and we have the discount that was offered on that product in the quarter using this information

will help income calculate the net price and sales amount for each product for each quarter will also

help victim calculate unit sales for each product for interior as well as gross sales total discount

offered and net sales for each quarter.

Finally we calculate total annual sales for this store.

We will also calculate quarterly sales using subtotal formula and cross verify that result with what

we calculate in this table.