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:00 PM to 9:30 PM
Meeting Day: Monday & Wednesday
Dates: 11/14/2022- 11/16/2022
Note: E-book versions will be provided by the instructor from Canvas to download.
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
- PCAP Certification for Python Programming
- Microsoft Data Analyst Associate Certification
For more information contact IT Program Coordinator Liz Steacker at 813 259 6508 or email firstname.lastname@example.org