Features
Microsoft Office 2016/2019
Introduction
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
