Course Description
In this expert course, you will get to know especially helpful features, such as collaborative editing of workbooks and management of more complex Excel documents, through the implementation of tools such as formula tracking and reference functions. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips.
Prerequisites
• The knowledge taught in the course Microsoft 365 – Learn, Understand and Use Basic Functions and Concepts or comparable practical experience is helpful to follow the content shown in this training more easily
• This course builds upon the foundational knowledge presented in the courses Microsoft Excel – Part 1 and Microsoft Excel – Part 2
Target Audience
This course is suitable for you, if
• you need to troubleshoot large, complex workbooks
• you wish to automate repetitive tasks
• you need to construct complex Excel functions and use those functions to perform rigorous analysis of extensive, complex datasets
Course Objectives
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
• Work with multiple worksheets and workbooks
• Use Lookup functions and formula auditing
• Share and protect workbooks
• Automate workbook functionality
• Create sparklines and map data
• Forecast data
Send a Message.
-
- Learning Format: ILT
- Duration: 80 Hours
- Training Level : Beginner
- Jan 29th : 8:00 - 10:00 AM (Weekend Batch)
- Price : INR 25000
- Learning Format: VILT
- Duration: 50 Hours
- Training Level : Beginner
- Validity Period : 3 Months
- Price : INR 6000
- Learning Format: Blended Learning (Highly Interactive Self-Paced Courses +Practice Lab+VILT+Career Assistance)
- Duration: 160 Hours 50 Hours Self-paced courses+80 Hours of Boot Camp+20 Hours of Interview Assisstance
- Training Level : Beginner
- Validity Period : 6 Months
- Jan 29th : 8:00 - 10:00 AM (Weekend Batch)
- Price : INR 6000
This is id #d