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

$199.99 Regular Price
$100.00Sale Price
  • 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
  • facebook-square
  • LinkedIn Social Icon
  • YouTube Classic
  • Twitter Classic

© 2020 by Agile Training Champions