Information Technology

Excel 2016 - Part 3

Instructor-Led 6 Agenda

Description

Excel is a powerhouse spreadsheet software used by companies small and large. Master this popular platform by completing the Excel 2016 - Part 3 course from New Horizons. This advanced Excel course builds off learnings from Excel 2016 - Parts 1 & 2 and prepares you to complete difficult Excel tasks such as LOOKUPS, macros and more. The course also covers Microsoft Office Specialist exam objectives to help you prep for the certification exam.

Course Overview

Course Objective

Refer to internal and external worksheets
Perform LOOKUPs and audit formulas
Share and protect workbooks
Automate workbook functionality using validation rules and macros
Create sparklines and map data
Forecast data

Who Should Attend

If you’re proficient in Excel 2016 and looking to master more advanced features, this course is for you.

Working with Multiple Worksheets & Workbooks Lesson Id 1

Working with Multiple Worksheets & Workbooks

Using Lookup Formulas and Formula Auditing Lesson Id 2

Using Lookup Formulas and Formula Auditing

Sharing and Protecting Workbooks Lesson Id 3

Sharing and Protecting Workbooks

Automating Workbook Functionality Lesson Id 4

Automating Workbook Functionality

Creating Sparklines and Mapping Data Lesson Id 5

Creating Sparklines and Mapping Data

Forecasting Data Lesson Id 6

Forecasting Data

Lesson Id	Title	Description
1	Working with Multiple Worksheets & Workbooks	Reference Cells and Groups of Cells Across Worksheets<br />Link Cells to External Worksheets<br />Consolidate Data Across Worksheets<br />
2	Using Lookup Formulas and Formula Auditing	Search Rows or Columns Using LOOKUP Functions<br />Display Relationships Between Cells and Formulas with the Trace Command<br />Watch Cells and Formulas From the Watch Tool<br />
3	Sharing and Protecting Workbooks	Collaborate on Workbooks<br />Apply Varying Levels of Workbook Access and Protections<br />
4	Automating Workbook Functionality	Create and Manage Validation Rules and Lists<br />Search for Invalid Data and Formulas with Errors<br />Record Macros to Automate Tasks<br />
5	Creating Sparklines and Mapping Data	Create Sparklines to Show Trends<br />Map Data<br />
6	Forecasting Data	Determine Potential Outcomes Using Data Tables and Scenarios<br />Solve for Desired Outputs with the Goal Seek Feature<br />Forecast Data Trends<br />