Jump to content
Business Intelligence & Analytics for Digital Transformation

23 files

  1. Case Series 8 Lambda helper functions

    lambda helper finctions
    MAP Redude Scan Byrow  ByCol makearray isomitted

    6 downloads

       (0 reviews)

    0 comments

    Submitted

  2. Case series 7 Lambda function

    Download file

    9 downloads

       (0 reviews)

    0 comments

    Submitted

  3. Case Series 6 Summarizing Marketing Data with Excel Functions

    Case Series 6 Summarizing Marketing Data with Excel Functions 

    21 downloads

       (0 reviews)

    0 comments

    Updated

  4. Tutorial 19 Powerpivot

    Download template file for practice 

    34 downloads

       (0 reviews)

    0 comments

    Submitted

  5. Tutorial 18 : Tables in Excel

    Fundamentals of Tables

    25 downloads

       (0 reviews)

    0 comments

    Submitted

  6. Tutorial 17 What if analysis

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

    28 downloads

       (0 reviews)

    0 comments

    Submitted

  7. Tutorial 16 Power view & 3D map

    Download template file for data

    65 downloads

       (0 reviews)

    0 comments

    Submitted

       (0 reviews)

    0 comments

    Submitted

  8. Tutorial 1 Sales Projection.xlsx

    Tutorial 1 Sales Projection.xlsx

    123 downloads

       (0 reviews)

    1 comment

    Submitted

  9. Tutorial 15 Name Range

    Download template files

    24 downloads

       (0 reviews)

    0 comments

    Submitted

  10. Tutorial 14 Sumif & Sumifs

    Download template file for practice

    46 downloads

       (0 reviews)

    0 comments

    Submitted

  11. Tutorial 13 : Counting in Excel

    Counting formulas in excel

    51 downloads

       (0 reviews)

    0 comments

    Submitted

  12. Tutorial 12 If Statements

    Tutorial 12 If Statements

    42 downloads

       (0 reviews)

    0 comments

    Submitted

  13. Tutorial 11 : Dates in Excel

    Download template for your practice

    105 downloads

       (0 reviews)

    0 comments

    Submitted

  14. Tutorial 10 Xookup()

    Tutorial 10 Xookup()

    113 downloads

       (0 reviews)

    0 comments

    Submitted

  15. Case series 3 : Working with Charts

    Case series 3 : Working with Charts

    82 downloads

       (0 reviews)

    0 comments

    Submitted

  16. Tutorial 8 : Formulas for Text manipulation

    Download template file to practice

    97 downloads

       (0 reviews)

    0 comments

    Submitted

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

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

    77 downloads

       (0 reviews)

    0 comments

    Submitted

       (0 reviews)

    0 comments

    Submitted

  18. 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

    132 downloads

       (0 reviews)

    0 comments

    Submitted

  19. Case Series 1 : Applying Formulas

    Download File for practice 

    146 downloads

       (0 reviews)

    0 comments

    Submitted

  20. Tutorial 4 Match & Lookup example

    Tutorial 4 Match & Lookup example

    75 downloads

       (0 reviews)

    0 comments

    Submitted

  21. Tutorial 3 - Cell referencing

    Tutorial 3 - Cell referencing 

    44 downloads

       (0 reviews)

    0 comments

    Submitted

×
×
  • Create New...