Loading...

Course Description

Whether you need to crunch numbers for sales, inventory, IT, human resources, or another business unit, the ability to get the right information to the right people at the right time can create a powerful competitive advantage in a complex market environment.  This class builds upon the foundational Microsoft® Office Excel® 2019 knowledge and skills you have already acquired and provides instruction on creating advanced workbooks and worksheets that will deepen your organization’s business intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.  This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201 certifications.

Notice: In effect Feb. 15, students attending a class that is less than 30 hours long, will continue to need to provide proof of vaccination or a negative test that is no more than three days old to access campus. To get more information and see testing hours for each campus see: https://myccp.online/coronavirus#faqs.

Masking will be required throughout the spring/summer 2022 semester. Wearing a high-quality mask such as KN95 or N95 mask, or double masking, is strongly encouraged.  It is important to wear a mask that is well-fitted. For information on proper masking, including how to double mask, please read this guidance from the CDC: https://www.cdc.gov/coronavirus/2019-ncov/your-health/effective-masks.html.

Course Outline

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 & Time Functions

Topic E: Work with Text Functions

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

3: Analyzing Data

Topic A: Create and Modify Tables

Topic B: Apply Intermediate Conditional Formatting

Topic C: Apply Advanced Conditional Formatting

4: Visualizing Data with Charts

Topic A: Create Charts

Topic B: Modify and Format Charts

Topic C: Use Advanced Chart Features

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 completion of this workshop students will know how to:

· Work with functions.

· Work with lists.

· Analyze data.

· Visualize data with charts.

· Use PivotTables and PivotCharts.
 

Notes

Materials Required:

Handouts will be provided by the instructor.

Prerequisites

None.
Loading...
Enroll Now - Select a section to enroll in
Section Title
Microsoft Excel 2019 - Intermediate
Type
Lecture
Days
Sa
Time
9:00AM to 12:00PM
Dates
Oct 15, 2022 to Oct 22, 2022
Schedule and Location
Contact Hours
6.0
Location
  • Main
Delivery Options
Course Fee(s)
Tuition non-credit $179.00
Required fields are indicated by .