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 6 : Summarizing (Marketing) Data with Excel Functions

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

## 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 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

## 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 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 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 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

×
×
• Create New...