Advanced Excel Training
Spread Sheets are one of the simple and widely used applications where information is gathered, analyzed and exchanged. In our day to day life, we spend a lot of time processing the information in spreadsheets. Microsoft Excel is one of the powerful tools which has various inbuilt Features and Functions which helps in analyzing the data on a real time. The Understanding and usage of these capabilities will help a user to comprehend the information and report information quickly and take advantage of the advanced capabilities provided in the Tool.
ADVANCE EXCEL COURSE DETAILS
- Shortcut keys (50+)
- Importing data from different source like Access, XML, Text, SQL Server
- Handling more then 100+ Formula’s and their combinations
- Advanced Pivot tables
- Static and Dynamic Charts
- Data Validation techniques
- WhatIf Analysis using Scenario Manager, Goal Seek & Data Table
- Misc Excel Option like protecting sheet, Track Changes, Page setup for printing etc
- Basic of VBA Macros
ADVANCE EXCEL COURSE CAN BE TAKEN UP BY:
Students & Freshers : For those who wants to start their career and expand and enhance their working knowledge of Excel and utilize the most of its many sophisticated features and functions.
Working Professionals : Those who wants to boost their career and seeking proficiency in the use of Microsoft Excel 2013 at an advanced level.
Business Owners : A small business owners who want to create their own business dashboards and analyze business performance by themselves.
- Lectures 0
- Quizzes 0
- Duration 55 hours
- Skill level All level
- Language English
- Students 27
- Assessments Self