Microsoft Office 2016/2019


Zero-to-Hero Corporate Training.

Microsoft Office is a very helpful tool widely used in home, office and schools, to organize, manage and present information, data and figures. It includes Word, to create and share documents; Excel, to analyze and visualize data; PowerPoint, to create, collaborate, and effectively present ideas; Outlook, to organize email, coordinate schedules, and stay up to date with contacts; Access, to create custom database and process data; and Publisher, to print and share professional-looking publications.

Microsoft Word

Day 1
  • Getting Started with Word 2019
  • Formatting Text & Paragraphs
  • Working More Efficiently
  • Managing Lists
  • Adding Tables
  • Inserting Graphic Objects
  • Controlling Page Appearance
  • Preparing to Publish a Document
Day 2
  • Organizing Content Using Tables and Charts
  • Customizing Formats Using Styles and Themes
  • Inserting Content Using Quick Parts
  • Using Templates to Automate Document
  • Controlling the Flow of a Document
  • Simplifying and Managing Long Documents
  • Using Mail Merge to Create Letters, Envelopes and Labels
Day 3
  • Manipulating Images
  • Using Custom Graphic Elements
  • Collaborating on Documents
  • Adding Document References and Links
  • Securing a Document
  • Using Forms to Manage Content
  • Automating Repetitive Tasks with Macros

Microsoft Excel

Day 1
  • Getting Started with Excel 2019
  • Performing Calculations
  • Modifying a Worksheet
  • Formatting a Worksheet
  • Printing Workbooks
  • Adding Borders and Colors to Worksheets
  • Basic Excel Customization
Day 2
  • Working with Functions
  • Working with Lists
  • Analyzing Data
  • Visualizing Data with Charts
  • Working with Graphical Objects
  • Using Array Formulas
Day 3
  • 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
  • Working with Forms and Control

Microsoft PowerPoint

Day 1
  • Getting Started with PowerPoint
  • Developing a PowerPoint Presentation
  • Performing Advanced Text Editing Operations
  • Adding and Arranging Graphical Elements
  • Modifying Graphical Elements
  • Preparing to Deliver Your Presentation
Day 2
  • Customizing Design Templates
  • Using Ink to Hand Draw Elements
  • Adding Tables
  • Adding Charts
  • Working with Media
  • Building Advanced Transitions and Animations Finalizing a Presentation
  • Customizing Presentation Navigation
  • Securing and Distributing a Presentation

Microsoft Access

Day 1
  • Getting Started with Access
  • Working with Table Data
  • Querying a Database
  • Using Forms
  • Generating Reports
  • Designing a Relational Database
  • Sharing Data Across Applications
Day 2
  • Organizing a Database for Efficiency
  • Joining Tables
  • Creating Advanced Queries
  • Using Advanced Reporting Techniques
  • Implementing Advanced Form Design
  • Using Data Validation
  • Using Macros to Improve User Interface Design
  • Using Advanced Database Management

Microsoft Outlook

Day 1
  • Getting Started with Outlook
  • Formatting Messages
  • Working with Attachments and Illustrations
  • Customizing Message Options
  • Organizing Messages
  • Managing Your Contacts
  • Working with the Calendar
  • Working with Tasks and Notes
Day 2
  • Modifying Message Properties and Customizing Outlook
  • Organizing, Searching, and Managing Messages
  • Managing Your Mailbox
  • Automating Message Management
  • Working with Calendar Settings
  • Managing Contacts
  • Managing Activities Using Tasks
  • Sharing Outlook Items
  • Managing Outlook Data Files

Microsoft Publisher

Day 1
  • Getting Started with Publisher
  • Adding Content to a Publication
  • Formatting Text and Paragraphs in a Publication
  • Managing Text in a Publication
  • Working with Graphics in a Publication
  • Preparing a Publication for Sharing and Printing