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

    8 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 

    20 downloads

       (0 reviews)

    0 comments

    Updated

  4. Tutorial 19 Powerpivot

    Download template file for practice 

    31 downloads

       (0 reviews)

    0 comments

    Submitted

  5. Tutorial 18 : Tables in Excel

    Fundamentals of Tables

    23 downloads

       (0 reviews)

    0 comments

    Submitted

  6. Tutorial 17 What if analysis

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

    27 downloads

       (0 reviews)

    0 comments

    Submitted

  7. Tutorial 16 Power view & 3D map

    Download template file for data

    61 downloads

       (0 reviews)

    0 comments

    Submitted

       (0 reviews)

    0 comments

    Submitted

  8. Tutorial 1 Sales Projection.xlsx

    Tutorial 1 Sales Projection.xlsx

    119 downloads

       (0 reviews)

    1 comment

    Submitted

  9. Tutorial 15 Name Range

    Download template files

    23 downloads

       (0 reviews)

    0 comments

    Submitted

  10. Tutorial 14 Sumif & Sumifs

    Download template file for practice

    43 downloads

       (0 reviews)

    0 comments

    Submitted

  11. Tutorial 13 : Counting in Excel

    Counting formulas in excel

    49 downloads

       (0 reviews)

    0 comments

    Submitted

  12. Tutorial 12 If Statements

    Tutorial 12 If Statements

    41 downloads

       (0 reviews)

    0 comments

    Submitted

  13. Tutorial 11 : Dates in Excel

    Download template for your practice

    104 downloads

       (0 reviews)

    0 comments

    Submitted

  14. Tutorial 10 Xookup()

    Tutorial 10 Xookup()

    112 downloads

       (0 reviews)

    0 comments

    Submitted

  15. Case series 3 : Working with Charts

    Case series 3 : Working with Charts

    80 downloads

       (0 reviews)

    0 comments

    Submitted

  16. Tutorial 8 : Formulas for Text manipulation

    Download template file to practice

    96 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

    73 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

    121 downloads

       (0 reviews)

    0 comments

    Submitted

  19. Case Series 1 : Applying Formulas

    Download File for practice 

    139 downloads

       (0 reviews)

    0 comments

    Submitted

  20. Tutorial 4 Match & Lookup example

    Tutorial 4 Match & Lookup example

    72 downloads

       (0 reviews)

    0 comments

    Submitted

  21. Tutorial 3 - Cell referencing

    Tutorial 3 - Cell referencing 

    44 downloads

       (0 reviews)

    0 comments

    Submitted

×
×
  • Create New...