Prerequisites

The learners are expected to be familiar with concepts covered in MS Excel Level 1.

Who Should Attend

This course is intended for participants who are familiar with Microsoft Excel 2016.

What You’ll Learn

Upon completion of the course, participants will be able to accomplish the following:

• Organize, protect, and display data using various tools
• Use the IF function
• Create linking formulas, and manage links
• Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and consolidate data from multiple sources
• Create and modify charts to present data effectively
• Customize charts to enhance their appearance
• Create, apply and modify styles to format worksheets consistently and quickly
• Use comments, text boxes sparklines to annotate worksheets and highlight and explain data

Course Materials and Fees

Course materials will be provided to each learner. Required Software: MS Excel 2016 or MS Excel 2019 required (not included with course materials). MS Excel 2013 or earlier not supported. This course does not support Mac computers.

Additional Notes

Microsoft Learn for Educators (MSLE) Member

Contact