In this case, we will analyze sales data from two stores and answer the following questions
What percentage of sales occur at each store ?
What percentage of sales occur at each month ?
How much revenue does each product generated?
Which products generate 80 % of revenue?
We will also learn the Use of Report Filters & Slicers
Download data set
In this tutorial we will learn to write basic formulas and introduction to cell referencing
Relative referencing which is the default referencing
4 type of referencing can be cycle through f4 key - when we are in edit mode of cell - (use f2 to enter into edit mode) - A1 , $a$1 , A$1, $A1
Shortcut Ctrl + ~ (tilde which is just above 1 in windows)
pl download file
Where we can use Excel
Lets look into various elements of Excel & Ribbon
Page Up Page down with Alt and without Alt
Right arrow (Tab) Left Arrow ( Shift + tab)
You are requested to add comments for a discussion - How do you use excel