Business Intelligence & Analytics for Digital Transformation

Open Club  ·  2,082 members

# Files

## 25 files

1. #### Rank Function in Excel

Rank.Avg
Rank.EQ

(0 reviews)

Submitted

2. #### Large and Small in Excel

Large and Small function

(0 reviews)

Submitted

3. #### Case Series 1 : Applying Formulas

(0 reviews)

Submitted

4. #### Case Series 8 Lambda helper functions

lambda helper finctions
MAP Redude Scan Byrow  ByCol makearray isomitted

(0 reviews)

Submitted

5. #### Case series 7 Lambda function

(0 reviews)

Submitted

6. #### Case Series 6 Summarizing Marketing Data with Excel Functions

Case Series 6 Summarizing Marketing Data with Excel Functions

(0 reviews)

Updated

7. #### Tutorial 19 Powerpivot

(0 reviews)

Submitted

8. #### Tutorial 18 : Tables in Excel

Fundamentals of Tables

(0 reviews)

Submitted

9. #### Tutorial 17 What if analysis

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

(0 reviews)

Submitted

10. #### Tutorial 16 Power view & 3D map

(0 reviews)

Submitted

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

(0 reviews)

Submitted

12. #### Tutorial 1 Sales Projection.xlsx

Tutorial 1 Sales Projection.xlsx

(0 reviews)

Submitted

13. #### Tutorial 15 Name Range

(0 reviews)

Submitted

14. #### Tutorial 14 Sumif & Sumifs

(0 reviews)

Submitted

15. #### Tutorial 13 : Counting in Excel

Counting formulas in excel

(0 reviews)

Submitted

16. #### Tutorial 12 If Statements

Tutorial 12 If Statements

(0 reviews)

Submitted

17. #### Tutorial 11 : Dates in Excel

(0 reviews)

Submitted

18. #### Tutorial 10 Xookup()

Tutorial 10 Xookup()

(0 reviews)

Submitted

19. #### Case series 3 : Working with Charts

Case series 3 : Working with Charts

(0 reviews)

Submitted

20. #### Tutorial 8 : Formulas for Text manipulation

(0 reviews)

Submitted

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

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

(0 reviews)

Submitted

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

Template file for practice

(0 reviews)

Submitted

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

Case Series 2 : Analyzing Sales data with Pivot Table

(0 reviews)

Submitted

24. #### Tutorial 4 Match & Lookup example

Tutorial 4 Match & Lookup example

(0 reviews)

Submitted

25. #### Tutorial 3 - Cell referencing

Tutorial 3 - Cell referencing

(0 reviews)

Submitted

×
×
• Create New...