Loading...

Course Description

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.

Prerequisites

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

Expected Outcomes

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

Forecasting Data

  • Determine the potential outcomes using data tables
  • Determine potential outcomes using scenarios
  • Use the goal seek feature
  • Forecasting data trends

 

Loading...

Enroll Now - Select a section to enroll in

Section Title
Excel Level 3
Type
Online
Days
T
Time
9:00AM to 4:30PM
Dates
Aug 18, 2020
Schedule and Location
Contact Hours
6.0
Location
  • Off Campus
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors
Section Title
Excel Level 3
Type
Online
Days
W
Time
9:00AM to 4:30PM
Dates
Oct 28, 2020
Schedule and Location
Contact Hours
6.0
Location
  • Off Campus
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Section Title
Excel Level 3
Type
In-Class
Days
M
Time
9:00AM to 4:30PM
Dates
Dec 07, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00