Case 3a

In this case, we will demonstrate the importance of combining formulas and how formulas which are generally regarded as useless can be put to good use and save you time in cleaning up your Excel. We will also show you how you can create a report quickly using the SUBTOTAL function that is readily available within Excel.

3.1 Retrieve Part of a Text From a Cell

3.2 Retrieve Text of Varying Length Intelligently

3.3 Combine Records From 2 Worksheets Together

3.4 Creating a Total for Each Group of Companies

3.5 Highlighting the Subtotal Rows All At Once


Quick Access to the other Hidden Secrets in Data Analysis with Excel cases.

Case 1

Case 2

Case 3a

Case 3b

Case 4

Case 5

Case 6

Case 7