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.
4.51 (698 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
MS Office Complete Training - Beginner to Expert Level
4,730
students
16 hours
content
Jun 2024
last update
$69.99
regular price

What you will 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

Screenshots

MS Office Complete Training - Beginner to Expert Level - Screenshot_01MS Office Complete Training - Beginner to Expert Level - Screenshot_02MS Office Complete Training - Beginner to Expert Level - Screenshot_03MS Office Complete Training - Beginner to Expert Level - Screenshot_04
Related Topics
1746150
udemy ID
6/13/2018
course created date
11/22/2019
course indexed date
Bot
course submited by