Build upon your skills from the intermediate class. Learn to work with and manage large spreadsheets, how to import data from other sources, how to export data, and how to record and modify simple macros to automate tasks. You'll also learn to create Scenarios to do what-if analysis, how to perform multi-criteria calculations, advanced lookup features, such as the Index and Match functions, and an introduction to Pivot tables. Course manual will be provided. The course will be taught using Office 2016. Prerequisite: Excel - Intermediate or a strong working knowledge of the topics covered in that class. This course is not required for the Microsoft Office Certificate. You must attend 90% of all scheduled class hours, in addition to completing any other requirements set by the instructor, in order to pass the class and be awarded CEUs and a Certificate of Completion.