This Intermediate Microsoft Excel 2013 training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles. This course helps prepare students to take the MOS: Microsoft Office Excel 2013 certification exam 420.
Students who have basic skills with Microsoft Excel 2013 who want to learn intermediate-level skills or students who want to learn the topics covered in this course in the 2013 interface.
At course completion
This module explains how to work with advanced formulas in Excel.
Lab : Advanced Formulas
Working with Lists
This module explains how to work with lists in Microsoft Excel 2013.
Lab : Working with Lists
Working with Illustrations
Adding illustrations to Microsoft Excel worksheets is a great way to improve their look and feel, and also to illustrate your points. Fortunately, it’s easy to add pictures (your own or choose from a large library of pictures provided by Microsoft) and shapes.
Lab : Working with Illustrations
Visualizing Your Data
This module explains how to use techniques for visualizing your data.
Lab : Visualizing Your Data
Working with Tables
This Working with tables in Excel 2013 can help you organize your data. In Excel, you can group data together into a table and then manipulate that table.
Lab : Working with Tables
This module explains how to use advanced formatting techniques in Excel 2013.
Lab : Advanced Formatting
Microsoft Excel 2013 New Features
Excel 2013 provides a number of new functions and tools to help make working with worksheets easier and more efficient.
Lab : Microsoft Excel 2013 New Features
Microsoft Power Platform App Maker
Designing & Implementing Azure AI Solution
Microsoft Azure Administrator
Developing Solutions For Microsoft Azure
Microsoft Azure Architect Design Exam
Implementing Azure Data Solution
Administering Relational Databases On Microsoft Azure