TRAINING SERIES OVERVIEW

Duration: ~14:50 hours online training

In today's data driven world, Microsoft® Excel plays a crucial role in using and analyzing data in numerous ways. The concepts of slicing and dicing the data to come up with "What if" analysis can be done using Microsoft Excel in both basic and advanced ways. This series will introduce Microsoft® Excel in three parts both for personal productivity and professional benefit.As a bonus, we will also introduce Microsoft 2019 essentials covering Excel, Word, PowerPoint, Outlook, and Access.

COURSE OVERVIEW

Microsoft Office 2019 New Features

Duration: ~2:46 hours online training

This course will introduce students to the new features in Microsoft Office 2019, including updates to Word, Excel, PowerPoint, Outlook, and Access.

Course 01 - Word
Course 02 - Excel
Course 03 - PowerPoint
Course 04 - Outlook
Course 05 - Access

Microsoft Excel 2019 - Part 1

Duration: ~4:22 hours online training

This course will introduce students to Microsoft Office Excel 2019, and teach students about performing calculations, modifying a worksheet, formatting a worksheet, printing workbooks, managing workbooks, adding borders and colors to worksheets, and basic Excel customization.

Chapter 1 - Getting Started with Microsoft Office Excel 2019
Chapter 2 - Performing Calculations
Chapter 3 - Modifying a Worksheet
Chapter 4 - Formatting a Worksheet
Chapter 5 - Printing Workbooks
Chapter 6 - Managing Workbooks
Chapter 7 - Adding Borders and Colors to Worksheets
Chapter 8 - Basic Excel Customization

Microsoft Excel 2019 - Part 2

Duration: ~4:22 hours online training

This course will teach students about working with functions, working with lists, analyzing data, visualizing data with charts, using PivotTables and PivotCharts, working with graphical objects, and using array formulas.

Chapter 1 - Working with Functions
Chapter 2 - Working with Lists
Chapter 3 - Analyzing Data
Chapter 4 - Visualizing Data with Charts
Chapter 5 - Using PivotTables and PivotCharts
Chapter 6 - Working with Graphical Objects
Chapter 7 - Using Array Formulas

Microsoft Excel 2019 - Part 3

Duration: ~4:22 hours online training

This course will teach students about working with multiple worksheets and workbooks, sharing and protecting workbooks, automating workbook functionality, using Lookup functions and formula auditing, forecasting data, creating sparklines and mapping data, importing and exporting data, internationalizing workbooks, working with Power Pivot, advanced customization options, and working with forms and controls.

Chapter 1 - Working with Multiple Worksheets and Workbooks
Chapter 2 - Sharing and Protecting Workbooks
Chapter 3 - Automating Workbook Functionality
Chapter 4 - Using Lookup Functions and Formula Auditing
Chapter 5 - Forecasting Data
Chapter 6 - Creating Sparklines and Mapping Data
Chapter 7 - Importing and Exporting Data
Chapter 8 - Internationalizing Workbooks
Chapter 9 - Working with Power Pivot
Chapter 10 - Advanced Customization Options
Chapter 11 - Working with Forms and Controls

COMPLETION CERTIFICATE

In order to receive the completion certificate, learners must have completed reviewing all the modules and have successfully passed the training mockup exam.

Microsoft® Excel 2019 PowerPack

Name: Microsoft® Excel 2019 PowerPack
Brand: Agile Training Champions

$199.99

$100.00

Quantity

All course contents are carefully created and presented by experienced professionals. These courses

Are Self-Paced Learning modules

Comprises of Computer-Based Training

Includes 360-day Access from the day access is granted to you
We guarantee the quality of our on-demand courses.

Any on-demand course purchased is eligible for 100% refund, as long as access to the course is not granted.

If access is granted and refund is requested within 48 hours, an administrative expense of 50% will be applied before refund is issued. To request a refund, please contact info@agiletrainingchampions.com from your registered email identifying first name, last name, and course name.

After 48 hours of granting access to the course, there will be no refund.
Sales Tax

The purchaser is responsible for any sales tax obligation imposed by tax authorities in the purchaser's country.

We do not collect and pay sales tax on behalf of the purchaser.

Certification

The courses are designed to prepare enduser for their certification exam.

Each individual is responsible for meeting their eligiblity to sit for the exam and successfully pass the exam.

Terms of Use

The access granted to an enduser for any purchased course is only for the specific enduser for personal learning only.

Specifically, endusers can not

share or distribute user names or passwords

modify, record, screen capture or copy the materials;

use the materials for any commercial purpose, or for any public display (commercial or non-commercial);

attempt to decompile or reverse engineer any video content contained on this web site

remove any copyright or other proprietary notations from the materials; or

transfer the materials to another person or "mirror" the materials on any other server

Agile Training Champions

Helping Everyone Excel

Microsoft® Excel 2019 PowerPack

Course Delivery Format

Refund Policy

Disclaimers