Class Room/Online Training. 100% JOB assured training.

 +91 72590 26405/98860 94611

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager).[5] It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet presents itself as a so-called application, or decision support system (DSS), via a custom-designed user interface, for example, a stock analyzer, or in general, as a design tool that asks the user questions and provides answers and reports. In a more elaborate realization, an Excel application can automatically poll external databases and measuring instruments using an update schedule, analyze the results, make a Word report or PowerPoint slide show, and e-mail these presentations on a regular basis to a list of participants. Excel was not designed to be used as a database.


  • Excel Basics :

  • Excel Functions : Learn the different functions of Excel: text, mathematical, statistical functions, and financial functions.

  • Data Visualization:

  • Advanced Concepts :


    Excel Formulas
    VBA, Macros & automation
    Pivot Tables
    Lookup Formulas
    Excel Charts
    Sorting & Filtering data
    Conditional formatting
    Drop down validation & form controls


    Central Coordinator
    Advanced Excel Fresher
    Mis-Analist ( advanced excel )
    Senior Associate Market Research
    Mis – Executive
    Senior MI Analyst


Vertical LookUP Concatenation, IF else condition
Count IF, Maximum, Minimum, Average
SUM, Pivot Chart, Vertical

Apply Now