Microsoft Office Excel 2019/365: Part 3 Online Course

Microsoft Excel TrainingMicrosoft Office Excel 2019/365: Part 3

by Certstaffix® Training

Length: 1 Course(s)      Price: $175/person (US Dollars)      Bulk Pricing: 6+ Contact Us      Access Length: 6 Months      Category: Microsoft Excel


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 using Excel 2019 or Excel 365.
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online Microsoft Excel Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Any needed software for training is provided in an online lab environment.

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It
Microsoft Excel Training

Advanced Microsoft Excel 2019 Training - 7:00 hours

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 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
Course Description: Print It | Download PDF | Email It