Our Latest Offers

Advance Excel


About Advance Excel

Formulas make Excel smart. With out them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. While anyone can use a simple SUM or IF formula, an advanced user of it would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas. Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion (and they also know few alternatives for any given formula problem).

Before you continue, you should have a basic understanding of the following:

1. Strong Knowledge of Computer.
2. Basic knowledge of Excel

Benefits of Courses:

1. Excel Expert
2. Excel Teacher

Projects

1. We will provide real time project training with code explanation and implementation.
2. Our training modules are completely designed according to current IT market.
3. After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
4. We offer regular, fast track and weekend training course.
5. Study material is provided with the course which consist of concepts, examples and real time examples.

Steps Content
1. Introduction Introduction to ms-excel
Difference b/w 2003/2007/2010
2.Working With Formulas/functions Look up and Reference Function Logical Function
Database Function Date and Time Function
Math function/text Function Information Function
3.Conditional Formatting Using Conditional Formatting Multiple cell rules
Creating New rules Managing existing rules
4.Conditional Formatting Using Conditional Formatting Multiple cell rules
Creating New rules Managing existing rules
5.Pivot Table Create Pivot Table Using Pivot table Option
Formatting pivot table Dynamic pivot table
6.Pivot chart Create Pivot chart Types and their usa
Dynamic pivot Chart
7.VBA Macros Introduction Recording macros and code behind
Adding and Editing VBA code