Case Series 6 : Summarizing (Marketing) Data with Excel Functions By Saurabh Jain, December 13, 2020 Case Series Histogram Frequency Mean Mode Median Subtotals large Small Download dataset for practice Read more... 0 comments 3,524 views
Convert pdf to Excel : Import pdf data table in Excel By Saurabh Jain, December 12, 2020 Tips N Tricks Whether you are an analyst doing research, or student making a project, you have to many times extract data from pdf for analysis in excel. Here is a very simple and smart way of doing the same Read more... 0 comments 2,751 views
Approve members in Linkedin groups Power Automate Desktop web recording By Saurabh Jain, November 19, 2020 Power Automate Desktop Using web recorder in power automate desktop Read more... 0 comments 588 views
Rename Files in Power automate desktop by reading names from excel worksheet By Saurabh Jain, November 10, 2020 Power Automate Desktop Rename Files in Power automate desktop by reading names from excel worksheet #rpa Read more... 0 comments 1,952 views
VBA Tutorial 15 Count & Sum during loop By Saurabh Jain, November 7, 2020 VBA Tutorials Learn how to count, sum and display running totals Read more... 0 comments 941 views
Sending Dynamic Emails via Gmail from Excel email list using Power automate desktop By Saurabh Jain, November 6, 2020 Power Automate Desktop In this tutorial we will learn to send dynamic email to users listed in excel using power automate desktop An example of Robotic process automation Read more... 0 comments 1,523 views
VBA Tutorial 14 : For loop examples to read data write data & transform data By Saurabh Jain, November 6, 2020 VBA Tutorials VBA Tutorial 14 : For loop examples to read data write data & transform data Read more... 0 comments 1,505 views
Power Automate Demo : listing files from folder in Excel sheets By Saurabh Jain, November 5, 2020 Power Automate Desktop Read more... 0 comments 532 views
VBA Tutorial 13 : For next Loop By Saurabh Jain, November 3, 2020 VBA Tutorials Download VBA code Read more... 3 comments 1,292 views
VBA Tutorial 12 : Logical Test If Else Statement By Saurabh Jain, October 26, 2020 VBA Tutorials Download code file Read more... 1 comment 1,288 views
VBA Tutorial 11 InputBox & Message Box By Saurabh Jain, October 19, 2020 VBA Tutorials Download Read more... 1 comment 1,355 views
VBA Tutorial 10 : Using option explicit in variable declaration By Saurabh Jain, October 12, 2020 VBA Tutorials Read more... 0 comments 632 views
VBA Tutorial 9 : Data Types and Variables By Saurabh Jain, October 11, 2020 VBA Tutorials We will learn Storing data in variables Reading data from variables Calculations in variables Download macro enabled workbook Read more... 1 comment 1,039 views
Tutorial 19 Power Pivot Overview Dax Formulas calculated Column By Saurabh Jain, October 2, 2020 Tutorials Tutorial 19 Power Pivot Overview Dax Formulas – calculated Column Download the file for practice Read more... 0 comments 2,297 views
Tutorial 8 With construction and some useful application properties :VBA macros excel programming By Saurabh Jain, September 23, 2020 VBA Tutorials Download used code in this tutorial Read more... 1 comment 918 views
Tutorial 18 Fundamentals of table in Excel : Advanced MS Excel course By Saurabh Jain, September 4, 2020 Excel Overview of table in Excel Download Practice file https://bi-analytics.org/files/file/30-tutorial-18-tables-in-excel/ Make sure you sign in on the site and joined the club Read more... 2 comments 11,301 views
Tutorial 1 : Getting start with First report on Google data studio By Saurabh Jain, August 25, 2020 Tutorials Report link https://datastudio.google.com/s/gKoXJ-9rsec Report embedded Read more... 1 comment 699 views
Tutorial 17 What if analysis : Advanced MS Excel By Saurabh Jain, August 24, 2020 Tutorials Scenario Manager Goal seek Data tables Download practice file https://bi-analytics.org/files/file/29-tutorial-17-what-if-analysis/ Read more... 1 comment 3,198 views
Tutorial 16 Power view & 3D map : Advanced MS Excel By Saurabh Jain, August 12, 2020 Download files for practice Read more... 0 comments 1,521 views
Case Series 5 : Applying Filters & remove duplicates : Advanced MS Excel Course By Saurabh Jain, August 5, 2020 Download data set for practice Read more... 0 comments 2,052 views
Tutorial 7 : Understanding VBA Macro recording By Saurabh Jain, July 31, 2020 Read more... 1 comment 712 views
Tutorial 6 : Offset Property : Excel VBA Programming By Saurabh Jain, July 22, 2020 Read more... 2 comments 703 views
Case series 4 : Combining all files in folder and automate the combining process for new files By Saurabh Jain, July 18, 2020 Overview of using Power Query in Excel to automate the combining (appending) task Free Advanced MS Excel course Read more... 2 comments 3,099 views
Tutorial 15 : Refer range with Names : Advanced MS Excel By Saurabh Jain, July 16, 2020 Read more... 0 comments 2,502 views
Advanced Excel Tutorial 14 : Sumif, SumIFS, averageiFS formulas By Saurabh Jain, July 12, 2020 Tutorial 14 : Sumif, SumIFS, averageiFS formulas Download practice File https://bi-analytics.org/files/file/22-tutorial-14-sumif-sumifs/ Read more... 0 comments 1,648 views