Loading...

Course Description

Learn to mine critical information from your raw data. This course covers the more sophisticated functions in Excel needed to analyze and present data. You will work with functions and lists and analyze data. Learn how to develop PivotTables and PivotCharts to present data in an organized manner. Workbook included.

Course Outline

Lesson 1: Working with Functions

 Topic A: Work with Ranges

 Topic B: Use Specialized Functions

 Topic C: Work with Logical Functions

 Topic D: Work with Date and Time Functions

 Topic E: Work with Text Functions

Lesson 2: Working with Lists

 Topic A: Sort Data

 Topic B: Filter Data

 Topic C: Query Data with Database Functions

 Topic D: Outline and Subtotal Data

Lesson 3: Analyzing Data

 Topic A: Create and Modify Tables

 Topic B: Apply Intermediate Conditional Formatting

 Topic C: Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

 Topic A: Create Charts

 Topic B: Modify and Format Charts

 Topic C: Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

 Topic A: Create a PivotTable

 Topic B: Analyze PivotTable Data

 Topic C: Present Data with PivotCharts

 Topic D: Filter Data by Using Timelines and Slicers

Learner Outcomes

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:

  • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Use PivotTables and PivotCharts.

Prerequisites

Knowledge of Excel Level 1 or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Excel 2019 Level 2
Type
Online
Days
Th
Time
6:30PM to 9:30PM
Dates
Apr 06, 2023 to Apr 20, 2023
Schedule and Location
Contact Hours
9.0
Course Fee(s)
Course Fee non-credit $191.00
Drop Request Deadline
Mar 30, 2023
Transfer Request Deadline
Mar 30, 2023
Section Title
Excel 2019 Level 2
Type
Lecture
Days
Sa
Time
9:00AM to 12:00PM
Dates
Jun 10, 2023 to Jun 24, 2023
Schedule and Location
Contact Hours
9.0
Course Fee(s)
Course Fee non-credit $191.00
Drop Request Deadline
Jun 03, 2023
Transfer Request Deadline
Jun 03, 2023
Instructors
Required fields are indicated by .