Advanced Microsoft Excel at Microsoft Overview
Duration | 1 day |
Mode of learning | Online |
Difficulty level | Advanced |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
- Entry Requirements
- + 1 more item
Advanced Microsoft Excel at Microsoft Highlights
- Earn a Certificate of Completion
- Lab Exercises after every module
Advanced Microsoft Excel at Microsoft Course details
- For Students who want to learn more advanced skills
- Create pivot tables and charts.
- Learn to trace precedents and dependents.
- Convert text and validate and consolidate data.
- Collaborate with others by protecting worksheets and workbooks.
- Create, use, edit, and manage macros.
- Import and export data.
- This Advanced Microsoft Excel 2019 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
Advanced Microsoft Excel at Microsoft Curriculum
Module 1: Using Pivot Tables
Creating Pivot Tables
More PivotTable Functionality
Inserting Slicers
Multi-Select Option in Slicers
PivotTable Enhancements
Working with Pivot Tables
Inserting Pivot Charts
More Pivot Table Functionality
Working with Pivot Tables
Module 2: Auditing Worksheets
Tracing Precedents
Tracing Dependents
Showing Formulas
Module 3: Data Tools
Converting Text to Columns
Linking to External Data
Controlling Calculation Options
Data Validation
Using Data Validation
Consolidating Data
Goal Seek
Using Goal Seek
Module 4: Working with Others
Protecting Worksheets and Workbooks
Password Protecting a Workbook
Password Protecting a Worksheet
Password Protecting Ranges in a Worksheet
Marking a Workbook as Final
Module 5: Recording and Using Macros
Recording Macros
Recording a Macro
Running Macros
Editing Macros
Adding Macros to the Quick Access Toolbar
Adding a Macro to the Quick Access Toolbar
Module 6: Random Useful Items
Sparklines
Inserting and Customizing Sparklines
Using Microsoft Translator
Preparing a Workbook for Internationalization and Accessibility
Importing and Exporting Files
Importing Text Files
Copying Data from Excel to Word
Copying Charts from Excel to Word
Module 7: Cloud
Using the Cloud.
Advanced Microsoft Excel at Microsoft Entry Requirements
- Prerequisites: Basic and Intermediate Excel experience.
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?