Put the full power of Excel right at your fingertips, and get the answers you need from the vast amounts of data your organization generates. Topics include lookup and decision-making functions; auditing and error-handling; array functions; special functions such as date, time and text functions; importing and exporting; what-if-analysis; automating repetitive tasks by recording and running macros; and forms.
Textbook included.
Prerequisites: Successful completion of Microsoft Excel 2019 Level 2 or the ability to manage complex workbooks; build complex functions, use data analysis tools like PivotTables and PivotCharts and leverage presentation features. Microsoft Windows proficiency.
For more information, please refer to our course outline.
This class is also part of the Microsoft Excel 2019 Series, which includes Levels 1, 2 and 3 at a discounted rate.