COURSE CODE : ADV XLS
COURSE : ADVANCED EXCEL
-DESCRIPTION​
This course offers comprehensive training in Microsoft Excel, tailored for individuals looking to advance their data management skills. Participants will delve into advanced functionalities such as data analysis techniques, the use of pivot tables, macros, and automation tools, enabling them to handle complex data sets efficiently. This course is essential for professionals aiming to enhance their analytical capabilities and improve their employability in data-driven roles.
​​​​
-DURATION
-
Theory and Practical Duration – 03 Months​
-
2 Hours Class (Monday - Friday)
​
-FEES
-
₹1,780 (inclusive of GST)
​​
-CURRICULUM
-
Advanced Formulas
-
Data Analysis and Tools
-
Data Validation
-
Conditional Formatting
-
Charts and Graphs
-
Macros and VBA (Visual Basic for Applications)
-
Advanced Data Management
-
Advanced Charting Techniques
-
Database Functions
-
Collaborative Features
-
File Protection and Security
-
Using External Data
​​
​
-COURSE OUTCOMES
After completing this course, participants will be able to:​
-
Mastery of Advanced Formulas and Functions
-
Data Validation and Conditional Formatting Proficiency
-
Ability to Create and Analyze Pivot Tables and Charts
-
Advanced Charting and Visualization Skills
-
Competency in Data Analysis Tools
-
Automation through Macros and Basic VBA
-
Data Modeling and Power Pivot Proficiency
-
Advanced Lookup and Reference Techniques
-
Understanding of Data Protection and Collaboration
-
Ability to Integrate Excel with Other Applications