Blogs

Basic Excel & Advance Excel

MS Excel
Category : Excel   Tags : Excel, Microsoft excel, worksheets, workbooks, MS Excel, Data Analysis

Introduction:

Excel, when introduced by Microsoft, emerged out as the most powerful tool to handle the data. The data can be analyzed and put as an information to user, which can be used further for analyzing the performance. The information can also be used to improve the performance using what-if analysis.

It is now used by every organization to carry various calculations & analysis to improve their performance to gain more profits and increase the business.

Some terms commonly used in Excel are given below along with their definitions:

  • Cells - The intersection of rows and column

  • Range - The combination of two or more cells

  • Rows - The horizontal series of cells showing the data for particular field. Commonly signified with the numbers of the extreme left of the worksheet.

  • Column - The vertical series of cells also called as field, contains only specific type of data. Commonly signified with the Alphabets on the top of the worksheet.

  • Functions - The predefined formulas in Excel to facilitate calculations, like sum(), sumif(), average(), count() etc.

  • Formulas - The combination of more two or more functions to make the expressions for calculations.


Pivot Tables

The most useful and important tool introduced by MS-Excel, it enables user to view only the required piece of information from the raw data. All the information for the required field is displayed.


Lookups:

Using Lookup functions user can fetch only the required fields from the raw data to the new worksheet.


What-if Analysis:

Gives more than one scenario with different values, enables user to choose the most suitable one.


Macros & VBA:

Macros are the most interesting tool provided in Excel. It facilitates user to carry on the repetitive tasks in much less than doing it manually. It records the steps you carry on daily basis and then play those steps, which saves a lot of time and enable you to do more productive work.

Macros are recorded in VBA, which is Visual Basic for Applications, it is actually the editor where you program your macro in Visual Basic Language. Yes, you need to have the knowledge of visual basic to use the tools in the VB editor.