Jump to content
Business Intelligence & Analytics for Digital Transformation

25 files

  1. Rank Function in Excel

    Rank.Avg
    Rank.EQ

    9 downloads

       (0 reviews)

    0 comments

    Submitted

  2. Large and Small in Excel

    Large and Small function

    8 downloads

       (0 reviews)

    0 comments

    Submitted

  3. Case Series 1 : Applying Formulas

    Download File for practice 

    166 downloads

       (0 reviews)

    2 comments

    Submitted

  4. Case Series 8 Lambda helper functions

    lambda helper finctions
    MAP Redude Scan Byrow  ByCol makearray isomitted

    20 downloads

       (0 reviews)

    0 comments

    Submitted

  5. Case series 7 Lambda function

    Download file

    14 downloads

       (0 reviews)

    0 comments

    Submitted

  6. Case Series 6 Summarizing Marketing Data with Excel Functions

    Case Series 6 Summarizing Marketing Data with Excel Functions 

    56 downloads

       (0 reviews)

    0 comments

    Updated

  7. Tutorial 19 Powerpivot

    Download template file for practice 

    51 downloads

       (0 reviews)

    0 comments

    Submitted

  8. Tutorial 18 : Tables in Excel

    Fundamentals of Tables

    45 downloads

       (0 reviews)

    0 comments

    Submitted

  9. Tutorial 17 What if analysis

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

    42 downloads

       (0 reviews)

    0 comments

    Submitted

  10. Tutorial 16 Power view & 3D map

    Download template file for data

    95 downloads

       (0 reviews)

    0 comments

    Submitted

       (0 reviews)

    0 comments

    Submitted

  11. Tutorial 1 Sales Projection.xlsx

    Tutorial 1 Sales Projection.xlsx

    134 downloads

       (0 reviews)

    1 comment

    Submitted

  12. Tutorial 15 Name Range

    Download template files

    31 downloads

       (0 reviews)

    0 comments

    Submitted

  13. Tutorial 14 Sumif & Sumifs

    Download template file for practice

    54 downloads

       (0 reviews)

    0 comments

    Submitted

  14. Tutorial 13 : Counting in Excel

    Counting formulas in excel

    59 downloads

       (0 reviews)

    0 comments

    Submitted

  15. Tutorial 12 If Statements

    Tutorial 12 If Statements

    50 downloads

       (0 reviews)

    0 comments

    Submitted

  16. Tutorial 11 : Dates in Excel

    Download template for your practice

    115 downloads

       (0 reviews)

    0 comments

    Submitted

  17. Tutorial 10 Xookup()

    Tutorial 10 Xookup()

    123 downloads

       (0 reviews)

    0 comments

    Submitted

  18. Case series 3 : Working with Charts

    Case series 3 : Working with Charts

    96 downloads

       (0 reviews)

    0 comments

    Submitted

  19. Tutorial 8 : Formulas for Text manipulation

    Download template file to practice

    104 downloads

       (0 reviews)

    0 comments

    Submitted

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

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

    101 downloads

       (0 reviews)

    0 comments

    Submitted

       (0 reviews)

    0 comments

    Submitted

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

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

    152 downloads

       (0 reviews)

    0 comments

    Submitted

  22. Tutorial 4 Match & Lookup example

    Tutorial 4 Match & Lookup example

    81 downloads

       (0 reviews)

    0 comments

    Submitted

  23. Tutorial 3 - Cell referencing

    Tutorial 3 - Cell referencing 

    47 downloads

       (0 reviews)

    0 comments

    Submitted

×
×
  • Create New...