Business Intelligence & Analytics for Digital Transformation

• Join the club
• and then you are on the board

Open Club  ·  1,049 members

• Excel Tutorials

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

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

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 Please

Tutorial 2 - Various elements in Excel & moving around worksheets

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

Case series 4 : Combining all files in folder and automate the combining process for new files

Overview of using Power Query in Excel to automate the combining (appending) task Free Advanced MS Excel course

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

Tutorial 4 Formula for Matching and lookup

In this tutorial, we will learning the use of  VLookup HLookup Match Index       another video just to go more deeper in VLOOKUP

Tutorial 19 Power Pivot Overview Dax Formulas calculated Column

Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column   Download the file for practice

Case Series 6 : Summarizing (Marketing) Data with Excel Functions

Histogram Frequency Mean  Mode Median Subtotals large  Small       Download dataset for practice