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
This 1 day, instructor led Excel Advanced and Google Sheets course builds on the concepts and skills of the Excel Introduction and Excel Intermediate courses to provide advanced tools for solving real-world problems in Microsoft Excel 2019. At the completion of this course, participants will be able to:
- Use functions to make decisions
- Find and trap errors, control formula options, and use array formulas and functions
- Perform calculations on dates, manipulate text, and use some statistical and financial functions
- Use Power Pivot and cube functions to access information in the Power Pivot Data Model, and export Excel worksheets to other formats
- Perform what-if analyses using a watch window, scenarios, and the Goal Seek utility
- Record and run macros, and create a simple form
- Discuss Advanced Google Sheets Functionalities
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.
Course Outline
Introduction
- Google Sheets and Excel Review
- Advacned Features
- Advanced Topics
Chapter 1: Logical and Lookup Functions
- Module A: Decision-making functions
- Module B: Lookup and reference functions
Chapter 2: Advanced Formulas
- Module A: Auditing and error-trapping
- Module B: Formula options
- Module C: Arrays
Chapter 3: Special functions
- Module A: Date and time functions
- Module B: Text functions
- Module C: Other functions
Chapter 4: Importing and Exporting
- Module A: The Power Pivot Data Model
- Module B: Exporting data
Chapter 5: Analysis
- Module A: What-if analysis
- Module B: The Analysis Toolpak
Chapter 6: Macros and Forms
- Module A: Recording macros
- Module B: Running macros
- Module C: Forms
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
