Overview:
This Advanced Microsoft Excel 2019 training class is designed for participants 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 using Excel 2019 or Excel 365.
Audience:
participants who have intermediate skills with Microsoft Excel 2019 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2019 interface.
Pre-Requisites:
Experience in the following is required for this Microsoft Excel class:
- Basic and Intermediate Excel experience.
Objectives:
- 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.
Course Curriculum
| Using Pivot Tables | |||
| Creating Pivot Tables Details | 00:00:00 | ||
| Preparing Your Data Details | 00:00:00 | ||
| Inserting a Pivot Table Details | 00:00:00 | ||
| Creating a PivotTable Timeline Details | 00:00:00 | ||
| More PivotTable Functionality Details | 00:00:00 | ||
| Inserting Slicers Details | 00:00:00 | ||
| Multi-Select Option in Slicers Details | 00:00:00 | ||
| PivotTable Enhancements Details | 00:00:00 | ||
| Working with Pivot Tables Details | 00:00:00 | ||
| Grouping Data Details | 00:00:00 | ||
| Using PowerPivot Details | 00:00:00 | ||
| Managing Relationships Details | 00:00:00 | ||
| Inserting Pivot Charts Details | 00:00:00 | ||
| More Pivot Table Functionality Details | 00:00:00 | ||
| Creating a Standalone PivotChart Details | 00:00:00 | ||
| Exercise: Working with Pivot Tables Details | 00:00:00 | ||
| Auditing Worksheets | |||
| Tracing Precedents Details | 00:00:00 | ||
| Exercise: Tracing Precedents Details | 00:00:00 | ||
| Tracing Dependents Details | 00:00:00 | ||
| Exercise: Tracing Dependents Details | 00:00:00 | ||
| Showing Formulas Details | 00:00:00 | ||
| Data Tools | |||
| Converting Text to Columns Details | 00:00:00 | ||
| Exercise: Converting Text to Columns Details | 00:00:00 | ||
| Linking to External Data Details | 00:00:00 | ||
| Controlling Calculation Options Details | 00:00:00 | ||
| Data Validation Details | 00:00:00 | ||
| Exercise: Using Data Validation Details | 00:00:00 | ||
| Consolidating Data Details | 00:00:00 | ||
| Exercise: Consolidating Data Details | 00:00:00 | ||
| Goal Seek Details | 00:00:00 | ||
| Exercise: Using Goal Seek Details | 00:00:00 | ||
| Working with Others | |||
| Protecting Worksheets and Workbooks Details | 00:00:00 | ||
| Password Protecting a Workbook Details | 00:00:00 | ||
| Removing Workbook Metadata Details | 00:00:00 | ||
| Restoring Previous Versions Details | 00:00:00 | ||
| Exercise: Password Protecting a Workbook Details | 00:00:00 | ||
| Password Protecting Ranges in a Worksheet Details | 00:00:00 | ||
| Exercise: Password Protecting Ranges in a Worksheet Details | 00:00:00 | ||
| Password Protecting Ranges in a Worksheet Details | 00:00:00 | ||
| Exercise: Password Protecting Ranges in a Worksheet Details | 00:00:00 | ||
| Marking a Workbook as Final Details | 00:00:00 | ||
| Recording and Using Macros | |||
| Recording Macros Details | 00:00:00 | ||
| Copy a Macro from Workbook to Workbook Details | 00:00:00 | ||
| Exercise: Recording a Macro Details | 00:00:00 | ||
| Editing Macros Details | 00:00:00 | ||
| Adding Macros to the Quick Access Toolbar Details | 00:00:00 | ||
| Managing Macro Security Details | 00:00:00 | ||
| Exercise: Adding a Macro to the Quick Access Toolbar Details | 00:00:00 | ||
| Random Useful Items | |||
| Sparklines Details | 00:00:00 | ||
| Inserting Sparklines Details | 00:00:00 | ||
| Customizing Sparklines Details | 00:00:00 | ||
| Exercise: Inserting and Customizing Sparklines Details | 00:00:00 | ||
| Using Microsoft Translator Details | 00:00:00 | ||
| Preparing a Workbook for Internationalization and Accessibility Details | 00:00:00 | ||
| Display Data in Multiple International Formats Details | 00:00:00 | ||
| Modify Worksheets for Use with Accessibility Tools Details | 00:00:00 | ||
| Accessibility: Using Sounds Details | 00:00:00 | ||
| Use International Symbols Details | 00:00:00 | ||
| Manage Multiple Options for +Body and +Heading Fonts Details | 00:00:00 | ||
| Importing and Exporting Files Details | 00:00:00 | ||
| Importing Delimited Text Files Details | 00:00:00 | ||
| Exercise: Importing Text Files Details | 00:00:00 | ||
| Exporting Worksheet Data to Microsoft Word Details | 00:00:00 | ||
| Exercise: Copying Data from Excel to Word Details | 00:00:00 | ||
| Exporting Excel Charts to Microsoft Word Details | 00:00:00 | ||
| Exercise: Copying Charts from Excel to Word Details | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED