Charts and Graphs in Excel

Charts and graphs are used to make information clearer and easier to understand. A good picture is worth a thousand numbers. The most common place for people to see charts and graphs is in the news. News publishers use graphics all the time to show comparisons and explain important trends for things such as weather, gas prices,…

Read More

Excel: Functions-II

TEXT FUNCTIONS 1. TRIM: Removes all spaces from a text string except for single spaces between words SYNTAX: =TRIM (text) TEXT: Required. The text from which you want spaces removed. EXAMPLE:   2. LEN: Returns the number of characters in a text string SYNTAX: =LEN (text) TEXT: Required. The text whose length you want to…

Read More

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

Excel: WHAT-IF ANALYSIS

One of the most appealing aspects of Excel is its ability to create dynamic models. A dynamic model uses formulas that instantly recalculate when you change values in cells that are used by the formulas. When you change values in cells in a systematic manner and observe the effects on specific formula cells, you’re performing…

Read More

Unconditional Excellence: Conditional Formatting in Excel

What is conditional formatting ??? From one of the great leaps forward in succeeding versions of Microsoft Excel it has been in clarifying information in instant and awareness grabbing ways. Excel’s different tools and charting options have improved with different updates and yet other facilities have come alongside these more different basic requirements that enable…

Read More
error

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

error: Content is protected !!