Microsoft Excel Level 3: Advanced Skills

Microsoft Excel Level 3: Advanced Skills - COMP 200

Use Excel to manage, share and present data at work or home. Learn to work with multiple worksheets and workbooks, use lookup functions and formula auditing, share and protect workbooks, automate functionality, create sparklines and forecast data. This course is intended for individuals who have significant experience with Microsoft Excel and are interested in advancing their skills and efficiency in this software application.

Upon completion of this program, students will:

Create and use pivot tables and pivot charts for data summarization and analysis
Utilize lookup functions and nested IF formulas for complex calculations
Work with and consolidate data from multiple workbooks