MS EXCEL FUNCTIONS
Function Definition: A function is a predefined formula that performs calculations using specific values in a particular order. Types of functions: According to Microsoft support, worksheet functions…
Advance Excel
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…
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…
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 : Importing External Data
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…
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…
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…
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…
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…
