Adv MS Excel - AMT Skill Enhancement Institute LLP

New Batch starting: Electrical Automation– 27/02/2023 | Electronics Automation– 07/03/2023 | AC Motors and Drives– 13/03/2023 | Allen Bradely PLC– 21/03/2023 | Siemens PLC– 25/03/2023 | SCADA and HMI– 10/04/2023 | Digital Marketing– 20/03/2023

Advanced MS Excel

2 Days / 16 Hrs.
Call usWhatsapp

About Course

MS Excel

Advanced Excel courses offer skills that are available at a high level of proficiency with the software program- the Microsoft Excel spreadsheet.

It is mainly designed for Working Professionals and students to have high efficiency in managing and maintaining data. It is a necessary skill in today’s world. We provide live classes online as well as offline with Microsoft Certified Trainer.

Advanced Excel course offers students and working professionals lesser-known capabilities like pivot tables, lookup tables, pivot charts, and data validation and debugging features to ensure accuracy.

Course Objectives

Course Objectives :

  • Learn advanced formulae in MS Excel and use it effectively.
  • Understand the concepts like Pivot tables, Pivot charts, V-Lookup, H-Lookup.
  • Get accentuated to data validation and debugging features to ensure accuracy.

Course Requirements :

  • A young professional from any background who is interested in enhancing skills
  • Interested organizations/ institutes/ individuals who perform intensive data analysis which incorporates data from other systems

Course Details

1. Excel Quick Overview

2. Data linking

3. Protection of Workbook and Worksheet

4. Auto fill, Custom Link and Create Series

5. Formula and functions

6. Drop down and validation

7. Sort and filter

8. Conditional formatting

9. Pivot Table

10. Keyboard shortcuts

11. Charts

12. Text Functions

13. Paste special

14. Live Date

15. Advanced Sort and filter

16. Referencing

17. Lookup

18. Logical functions

19. Financial functions

20. Depreciation

21. Macro Introduction

Ready to build you Career with us ?

To enhance your skills
Call UsWhatsapp

KMS Pico