Jump to content
Business Intelligence & Analytics Community for Digital Transformation

About this blog

Entries in this blog

Case Series 2 : Analyzing Sales data with Pivot Table

Case Series 2 : Analyzing Sales data with Pivot Table

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  

Saurabh Jain

Saurabh Jain

Tutorial 3 - Entering Formula &  introduction to cell referencing

Tutorial 3 - Entering Formula & introduction to cell referencing

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

Saurabh Jain

Saurabh Jain

Tutorial 1 - Creating First workbook - Monthly sales Projection

Tutorial 1 - Creating First workbook - Monthly sales Projection

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 Plea

Saurabh Jain

Saurabh Jain

×
×
  • Create New...