This course builds on your prior knowledge in Excel and provides you with advanced tools for solving real-world problems.

Performance Objectives: Upon completion of this course, you should be able to:

• Work with multiple worksheets and workbooks.
• Use lookup functions, trace cells, evaluate function, and watch windows.
• Share and collaborate on workbooks.
• Protect worksheets and workbooks.
• Use data validation.
• Create basic macros.
• Visualize data with sparklines and maps.
• Forecast data.

Prerequisites: We recommend you complete Excel 2016-2019 Level 1 and Level 2 or have equivalent experience before registering for this class.

Intended Audience: All audiences.