
Online Mastering Microsoft Excel for Office 365 Level 200
Upgrade your ability to analyze data using the analytical features and extensions of Excel with this intermediate-level video set. containing all-new and updated content for understanding the finer points of Excel. Written, created and presented by a Certified Microsoft Office Specialist Master, you’re guaranteed to get the highest-quality insight into exploiting more Excel secrets than ever before.
The videos are ideal for users who are challenged with managing and analyzing substantial amounts of data. Going beyond typical theoretical data management classes or tutorials, Level 200 provides a deeper knowledge of analysis by building charts and forecasts using Excel’s collection of data analysis tools.
The video series offers exclusive insights for data analysis and the powerful SQL Server Data Mining add-in. Level 200 is ideal for professionals in analytical roles. We would advise you to take the Level 100 course first, and you should also be comfortable with functions and chart building.
Course Outcomes
- Provides a thorough understanding of consolidating data, combination charts, 3-D maps, Gantt charts and gauge charts
- Allows users to practice and learn non-VBA form controls and Excel add-ons, including the Data Analysis ToolPak and the Solver
- Introduces learners to the SQL Server Data Mining add-in for Excel and its use of various data mining algorithms
- Brings users up to speed with the latest version of Excel, enabling them to take advantage of new solutions for data management
- Prepares users for Excel Level 300 training
- Draws on adult learning theories to relate Excel features to everyday business needs
On-Demand Training
More Courses in