Jump to content
Business Intelligence & Analytics for Digital Transformation

25 files

  1. Rank Function in Excel

    Rank.Avg
    Rank.EQ

    17 downloads

       (0 reviews)

    0 comments

    Submitted

  2. Large and Small in Excel

    Large and Small function

    16 downloads

       (0 reviews)

    0 comments

    Submitted

  3. Case Series 1 : Applying Formulas

    Download File for practice 

    176 downloads

       (0 reviews)

    2 comments

    Submitted

  4. Case Series 8 Lambda helper functions

    lambda helper finctions
    MAP Redude Scan Byrow  ByCol makearray isomitted

    32 downloads

       (0 reviews)

    0 comments

    Submitted

  5. Case series 7 Lambda function

    Download file

    21 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 

    76 downloads

       (0 reviews)

    0 comments

    Updated

  7. Tutorial 19 Powerpivot

    Download template file for practice 

    63 downloads

       (0 reviews)

    0 comments

    Submitted

  8. Tutorial 18 : Tables in Excel

    Fundamentals of Tables

    62 downloads

       (0 reviews)

    0 comments

    Submitted

  9. Tutorial 17 What if analysis

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

    50 downloads

       (0 reviews)

    0 comments

    Submitted

  10. Tutorial 16 Power view & 3D map

    Download template file for data

    126 downloads

       (0 reviews)

    0 comments

    Submitted

       (0 reviews)

    0 comments

    Submitted

  11. Tutorial 1 Sales Projection.xlsx

    Tutorial 1 Sales Projection.xlsx

    139 downloads

       (0 reviews)

    1 comment

    Submitted

  12. Tutorial 15 Name Range

    Download template files

    40 downloads

       (0 reviews)

    0 comments

    Submitted

  13. Tutorial 14 Sumif & Sumifs

    Download template file for practice

    65 downloads

       (0 reviews)

    0 comments

    Submitted

  14. Tutorial 13 : Counting in Excel

    Counting formulas in excel

    67 downloads

       (0 reviews)

    0 comments

    Submitted

  15. Tutorial 12 If Statements

    Tutorial 12 If Statements

    56 downloads

       (0 reviews)

    0 comments

    Submitted

  16. Tutorial 11 : Dates in Excel

    Download template for your practice

    121 downloads

       (0 reviews)

    0 comments

    Submitted

  17. Tutorial 10 Xookup()

    Tutorial 10 Xookup()

    131 downloads

       (0 reviews)

    0 comments

    Submitted

  18. Case series 3 : Working with Charts

    Case series 3 : Working with Charts

    104 downloads

       (0 reviews)

    0 comments

    Submitted

  19. Tutorial 8 : Formulas for Text manipulation

    Download template file to practice

    110 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

    109 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

    177 downloads

       (0 reviews)

    0 comments

    Submitted

  22. Tutorial 4 Match & Lookup example

    Tutorial 4 Match & Lookup example

    85 downloads

       (0 reviews)

    0 comments

    Submitted

  23. Tutorial 3 - Cell referencing

    Tutorial 3 - Cell referencing 

    50 downloads

       (0 reviews)

    0 comments

    Submitted

×
×
  • Create New...