TRAINING SERIES OVERVIEW

Total Duration: 31:33 hrs online training

  • Excel: 12:06
  • Outlook: 5:12
  • PowerPoint: 5:34
  • Word:  8:41

 

TARGET AUDIENCE

This course is designed for anyone to get a good understanding of Office 2019 Productivity Pack.

 

COURSE OVERVIEW

 

1. Office 2019 Excel - 1

4:22 hrs

1 - Getting Started with Microsoft Office Excel 2019

2 - Performing Calculations

3 - Modifying a Worksheet

4 - Formatting a Worksheet

5 - Printing Workbooks

6 - Managing Workbooks

7 - Adding Borders and Colors to Worksheets

8 - Basic Excel Customization

 

2. Office 2019 Excel - 2

4:02 hrs

1 - Working with Functions

2 - Working with Lists

3 - Analyzing Data

4 - Visualizing Data with Charts

5 - Using PivotTables and PivotCharts

6 - Working with Graphical Objects

7 - Using Array Formulas

 

3. Office 2019 Excel - 3

3:40 hrs

1 - Working with Multiple Worksheets and Workbooks

2 - Sharing and Protecting Workbooks/li>

3 - Automating Workbook Functionality

4 - Using Lookup Functions and Formula Auditing

5 - Forecasting Data

6 - Creating Sparklines and Mapping Data

7 - Importing and Exporting Data

8 - Internationalizing Workbooks

9 - Working with Power Pivot

10 - Advanced Customization Options

11 - Working with Forms and Controls

 

4. Office 2019 Outlook - 1

2:51 hrs

1 - Getting Started with Outlook 2019

2 - Formatting Messages

3 - Working with Attachments and Illustrations

4 - Customizing Message Options

5 - Organizing Messages

6 - Managing Your Contacts

7 - Working with the Calendar

8 - Working with Tasks and Notes

 

5. Office 2019 Outlook - 2

2:11 hrs

1 - Modifying Message Properties and Customizing Outlook

2 - Organizing, Searching, and Managing Messages

3 - Managing Your Mailbox

4 - Automating Message Management

5 - Working with Calendar Settings

6 - Managing Contacts

7 - Managing Activities Using Tasks

8 - Sharing Outlook Items

9 - Managing Outlook Data Files

 

6. Office 2019 PowerPoint - 1

3:00 hrs

 1 - Getting Started with PowerPoint

2 - Developing a PowerPoint Presentation

3 - Performing Advanced Text Editing Operations

4 - Adding and Arranging Graphical Elements

5 - Modifying Graphical Elements

6 - Preparing to Deliver Your Presentation

 

7. Office 2019 PowerPoint - 2

2:34 hrs

1 - Customizing Design Templates

2 - Using Ink to Hand Draw Elements

3 - Adding Tables

4 - Adding Charts

5 - Working with Media

6 - Building Advanced Transitions and Animations

7 - Finalizing a Presentation

8 - Customizing Presentation Navigation

9 - Building Advanced Transitions and Animations

 

8. Office 2019 Word - 1

2:55 hrs

1 - Getting Started with Word 2019

2 - Formatting Text and Paragraphs

3 - Working More Efficiently

4 - Managing Lists

5 - Adding Tables

6 - Inserting Graphic Objects

7 - Controlling Page Appearance

8 - Preparing to Publish a Document

 

9. Office 2019 Word - 2

3:11 hrs

1 - Organizing Content Using Tables and Charts

2 - Customizing Formats Using Styles and Themes

3 - Inserting Content Using Quick Parts

4 - Using Templates to Automate Document Formatting

5 - Controlling the Flow of a Document

6 - Simplifying and Managing Long Documents

7 - Using Mail Merge to Create Letters, Envelopes, and Labels

 

10. Office 2019 Word - 3

2:35 hrs

1 - Manipulating Images

2 - Using Custom Graphic Elements

3 - Collaborating on Documents

4 - Adding Document References and Links

5 - Securing a Document

6 - Using Forms to Manage Content

7 - Automating Repetitive Tasks with Macros

 

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 Office 2019 Suite (10 Modules)

$499.99 Regular Price
$250.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