Excel: WHAT-IF ANALYSIS – II
As we know in excel it includes alot of powerful tools to perform difficult mathematical calculations, including what-if analysis. This feature can help you to…
Excel
Excel: DATA VALIDATION
Data validation feature allows you to set up certain rules that dictate what can be entered into a cell. It allows you to do the…
Excel: Functions
MATHEMATICAL FUNCTION 1. SUM: Sum function is used to calculate a simple total for a range of numeric cells. SYNTAX: =SUM (number1, [number2], …) EXAMPLE: Add…
Excel : SORT AND FILTER
Sorting: The literal meaning of sorting is to rearrange the stuff in a desired manner. The exactly same facility is provided by MS Excel to…
Pivot Tables For Experts
Now that we know how to create a Pivot table, Let us look into few advanced aspects of it. Let us find out the…
Pivot Tables For Beginner
What is Pivot Table in MS Excel? Ever wondered what we would do when we have chunks of data with thousands of rows and columns…
