MS Office Complete Training – Beginner to Expert Level

Complete Practical training in MS Office 2010 to 2019 and Office 365 in MS Excel, MS Word, MS PowerPoint and MS Access.

Created by: Himanshu Dhar
MIS Trainer

What Will I Learn?

• Data management in MS Excel
• Documentation expertise in MS Word
• Creating powerful presentation in PowerPoint
• Learn Database in MS Access
• Good understanding of Excel at MIS level
• Updated features of MS Office 2013, 2016 & 2019 like Power Tools, Quick Analysis, Textjoin, XOR, IFS, Draw Tab and many more
• Expertise in Text Function
• Expertise in Logical Function
• Expertise in Math Function
• Expertise in Lookup and Reference Function with latest XLOOKUP Function
• Expertise in Date and Time Function
• Mastery in Pivot Table and Chart Preparation
• Mastery in 'What if Analysis' tools
• Print Option in Excel
• Data Validation, Filter and Conditional Formatting
• Mastery in Data organizing Tools in Excel
• Mastery in Data creation and Data Manipulation in Excel
• Managing data protection and data sharing in Excel
• Working with Power Pivot and Power Map
• Work with Macro Recording
• Begin with the basics of creating Microsoft Word documents
• You will learn how to take full advantage of Microsoft Word
• Format documents effectively using Microsoft Word Styles
• Create and Manage Table Layouts
• Perform Mail Merges to create Mailing Labels and Form Letters
• Preparing documents for printing and exporting
• Control page formatting and flow with sections and page breaks
• Insert Media and Images
• Working efficiently with quick parts, hyperlink, bookmarking and Cross Reference
• Using header, footer, page no and table of content
• Creating hierarchy structure using Smart Art
• Track and Accept/Reject Changes to a Document
• At the end of this course, you will be able to create a simple DATABASE in Access from scratch
• You will know how to create and modify TABLES in Access
• You will know how to create QUERIES to ask questions of your Access database
• You will know how to create FORMS for enter data into your tables
• You will know how to create REPORTS for sharing and presenting your data in a clear, professional way
• Work confidently with Microsoft PowerPoint
• Create sophisticated and well-organized PowerPoint presentations

Requirements

• Basic Computer Knowledge

Target audience

• Anyone want to expertise MS Office
• For career as Back Office