MS Office Complete Training - Beginner to Expert Level

MS Office Complete Training – Beginner to Expert Level | Udemy
English | Size: 8.96 GB
Genre: eLearning

What you’ll 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
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

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment Cancel reply