Course Key Features
-
2 days of instructor led classroom training over weekend
-
100+ Excel Features covered
-
Completely hands-on Training (100% Practical Training)
-
Certificate on completion of Training
-
Soft copy of training manual
-
Highly experienced trainers (>15 years’ work experience) who teach with live examples
Download Course Content
Quick Views
Certificate Course in “Advance Excel”
Introduction
MS Excel is one of the most prolific tools being used by most of the businesses around the world. 80% of jobs require Excel skills today. Excel knowledge is a mandatory requirement in almost all professions.
When it comes to data crunching and analysis, it is one of the most popular and easy tools used in the market by the people. Nowadays, most people know about and use Excel in their day to day work though they might be only using its basic functionalities. It is sufficient up to a certain point but if you need to grow ahead in your career then you need to not only know about the advanced functions that Excel provides but be an expert at the same. You can create impressive visuals, charts, graphs and dashboards using advanced excel course. You can extract meaningful information from a dataset using the formulae available with Excel.
Who can attend?
- Anyone interested in mastering MS Excel
- 10th Standard and above
- Graduates
- Working Professionals
Duration: Two Days (16 hours of Training)
Timings: 9 am to 5 pm
Certificate: “Certified Advance Excel Professional” on completion of Training Program
List of leading Blogs and books on Excel will be provided to the participants
Course Outline
Section 1:
Introduction of MS Excel
- Excel Environment (ribbon, tab layout, tool bar, help, office button, File menu)
- Calculations in Excel (Basic Formulas & Advanced Formulas like IF, Nested IF, Statistical Functions, CountIF, SumIF)
- Calculations in Excel (Absolute/Relative/Sheet Reference/Date Functions)
- Linking between Excel files and Data, Chart preparations in Excel with detailed features
Section 2
Advanced functions of MS Excel
- Home tab options (Advanced Formatting, Paste Special)
- Specialized effects like Conditional Formatting, Videos, Pictures, Graphics, Setup with Advanced Options
- Financial Calculations (IRR, CAGR, Compound Interest, NPV, Running Balance, % calculations)
- Formula Tab options with Auditing, Data tools in Excel
- Advanced Security options from Review and View Tabs
Section 3
Advanced Data Analysis functions of MS Excel
- Sort, Applying Filters, Subtotal, Validation, Consolidation
- PIVOT Table and Data Analysis using options of Pivot Table
- V-Lookup, H-Lookup and its uses in Industry
- Advance Functions like Time based calculations, Mathematical, Text Based Features, Concatenate
- Handling large set of data using data operations like Advanced Filters
- MIS Reporting Analysis Options
- Anyone interested in mastering MS Excel
- 10th Standard and above
- Graduates
- Working Professionals
The duration is 2 days i.e. total 16 hours.
Our core purpose is to train candidates and impart knowledge, so post training you will get connected with Trainer and institute whenever you need.
You can also attend the Advanced Excel Training Program as many times you wish till you feel that you have understood the concepts.
You can attend the same session again in our next training session or any other session as per your conveyance.
You need to inform the institute and we will provide the same with a minimal cost.
We use a Socratic method for training that involves a 100% hands-on workshop.
Extra Benefits
All alumni will be able to attend any future batch for the respective training program attended with prior intimation of 10 days.
No extra fees will be charged for attending the same program again.
Participants can get all their queries solved on the mail / Phone after attending the program.
Life time support for all participants
List of leading Blogs and books on Excel will be provided to the participants
Click on Register Now tab on the home page for Registration Form.