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.
- 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
SQL TRAINING COURSE CAN BE TAKEN UP BY:
Students & Freshers : For those who wants to start their career with top MNCs. By upgrading yourself with Advance Excel skills, you will find huge career opportunities.
Working Professionals : Who are not satisfied with their current profile & wants to boost their career with the latest technology.
Business Owners : Who wants to create their own business dashboards and analyze business performance.
- Lectures 17
- Quizzes 0
- Duration 30 hours
- Skill level All levels
- Language English
- Students 15
- Assessments Self