Excel 365 Advanced

---

Course Overview

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will:

Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data.

Duration: 1 day course

---

Course Content

Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
Consolidate Data

Sharing and Protecting Workbooks
Collaborate on a Workbook
Protect Worksheets and Workbooks

Automating Workbook Functionality
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros

Using Lookup Functions and Formula Auditing
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas

Forecasting Data
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecast Data Trends

Email us about this courses


Telephone on 01952 938014