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