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 explore different scenarios without changing the values in your spreadsheet. This function is particularly useful for all economics and management majors as well as business owners because you can see…
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 following: Make a list of the entries that restricts the values allowed in a cell. Create a prompt message explaining the kind of data allowed in a cell. Create messages…
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 numbers stored in cell from cell numbers D1 to D4. 2. SUM PRODUCT: Returns the sum of the products of corresponding ranges of array SYNTAX: =sum product (array1, array2, [array3],…)…
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 sort the data. While sorting a table, we rearrange the rows based on the contents of a particular column for example we need to sort a table in such a…
Now that we know how to create a Pivot table, Let us look into few advanced aspects of it. Let us find out the Total Sales Amount for the Sales data done by each region in terms of percentage of Total Amount. Looking at the data, it is clear that we don’t have a…
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 to be processed? Finding a minute amount of information from the data would be a hefty and time consuming task, right? Well, Understanding the data itself consumes a lot of…
