This course builds on the basic and intermediate knowledge presented in the Excel 2016 Part 1 and Part 2 courses. You will learn about auditing tools, what-if analysis tools and Lookup functions. Analyze data with sparklines, 3-D maps and forecast sheets. Additionally, you will create basic macros, share and protect workbooks, consolidate multiple data sources, and use linking formulas.
See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."
Who Should Attend
This course is designed for students desiring to gain the skills necessary to create basic macros, collaborate with others, audit and analyze worksheet data, consolidate multiple data sources, and use linking formulas and Lookup functions.
Attend and You Will Receive
Upon successful completion of this course, you will receive a certificate of completion from NC State University.
To ensure your success, you will need to have a comfort level with the basic skills of Excel like entering data, working with data, using functions, and working with formulas.
Attend and You Will Learn / Expected Outcome
In this course, you will learn to automate worksheet functionality, analyze, and present data and audit worksheets; you will also learn how to work with multiple worksheets and import and export data.
Attend and You Will Learn
Working with Multiple Worksheets and Workbooks
- Using Links and external references
- Using 3-D references
- Consolidating data
Using Lookup Functions and Formula Auditing
- Using lookup functions
- Trace cells
- Watch and evaluate formulas
Sharing and Protecting Workbooks
- Collaborate on a workbook
- Protect worksheets and workbooks
Automating Worksheet Functionality
- Apply data validation
- Search for invalid data and formulas with errors
- Work with Macros
Creating Sparklines and Mapping Data
- Create sparklines
- Map data
- Determine the potential outcomes using data tables
- Determine potential outcomes using scenarios
- Use the goal seek feature
- Forecasting data trends