Microsoft® Office Excel® 2013: Level 3

Course Description

Microsoft® Excel® Part 3 is for those experts whose work like revolves around spreadsheets and their functionality. Part 3 uses the foundation set in Parts 1 and 2 of Microsoft® Office Excel® 2013 to sharpen your Excel capabilities and experience. You will learn advanced collaboration functionalities, how to automate complex and repetitive tasks, and  how to develop elaborate formulas and functions by applying conditional logic. 

MS Excel® 2013 Part 2 covers key concepts of the Microsoft® Office Specialist (MOS) exam objectives to help you prepare for the Excel 2013, and Excel 2013 Expert Exams.

Course Objective:

Perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

Topics covered:

• Lesson 1: Work with multiple worksheets and workbooks simultaneously.
• Lesson 2: Share and protect workbooks.
• Lesson 3: Automate workbook functionality.
• Lesson 4: Apply conditional logic.
• Lesson 5: Audit worksheets.
• Lesson 6: Use automated analysis tools.
• Lesson 7: Present your data visually.

Target Student:

This course is designed for experienced Excel® users that need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel® functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

Prerequisites:

It will be helpful if you have completed Microsoft® Excel® 2013 part 1 or have the equivalent knowledge prior to taking this course.

Consider these courses to prepare you for this level of MS Excel® 2013. 

• MS Excel® 2013 Part 1
• MS Excel 2013 Part 2