This Advanced Microsoft Excel training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Create, use, edit, and manage macros.
Our Approach:
Students are at the top of our priority list and we always make sure that every student is given the best training possible. In order to provide the best training, all our training modes have been made interactive sessions. Out of all the 4 training modes, the students are given an opportunity to choose a mode of training depending on their requirements. Different training methods have been introduced for individuals as well as for corporates. Unlike most of the online trainings today, Our Online trainings are interactive sessions and are similar to our classroom trainings. The student will be connecting to our Live virtual classroom where they will be able interact with the trainer.
We provide one of the best professional trainings within SAP in the industry. The courses are run by experts with ample industry experience on this subject matter. The course run are well up to professional standards with the latest industry updates. Contact our team at Vesta for all your queries.
Course Objectives:
By the end of this training you will:
- Understand the core concepts of Advanced Excel module.
- Be able to apply the knowledge learned to progress in your career as an Developer.
Prerequisites:
Essential:
Knowledge of Basic Typewriting and Computer Knowledge.
Duration: 32 Hours
Course Preview:
- Module 01 : Grouping & Outlining and Subtotals
- Module 02 : What-If Analysis
- Module 03 : Pivot Tables
- Module 04 : Charting Pivoted Data
- Module 05 : Advanced Excel Tasks
- Module 06 : Creating HLOOKUP and VLOOKUP Functions
- Module 07 : Introduction to Macros in Excel