Loading...

Course Description


This course builds upon basic knowledge and skills imparted in the Level 1 course, and sets you on the road to creating advanced workbooks and worksheets that will deepen your firm's business intelligence. 

Learn to wow your audience by mastering advanced formulas, performing timely data manipulation and analysis, and creating dazzling charts and graphs. Finally, you will customize how Excel behaves to more closely meet your needs.

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

Related Courses

Other Courses

Who Should Attend

This course is designed for individuals who already have foundational knowledge and skills in Excel and are ready to advance their data analysis skills and abilities through the application of advanced Excel techniques such as advanced formula creation, tables, charts, PivotTables and PivotCharts.

Attend and You Will Receive

Upon successful completion of this course, you will receive a certificate of completion from NC State University.

Prerequisites

Prior to taking this course, you should have equivalent knowledge of Excel level 1. This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, and PivotTables and PivotCharts for analyzing data. Before starting this course, it is recommended that you take Microsoft ®  Office Excel ® Level 1.

Attend and You Will Learn / Expected Outcome

Expected Outcomes

In this course, you will learn to create advanced formulas and analyze data with statistical and logical functions. You will also learn to organize worksheet data with tables, and sort and filter to extract pertinent information. The ability to analyze summary data through PivotTables and charts will assist you in making effective decisions.

 

Attend And You Will Learn

Customizing the Excel Environment

  • Configuring Excel Options
  • Customizing the ribbon and quick access toolbar
  • Enabling Excel add-ins

Calculating Data with Advanced Formulas

  • Applying cell and range names
  • Using specialized functions

Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Organizing Worksheet Data with Tables

  • Creating and modifying tables
  • Sorting and filtering data
  • Using summary and database functions to calculate data

Visualizing Data with Charts

  • Creating a chart
  • Modifying and formatting charts

Analyzing Data Using PivotTables, Slicers, and PivotCharts

  • Creating a PivotTable
  • Filtering data by using slicers
  • Analyzing data using PivotCharts

Instructors

Loading...

Enroll Now - Select a section to enroll in

Section Title
Excel Level 2
Type
In-Class
Days
W
Time
9:00AM to 4:30PM
Dates
Feb 12, 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 2
Type
In-Class
Days
W
Time
9:00AM to 4:30PM
Dates
Mar 18, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00
Section Title
Excel Level 2
Type
In-Class
Days
T
Time
9:00AM to 4:30PM
Dates
Apr 14, 2020
Schedule and Location
Contact Hours
6.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $345.00