Description
After completing this course, students will know how 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
For more information or to register, go to https://aaimea.org/courses/microsoft-excel-advanced/