Jump to content
Business Intelligence & Analytics for Digital Transformation
  • Login to participate

    • Sign up / Login
    • Join the club
    • and then you are on the board

About this blog

At top you will see the latest tutorial, please start from the bottom : Tutorial no 1 

Entries in this blog

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

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

  • Create New...