Skip To Content

03/19/2024- 03/21/2024 Microsoft Excel 2019 Level 2-Intermediate

Ended Mar 21, 2024

Spots remaining: 6

Full course description

Online Learning with a Real Live Instructor
Join the online virtual classroom as easy as clicking a link. Look for an email notification from ICCE Canvas (Big Blue Button or MS Teams) to attend the course.

Time:     6:00pm- 9:30pm

Meeting Day:  Tuesday and Thursday

Dates: 03/19/2024- 03/21/2024

Note:  E-book versions will be provided by the instructor.

Description: Microsoft Excel 2019 Level 2-Intermediate is the second class of a three-part series. 

Excel 2019 Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel 2019: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.

NOTE: This course, and the next Advanced Level, map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2019. Objective coverage is marked throughout the course.

Students will benefit most from this course if they want to accomplish more analytical workplace tasks in Excel 2019, or if they want to have a solid foundation for continuing on to become an Excel Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course is a good place to start their preparation, but they will need to continue on to other courses in the series to be fully prepared for either exam.

Table of Contents

Chapter 1: Managing workbooks

Chapter 2: Named ranges

Chapter 3: Tables

  • Module A: Sorting
  • Module B: Filtering tables
  • Module C: Structured references
  • Module D: Validation
  • Module E: Transposing data

Chapter 4: Summarizing data

  • Module A: Consolidation
  • Module B: Subtotals

Chapter 5: PivotTables

  • Module A: Creating and formatting PivotTables
  • Module B: Manipulating PivotTables
  • Module C: Pivot Charts

Chapter 6: Presentation features

  • Module A: Conditional formats
  • Module B: Custom Formats
  • Module C: Graphics

Chapter 7: Advanced charts

  • Module A: Special chart types
  • Module B: Sparklines
  • Module C: Quick Analysis

Chapter 8: Collaboration

  • Module A: Permissions
  • Module B: Comments


Prerequisites: Be familiar with personal computers and basic knowledge of Excel.

Recommended course: Microsoft Excel 2019 Level 1-Beginner

Who should attend? 

Individuals who are thinking of learning the art of data science. Take this course if you are interested in the following career path: Data Analytics, Data Management, Database Administrator. This course is the foundation for Office professionals, small business owners and anyone with no excel skills and/or experience, or who wants to improve their Excel skills.


Career Pathway Next Steps: Certification and/or Courses to attend at ICCE@HCC:

  • Excel Level 3
  • MOS Excel Certification Bundle
  • MTA Certification for Python Programming
  • Microsoft Data Analyst Associate Certification

For more information contact IT Program Coordinator Liz Steacker at 813 259 6508 or email