Microsoft Excel Level 2

Course ID: 
NIHTC7006
Description: 

EXCEL is a great tool for turning complex information into more simple snapshots to inform your stakeholders, as well as organize your data. This course is meant for those who want to gain advanced skill sets necessary to work with functions and lists, analyze data, and use PivotTables and PivotCharts.
Upon course completion you will be able to create advanced workbooks and worksheets that provide a more in-depth understanding of organizational intelligence. The end goal of this course is for students to be able to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers at a high level.

Key Topics: 

Lesson 1: Using Page Setup
Lesson 2: Using Other Functions
Lesson 3: Using Conditional and Custom Formats
Lesson 4: Using AutoFilter
Lesson 5: Working with Tables
Lesson 6: Using Large Worksheets
Lesson 7: Working with Multiple Worksheets
Lesson 8: Managing Worksheets
Lesson 9: Using Range Names
Lesson 10: Creating Charts

Online Course Requirements:

You need two screens; one for exercises, one for virtual classroom. You need Microsoft Excel installed on your computer. Complete an online orientation prior to class (orientation instructions are emailed after registration approval). You should have basic computer knowledge. Registration will close two weeks prior to the start date to allow for online orientation completion.

Course Offerings
Start Date End Date Location Cancellation Deadline IC Price Register
Tue, 11/19/19, 9:00am Tue, 11/19/19, 4:30pm Building 45 - Natcher Conference Center 45 Center Drive - Room 1013 (NCC) Tue, 11/05/19 $285
Thu, 12/12/19, 9:00am Thu, 12/12/19, 4:30pm Building 45 - Natcher Conference Center 45 Center Drive - Room 1013 (NCC) Thu, 11/28/19 $285