Scenario Manager and its Application

The process of trying out different value for formula to see how the changes will affect the outcome is known as What-If Analysis. Scenario Manager in other hand, is one of the tools used to create and save multiple assumptions “what-If” Scenario in Microsoft Excel. What-If Analysis tools are located in the Data Menu. ZHM[…]

Shares 0

Advanced Filter in Microsoft Excel

Advance Filter feature in Excel facilitates the easier way to extract records from dataset using complex criteria while saving lot of time. For instance, the criteria for filtering in our earlier Filter demonstration “How to Filter Records in Excel”  include “BAJAJ BOXER” as product and “MUSA” as Sale Rep. which took us up to eight steps[…]

Shares 0