Loading...

Course Description

Updating data in an Excel worksheet is fast and easy. All you need to do is insert the new data and configure the sheet so that calculations are updated whenever the data changes. Storing your data in Excel also enables you to run reports on the data, perform calculations, print your work to share with others, and much more. In this course, you will use Microsoft ® Office Excel ® to create spreadsheets and workbooks that you can use to store, manipulate, and share your data. You will learn about auditing tools, how to perform what-if analysis and use Lookup functions. Level 3 is full of time-saving efficiency tools that will streamline your work in Excel.

See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."

Related Courses

Who Should Attend

This course was 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 Simultaneously

  • Using 3-D References in Formulas
  • Using Links and External References in Formulas
  • Consolidating Data Using the Consolidate command

Sharing and Protecting Workbooks

  • Collaborate on a workbook
  • Protect worksheets and workbooks

Automating Worksheet Functionality

  • Adding data validation criteria
  • Working with forms and controls
  • Creating and editing a basic macro

Applying Conditional Logic

  • Using Lookup Functions
  • Combining Functions
  • Using Formulas to apply Conditional Formatting

Auditing Worksheets

  • Tracing cells
  • Troubleshooting invalid data and formula errors
  • Watching and evaluating formulas

Using Automated Analysis Tools

  • Determining potential outcomes with Data Tables
  • Creating scenarios
  • Performing what-if analysis using Goal Seek and Solver

Presenting Your Data Visually

  • Using Advanced Chart Features
  • Creating Sparklines
Loading...

Enroll Now - Select a section to enroll in

Section Title
Excel Level 3
Type
In-Class
Days
W
Time
9:00AM to 4:30PM
Dates
Feb 19, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors
Section Title
Excel Level 3
Type
In-Class
Days
T
Time
9:00AM to 4:30PM
Dates
Apr 21, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Instructors