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…
MS Excel
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
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: 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…
Excel with Look up Function
Excel with Look up Function: VLOOKUP:-Vlookup is an excel function to lookup and retrieve data from a specific column. Vlookup support approximate and exact match….
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…
Pivot Tables For Experts
Now that we know how to create a Pivot table, Let us look into few advanced aspects of it. Let us find out the…
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…
