Module 1: Introduction :

• Overview

• About Microsoft Suite

• About Microsoft Word

• Course objectives

• Microsoft office 2016 features

• Microsoft office 2019 features

• Microsoft Word 2016 vs 2019: What’s new

• Basic word concepts and terminologies

• Creating and naming a new document

• How to save a document

• How to open and close a document

Module 2: Word 2016 fundamentals :

• Understanding Ribbon & Tools

• Managing Document Versions

• Organizing Styles

• Working with Macros

• Set Tracking Options

• Preparing Documents for Review

• How to Delete Document Versions

• Marking Documents as Final

• Tracking Changes

• Managing Comments

Module 3: Word 2019 New Features :

• Inserting SVG Icons into your document

• Inserting Equations into Documents

• Working with 3D models

• Inserting Header & Footer

• Merging and Comparing Documents

• Work with Word Assistant

• Using Learning Tools

• Learn Word 2019 Translate Feature

Module 4: Advanced Microsoft Word :

• Advanced Formatting

• Creating Custom Fields

• Designing Advanced Layout Options

• Advanced Character Attributes

• Linking Text Boxes

• Advanced Styles

• Advanced Style Options

• Advanced Ordering & Grouping

Module 5: Master Documents :

• Work with Master Documents

• Linking Document Elements

• Creating Indexes

• Auto marking Entries

Module 6: Advanced Microsoft Word Publishing :

• Creating Table of Contents (TOC)

• Create Table of Figures

• Work with Citations

• Cross Referencing

• How to Create Forms

• Working with Content Controls

• Command Buttons on Forms

• Mail Merge Operations

• Microsoft Word Best Practices

Module 1: Presenting and Managing Data in Excel 2016 & 2019 :

• Basic Understanding Menu and Toolbar

• Introduction to different category of functions

• Creation of Excel Sheet Data

• Range Name, Format Painter

• Conditional Formatting, Wrap Text, Merge & Centre

• Sort, Filter, Advance Filter

• Different type of Chart Creations

• Auditing, (Trace Precedents, Trace Dependents) Print Area

• Data Validations, Consolidate, Subtotal

• What if Analysis (Data Table, Goal Seek, Scenario)

• Solver, Freeze Panes

• Various Simple Functions in Excel (Sum, Average, Max, Min)

• Real Life Assignment work

Module 2: Create charts and tables

• Create advanced charts :
• Add trendlines to charts,
• create dual-axis charts,
• save a chart as a template

• Create and manage PivotTables :
• Create PivotTables,
• modify field selections and options,
• create slicers,
• group PivotTable data,
• reference data in a PivotTable by using the GETPIVOTDATA function,
• add calculated fields,
• format data

• Create and manage PivotCharts :
• Create PivotCharts,
• manipulate options in existing PivotCharts,
• apply styles to PivotCharts,
• drill down into PivotChart details

Module 3: MIS Reporting and Dashboards

• Dashboard Background

• Dashboard Elements

• Interactive Dashboards

• Type of Reporting in India

• Reporting Analyst

• Indian Print Media Reporting

• Audit Report

• Accounting MIS Reports

• HR Mis Reports

• MIS Report Preparation Supplier, Exporter

• Data Analysis

• Costing Budgeting Mis Reporting

• MIS Reporting for Manufacturing Company

• MIS Reporting for Store and Billing

• Product Performance Report

• Member Performance Report

• Customer-Wise Sales Report

• Collections Report

• Channel Stock Report

• Prospect Analysis Report

• Calling Reports

• Expenses Report

• Stock Controller MIS Reporting

• Inventory Statement

• Payroll Report

• Salary Slip

• Loan Assumption Sheet

• Invoice Creation

Module 4: VBA and Macros

• Introduction to VBA

• Understanding Loops, Conditions & Writing VBA Code

• Variables in VBA

• Working with Cells & Ranges

• Worksheets, Workbooks & Databases

• Working with Charts & Drawing Shapes

• Dealing with Pivot Tables from VBA

• User Forms & Databases – Basics

• User Forms – Advanced

• Integration with other Office Apps

• Additional VBA Techniques – Arrays, Practical Examples

• Class Project & More

Module 1: Introduction :

• Outlook Screen Overview

• Office Management

• Drag & Drop

• Second Window

Module 2: Email sending & receiving :

• Email do's and don’ts

• Autofill importance and email format

• Handling attachments

• Email signatures

• Recall a message

• Quick steps gallery

Module 3: Email Organizing :

• Email options

• Voting Buttons

• View Ribbon, Layout Group

• Groups and Conversations

• Search for and Color Code emails

• Inbox Sticky Notes

• Follow-up Flags and Categories

• Folders and Search Folders

• Rules and Alerts

Module 4: Calendar :

• Calendar views

• Calendar Display options

• Appointments, Meetings and Events

• Schedule Resources and Schedule View

• Recurring Appointments

• Color Code Appointments

• Search the Calendar

• Printing and Calendar Best Practices

Module 5: Contacts :

• New Contacts

• Contact Groups aka Distribution Lists

• Search Contacts and People Pane

• Contact Folders and Groups

• Contact Categories

• Contact Views

• Contacts Backup

Module 6: Tasks and Notes :

• Tasks, New and Recurring

• Assign Tasks, Change View

• Task To-Do Bar

• Using Notes

Module 7: Advanced Features :

• Email Merge

• Email Merge, Personalized

• Email Merge, Full Color Flyers

• Backup Outlook Folder

• Store Emails Outside of Outlook

Module 1: Interface and Basics :

• Launching PowerPoint and Choosing a Theme

• Adding Slides, Changing Layouts and Exploring the Outline

• Exploring PowerPoint’s Views

• Getting Familiar with the Notes Pane

• Customizing the PowerPoint Interface

• Changing Themes and Colors

Module 2: Adding Text and Shapes :

• The Content Placeholder and Bullet Levels

• Formatting Text

• Adding and Manipulating Shapes

• Duplicate and Add Multiple Shapes

• Align and Distribute Shapes

• Group and Ungroup Shapes

Module 3: Pictures :

• Working with Pictures

• Remove Picture Backgrounds

• Photo Album

Module 4: Info-graphics and Media :

• Introducing SmartArt

• Adding and Editing Charts

• Advanced Chart Options

• Structure Your Tables

• Adding Audio

• Adding Video

Module 5: Animations and Transitions :

• Less is More

• Basic Animation Types

• Events and Speed

• Motion Path Animations

• Transitions

Module :6 Slide Tasks :

• Duplicating and Reordering Slides

• Reusing and Copying Slides

• Working with Slide Sections

• Reset – the Magic Button

Module :7 Delivering Your Presentation :

• Printing Slides

• Rehearsing Slides

• Exploring Slide Show Options

• Using Presenter View

Module :8 New Design Features :

• Morph Transitions

• Insert Icons

• 3D Animations

• Pre-Animated 3D Models

• Insert Zoom Slides