Course 55270-A: Advanced Microsoft Excel 2019

Course 55270-A: Advanced Microsoft Excel 2019 Certification Training Course Overview

Enrol for this 1-day Advanced Microsoft Excel 2019 training and certification course from Koenig solutions accredited by Microsoft. 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.

Target Audience:

Students 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.

Learning 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.

 

Test your current knowledge Qubits42

Course 55270-A: Advanced Microsoft Excel 2019 (8 Hours) Download Course Contents

Live Virtual Classroom 700
Group Training
01 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

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
  • Auditing Worksheets Exercises
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
  • Data Tools Exercises
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
  • Working with Others Exercises
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
  • Recording and Using Macros Exercises
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
  • Random Useful Items Exercises
Module 7: Cloud
  • Using the Cloud.
Download Course Contents

Request More Information

Course Prerequisites

Before attending this course, students must have:

  • Basic and Intermediate Excel experience.