If you are an experienced Excel user who wants to build on knowledge and skills, this course is for you. This course will build on your prior knowledge in Excel and will provide advanced tools for solving real-world problems.

Performance Objectives: Upon successful 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.

Competencies Covered in the course: Advanced Excel skills to include charts, pivot tables, and analysis tools.

Intended Audience: Anyone required to use advanced formulas and reporting skills in their work.

Recommended Prerequisites: Completion of the Microsoft Excel 2016 Level 1 & 2 courses or equivalent knowledge and experience is strongly recommended.