This course consists of 12 hands-on lessons that will help you master Microsoft Excel's most advanced features. You will learn how to use data analysis tools to improve your decision making and practice generating accurate data more quickly. You will discover how to work with the additional analysis tools provided by Excel add-ins and become skilled at protecting the integrity of your worksheets.You will also learn how to use data tables to perform what-if data analysis and discover advanced techniques for PivotTables. By course completion, you will have gained several advanced techniques to use when working with databases and PivotTables.
ed2go online courses are designed for working professionals and those seeking to gain personal advancement. If you are enrolled in a program, carefully review the requirements of your program before registering to ensure the course code and title match the requirements in your program.
Classroom Delivery: In-person instruction that takes place at a college campus.
Online Delivery: Content is delivered entirely online through self-directed components, allowing you the flexibility to learn anytime from wherever you are.
Remote Delivery: Technology-enabled virtual instruction that takes place outside of a physical classroom. Remote delivery includes some form of scheduled real-time virtual classes or drop-in times, as well as self-directed components.
Hybrid Delivery: Instruction that includes a combination of online or remote delivery, and some classroom activities.
Not all courses are offered each term.Spring 2021 registration opens February 1, 2021. Fall 2021 registration opens July 5, 2021.