Advance Excel Training

Advance Excel Training is best suited for candidates who often use this application in their day-to-day work and would like to upgrade their knowledge to use the advanced features and perform sophisticated operations. Microsoft Excel is most commonly used to perform simple calculations, data storage, data analysis, report generation and complex statistical computations. Most of the organization uses Excel for data analysis. The present day managerial job requires lots of analysis related work that requires managers to work with data. Microsoft Excel is one the most powerful yet very easy tool to use for data analysis. Some of the popular features of Microsoft Excel for data analysis are lookup, scenario manager, subtotal, advanced filter, conditional formatting, graphs, solver, what if analysis, pivot table, slicer, index and match and so on. It also provides 18 statistical analysis tools and 80 statistical functions.

This course has been especially designed for people who need to work with sorting and filtering data, importing and exporting data, and analyzing data. Managers, administrative staffs and analyst are highly recommended to take this training as it will be great help to them for their professional work. SMDI Advance Excel Training course also serves as an ideal platform for trainees appearing for excel certification examination and people aspiring to get professional qualification to enter into jobs.

• Professionals managers, accountants, analyst
• Administrative staffs of corporate organizations
• Students appearing for certification examination
• Researchers and student requiring statistical data evaluation and presentations.

Being an advance level course, this course obviously desires familiarity with basic knowledge about functions and operation in Microsoft Excel. A familiarity with basic computer operation is also required before enrolling in Advance Excel Training. However, this course is also self-sufficient for novice and intermediate Excel users.

1. Introduction of Excel

• What is excel
• About Basic terminology
• Differentiation between Number & Enter Keys
• Keyboard shortcuts –Basic &Advance User of Arrow & Enter Keys

2. Customizing the Excel Working Environment

3. Working with Data

4. Exploring Excel Database Feature

• Importing
• Sorting and filtering data
• Data Validation

5. Data Table

• Create a data table
• Feature of Nomenclature

6. Creating Dynamic List with Pivot Tables

7. Analyzing Alternative Data Sets

8. Page Setup and Printing

9. Collaborating With Colleagues

10. Functions & Formulas

• Operators (Arithmetic, comparison, text and reference operators)
• Calculation order and Operator Precedence
• Absolute and Relative reference
• Look Up & References Functions
• Math & Statistical Functions
• Text Functions
• Logical Functions
• Power Functions
• Date & Time Functions
• Watch window
• Calculation Options

11. Macros

• What is Visual Basic Editor, Developer Tab in Excel
• record Macro
• Write a sub in Macro

12. Errors

• Type of Error
• Reason of Error and Their Fixing