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…
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,…
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…
External data is defined as data that exists outside of the Excel workbook, in some other place. Other places could be almost anywhere; and Excel supports pulling external data from a wide variety of sources. Examples include data stored on web pages, in text files, or in other programs. Excel 2007 is been used in…
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…
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…
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…
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…
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…
