Files

25 files

1. Rank Function in Excel

   By Saurabh Jain

   Rank.Avg
   Rank.EQ
   

   19 downloads

      (0 reviews)

   0 comments

   Submitted April 3, 2022

2. Large and Small in Excel

   By Saurabh Jain

   Large and Small function
   

   18 downloads

      (0 reviews)

   0 comments

   Submitted March 27, 2022

3. Case Series 1 : Applying Formulas

   By Saurabh Jain

   Download File for practice 
   

   180 downloads

      (0 reviews)

   2 comments

   Submitted December 16, 2019

4. Case Series 8 Lambda helper functions

   By Saurabh Jain

   lambda helper finctions
   MAP Redude Scan Byrow  ByCol makearray isomitted

   36 downloads

      (0 reviews)

   0 comments

   Submitted July 30, 2021

5. Case series 7 Lambda function

   By Saurabh Jain

   Download file
   

   27 downloads

      (0 reviews)

   0 comments

   Submitted January 6, 2021

6. Case Series 6 Summarizing Marketing Data with Excel Functions

   By Saurabh Jain

   Case Series 6 Summarizing Marketing Data with Excel Functions 
   

   89 downloads

      (0 reviews)

   0 comments

   Updated December 13, 2020

7. Tutorial 19 Powerpivot

   By Saurabh Jain

   Download template file for practice 
   

   68 downloads

      (0 reviews)

   0 comments

   Submitted October 2, 2020

8. Tutorial 18 : Tables in Excel

   By Saurabh Jain

   Fundamentals of Tables
   

   74 downloads

      (0 reviews)

   0 comments

   Submitted September 4, 2020

9. Tutorial 17 What if analysis

   By Saurabh Jain

   Tutorial 17 is data file
   Tutorial 17 case is the final outcome
   

   54 downloads

      (0 reviews)

   0 comments

   Submitted August 24, 2020

10. Tutorial 16 Power view & 3D map

    By Saurabh Jain

    Download template file for data
    

    139 downloads

       (0 reviews)

    0 comments

    Submitted August 12, 2020

11. Case Series 5 : Applying Filters & remove duplicates : Advanced MS Excel Course

    By Saurabh Jain

    Download dateset for practice
    

    40 downloads

       (0 reviews)

    0 comments

    Submitted August 5, 2020

12. Tutorial 1 Sales Projection.xlsx

    By Saurabh Jain

    Tutorial 1 Sales Projection.xlsx
    

    150 downloads

       (0 reviews)

    1 comment

    Submitted January 25, 2019

13. Tutorial 15 Name Range

    By Saurabh Jain

    Download template files
    

    44 downloads

       (0 reviews)

    0 comments

    Submitted July 16, 2020

14. Tutorial 14 Sumif & Sumifs

    By Saurabh Jain

    Download template file for practice
    

    67 downloads

       (0 reviews)

    0 comments

    Submitted July 12, 2020

15. Tutorial 13 : Counting in Excel

    By Saurabh Jain

    Counting formulas in excel
    

    71 downloads

       (0 reviews)

    0 comments

    Submitted July 11, 2020

16. Tutorial 12 If Statements

    By Saurabh Jain

    Tutorial 12 If Statements
    

    58 downloads

       (0 reviews)

    0 comments

    Submitted June 30, 2020

17. Tutorial 11 : Dates in Excel

    By Saurabh Jain

    Download template for your practice
    

    125 downloads

       (0 reviews)

    0 comments

    Submitted April 12, 2020

18. Tutorial 10 Xookup()

    By Saurabh Jain

    Tutorial 10 Xookup()
    

    136 downloads

       (0 reviews)

    0 comments

    Submitted March 2, 2020

19. Case series 3 : Working with Charts

    By Saurabh Jain

    Case series 3 : Working with Charts
    

    108 downloads

       (0 reviews)

    0 comments

    Submitted February 27, 2020

20. Tutorial 8 : Formulas for Text manipulation

    By Saurabh Jain

    Download template file to practice
    

    113 downloads

       (0 reviews)

    0 comments

    Submitted January 29, 2020

21. Tutorial 7 : Mathematical operations commonly used in world of business analytics

    By Saurabh Jain

    Tutorial 7 : Mathematical operations commonly used in world of business analytics
    

    112 downloads

       (0 reviews)

    0 comments

    Submitted January 23, 2020

22. Tutorial 6 Applying Conditional Formatting : Free Advanced MS Excel course

    By Saurabh Jain

    Template file for practice
    

    84 downloads

       (0 reviews)

    0 comments

    Submitted January 4, 2020

23. Case Series 2 : Analyzing Sales data with Pivot Table

    By Saurabh Jain

    Case Series 2 : Analyzing Sales data with Pivot Table
    Download template file which has data to practice
    

    184 downloads

       (0 reviews)

    0 comments

    Submitted December 25, 2019

24. Tutorial 4 Match & Lookup example

    By Saurabh Jain

    Tutorial 4 Match & Lookup example
    

    86 downloads

       (0 reviews)

    0 comments

    Submitted May 31, 2019

25. Tutorial 3 - Cell referencing

    By Saurabh Jain

    Tutorial 3 - Cell referencing 
    

    51 downloads

       (0 reviews)

    0 comments

    Submitted February 7, 2019