This Advanced Microsoft Excel 2013 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
This course is intended for students who have intermediate skills with Microsoft Excel 2013 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2013 interface.
At course completion
Using Pivot Tables
This is module explains how to work with pivot tables.
Lab : Using Pivot Tables
This module explains how to audit worksheets.
Lab : Auditing Worksheets
Data Tools in Microsoft Excel are simply tools which make it easy to manipulate data. Some of them are intended to save you time by extracting or joining data and others perform complex calculations. This lesson covers the most commonly used Data Tools.
Lab : Data Tools
Working With Others
This module explains how to use features that are useful when sharing and working with others.
Lab : Working With Others
Recording and Using Macros
As you work with Excel, you may find that you repeat certain operations frequently. Instead of performing each step of the operation, you can create a macro that stores these steps. You can then run the macro, or let Excel perform the steps for you, saving you both time and effort.
Lab : Recording and Using Macros
Random Useful Items
This module explains how to use some useful tricks and tools in Excel.
Lab : Random Useful Items
Microsoft Excel 2013 New Features
This module explains how to use some new features to help you efficiently and effectively create and edit workbooks.
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