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
Absolute referencing
Mixed Referencing
Important points
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
Important shortcuts
Ctrl +F1
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
hello every one,
Today we are starting with our first tutorial, I just thought to start with creating our first workbook.
Please see the video and then do it once on your own..
We did the following
1. Column headers
2. Auto filling of months
3 Formula for growth percent
4 Formatting
4 Converted into table & Added Total Row
5 Created the Chart
6 Save
I am also attaching the workbook for your reference
Please