Advanced Microsoft Excel 2019 Training - 7:00 hoursThis 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 using Excel 2019 or Excel 365.
Using Pivot Tables Creating Pivot Tables Preparing Your Data Inserting a Pivot Table Creating a PivotTable Timeline More PivotTable Functionality Inserting Slicers Multi-Select Option in Slicers PivotTable Enhancements Working with Pivot Tables Grouping Data Using PowerPivot Managing Relationships Inserting Pivot Charts More Pivot Table Functionality Creating a Standalone PivotChart Exercise: Working with Pivot Tables Auditing Worksheets Tracing Precedents Exercise: Tracing Precedents Tracing Dependents Exercise: Tracing Dependents Showing Formulas Data Tools Converting Text to Columns Exercise: Converting Text to Columns Linking to External Data Controlling Calculation Options Data Validation Exercise: Using Data Validation Consolidating Data Exercise: Consolidating Data Goal Seek Exercise: Using Goal Seek Working with Others Protecting Worksheets and Workbooks Password Protecting a Workbook Removing Workbook Metadata Restoring Previous Versions Exercise: Password Protecting a Workbook Password Protecting a Worksheet Exercise: Password Protecting a Worksheet Password Protecting Ranges in a Worksheet Exercise: Password Protecting Ranges in a Worksheet Marking a Workbook as Final Recording and Using Macros Recording Macros Copy a Macro from Workbook to Workbook Exercise: Recording a Macro Running Macros Editing Macros Adding Macros to the Quick Access Toolbar Managing Macro Security Exercise: Adding a Macro to the Quick Access Toolbar Random Useful Items Sparklines Inserting Sparklines Customizing Sparklines Exercise: Inserting and Customizing Sparklines Using Microsoft Translator Preparing a Workbook for Internationalization and Accessibility Display Data in Multiple International Formats Modify Worksheets for Use with Accessibility Tools Accessibility: Using Sounds Use International Symbols Manage Multiple Options for +Body and +Heading Fonts Importing and Exporting Files Importing Delimited Text Files Exercise: Importing Text Files Exporting Worksheet Data to Microsoft Word Exercise: Copying Data from Excel to Word Exporting Excel Charts to Microsoft Word Exercise: Copying Charts from Excel to Word |