Course Detail: CMP718 - Microsoft Excel 2021: Part 3
This course builds upon the foundational and intermediate knowledge presented in the Microsoft Office Excel Beginner and Intermediate courses. It will provide you the ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions. Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Prerequisite: MS Excel: Part 2 or functional knowledge of basic Excel.
- Work with multiple worksheets and workbooks
- Share and protect workbooks
- Automate workbook functionality
- Use Lookup functions and formula auditing
- Forecast data
- Create sparklines and map data
Attendance Policy: Students must attend all three (3) live sessions to receive the course certificate.
Instructor Todd Raines is the IT Training Coordinator at Purdue University Fort Wayne. Raines is the recipient of the University Continuing Education Association (UCEA) Mid-America Region Excellence in Teaching and Faculty Service Award.