EDG104 - Advanced Microsoft Excel 2016
Course Description
Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed Microsoft Excel training, you'll see how to truly maximize this program's functions and capabilities. After all, most organizations rely heavily on Excel to consolidate, analyze, and report data and want their employees to be proficient in this important program. This Excel training class gives you the skills you need to impress your current or future employer—and its online format means you can take this class from anywhere, at any time.
With exercises, quizzes, and all the latest information, the best online Excel training is right here in this course. The lessons will simplify some of those tricky Excel concepts that might seem hard to grasp, so you can discover how Excel 2016 table tools actually take the complexity out of spreadsheet creation and management. When you've completed this course, you'll be able to accomplish just about everything Microsoft Excel has to offer in displaying, analyzing, reporting, and tracking data—and you'll understand it so well, you'll even be able to share your newfound skills with your friends and colleagues.
Course Outline
- Customizing Excel
- Data Validation
- Custom Controls
- Conditional Formatting
- Consolidating and Outlining
- Excel Functions and Nesting
- Import External Data
- Friday
- Data Tables
- What-If Analysis Tools
- Advanced PivotTables
- Analysis ToolPak, Advanced Filter, Array Formulas, and More
Notes
A new session of each course starts monthly. If enrolling in a series of two or more courses, please be sure to space the start date for each course at least two months apart.
All courses run for six weeks, with a two-week grace period at the end. Two lessons are released each week for the six-week duration of the course. You do not have to be present when lessons are released. You will have access to all lessons until the course ends. However, the interactive discussion area that accompanies each lesson will automatically close two weeks after the lesson is released. As such, we strongly recommend that you complete each lesson within two weeks of its release.
The final exam will be released on the same day as the last lesson. Once the final exam has been released, you will have two weeks to complete all of your course work, including the final exam.