BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Course Overview
Microsoft Excel 2021/365 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 Excel: 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. Students will benefit most from this course if they want to use Excel to perform real-world tasks such as rearranging and presenting complex data.
Schedule
Currently, there are no public classes scheduled. Please contact a Phoenix TS Training Consultant to discuss hosting a private class at 301-258-8200.
Duration
1 day/8 hours
Program Level
Intermediate
Prerequisites
The course assumes students know how to use a computer, that they’re familiar with Microsoft Windows, and that they’ve taken the Level 1 course or have equivalent introductory experience with Excel.
Course Outline
Introduction
Chapter 1: Managing workbooks
- Module A: Managing worksheets
- Module B: Customizing Excel
Chapter 2: Named ranges
- Module A: Using names in formulas
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: PivotCharts
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
BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Phoenix TS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints re-garding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org
![[GSA LOGO]](http://13.64.56.230/wp-content/themes/phoenixts-com/assets/images/gsa-logo-black.png){kind=logo}
