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 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],…)…

Read More

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 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…

Read More
error

Subscribe for Data Analytics Edge Newsletter & Share..:-)

error: Content is protected !!