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 LEXX LIVETraining 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
LEXX Live 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
Hubs