Catalog

In this advanced Excel course, you will deepen your understanding and enhance your proficiency with Excel by building upon the foundational and intermediate knowledge acquired in the Microsoft Excel - Part 1 and Microsoft Excel - Part 2 courses. This course is designed to equip you with the skills needed to fully leverage Excel\'s capabilities, from collaborating seamlessly with colleagues to automating complex or repetitive tasks. You will also learn how to apply conditional logic to create and implement sophisticated formulas and functions, allowing you to maximize the efficiency and effectiveness of your data analysis efforts. By the end of this course, you will be able to perform advanced data analysis, collaborate effectively on workbooks with other users, and automate workbook functionality to streamline your workflow. Specifically, you will learn to work with multiple worksheets and workbooks, share and protect workbooks, use Lookup functions and formula auditing, forecast data, and create sparklines and map data, thereby enhancing your ability to extract valuable insights from your organization\'s data.

##### Module 1 - Working with Multiple Worksheets and Workbooks - Use Links and External References - Use 3-D References - Consolidate Data ##### Module 2 - Sharing and Protecting Workbooks - Collaborate on a Workbook - Protect Worksheets and Workbooks ##### Module 3 - Automating Workbook Functionality - Apply Data Validation - Search for Invalid Data and Formulas with Errors - Work with Macros ##### Module 4 - Using Lookup Functions and Formula Auditing - Use Lookup Functions - Trace Cells - Watch and Evaluate Formulas ##### Module 5 - Forecasting Data - Determine Potential Outcomes Using Data Tables - Determine Potential Outcomes Using Scenarios - Use the Goal Seek Feature - Forecast Data Trends ##### Module 6 - Creating Sparklines and Mapping Data - Create Sparklines - Map Data