Microsoft Office suite 2016 (Latest 2019) | Beginner to Pro
3.3 (127 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,150 students enrolled

Microsoft Office suite 2016 (Latest 2019) | Beginner to Pro

Microsoft Word, Excel, Powerpoint , Outlook, Access 2016 all in one place. Get started with analytics and documentation
3.3 (127 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,150 students enrolled
Last updated 6/2020
English
Current price: $41.99 Original price: $64.99 Discount: 35% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Student can learn complete Microsoft Suite 2016 package in a single course
  • Excel, Word, Power point , Access, Outlook in a single course
  • Develop from Beginner to Pro in using Microsoft Suite
  • Improve your analytical Ability
Requirements
  • Basic computer knowledge
  • Microsoft office license
Description

Microsoft Office Suite 2016 for beginners and intermediates.


This course covers wide range of topics such as Microsoft Word, Excel, Powerpoint , Access 2016 all in one place.

I will promise to keep updating the course every 6 months and post bonus lectures of VBA usage with these tools based on the response.


Excel:


Master Microsoft Excel from Beginner to Advanced

Build a solid understanding on the Basics of Microsoft Excel

Learn the most common Excel functions used in the Office

Maintain large sets of Excel data in a list or table

Create dynamic reports by mastering one of the most popular tools, PivotTables



Word:


You will learn how to take full advantage of Microsoft Word

Begin with the basics of creating Microsoft Word documents

Various techniques to create dynamic layouts

Preparing documents for printing and exporting

Format documents effectively using Microsoft Word Styles

Control page formatting and flow with sections and page breaks

Create and Manage Table Layouts

Work with Tab Stops to Align Content Properly

Perform Mail Merges to create Mailing Labels and Form Letters

Build and Deliver Word Forms

Manage Templates

Track and Accept/Reject Changes to a Document



PPT:

Create a fully-animated and transition-filled business presentation

Rapidly improve your workflow and design skills

Minimize text quantity on presentations by using graphs and images

Work comfortably with PowerPoint and many of its advanced features

Become one of the top PowerPoint users in your team

Carrying out regular tasks faster than ever

Create sophisticated and well-organized PowerPoint presentations

Feel more confident when delivering presentations to superiors

Make an impression at work and achieve your professional goals



Access:


Understand how Access is constructed and how to use the major objects within it.

Be confident in moving around within Access and be able to build effective database solutions for their unique data needs.

What you'll learn

Understand the basics of Access tables, queries, forms and reports.

Know how to structure tables being imported from Excel.

Know how to create powerful queries and use them to create and modify tables.

Understand how reports work and how to base them on tables or queries.

Know how to create forms and subforms.




Who this course is for:
  • Anyone who want to be successful in their office job .
  • Want to become comfortable handling data
  • Organise and manage a team at work or at business
Course content
Expand all 121 lectures 09:18:09
+ Microsoft Word
3 lectures 16:36
Options in Typing in Microsoft Word
03:55
Text Editing in Microsoft Word
08:35
+ Formatting document in Word
6 lectures 30:21
Paragraph Formatting
04:03
Page Set up in MS Word
06:48
Page display in Word
03:54
Header, Footer and Themes
06:47
Image Formatting
04:17
+ Layout and sharing document
3 lectures 11:27
Header, Footer and URL
03:23
Mailing in Microsoft Word
03:47
View in Microsoft Word
04:17
+ Other Word functionalities
4 lectures 19:15
Table design
05:31
Review Option in Word
06:15
Table of content and Index
03:24
Permission and Author
04:05
+ Microsoft Excel
11 lectures 01:16:14
Cell formatting
09:36
Essential Operation in Excel
04:43
Names and Ranges
08:54
Cell formatting and copy and paste
09:04
Searching and commenting
05:39
Cell Border, colour, Merging & un-merge and Format Painter
09:18
Working with Tables
04:42
Fonts in Excel
08:08
Styles and Themes
05:26
File recovery and protection of Excel
02:50
+ Formulas in Excel
6 lectures 38:48
Formula in Excel
04:45
How to use Formulas in Excel
04:26
Frequently used Formulas in Excel
06:09
Frequently used formulas in Excel - Part2
13:49
Absolute and relative reference in Excel
05:41
Working with Dates using Formulas
03:58
+ Graphics in Microsoft Excel
5 lectures 24:21
Insertion of Image in Excel
05:02
Chart Introduction
04:01
Pivot Tables
03:50
Conditional Formatting and Sparklines
06:47
Other Graphics Options in Excel
04:41
+ Advanced Excel videos
19 lectures 01:24:04
Vlookup in Excel
08:13
Hlookup in Excel
05:26
Index and Match in Excel
10:50
Data validation in Excel and creation of list in Excel
05:24
Other data validation options
03:19
Error messages in data validation
03:11
Input messages in data validation
03:58
Dynamic LOV creation using Data validation
02:30
Pivot table Introduction
05:13
Pivot table modification and formatting
06:03
Styles and gathering data in Pivot table
03:31
Pivot chart
02:52
Filter in pivot table and Slicer tool in pivot
02:57
Powerpivot Introduction
03:06
Activation of power pivot
01:37
Customising data model in power pivot
03:42
Creating power pivot
02:09
Power pivot calculated fields
03:59
Power pivot KPI
06:04
+ Power Point
5 lectures 26:24
Effective Presentation - Part 1
05:04
Effective Presentation - Part 2
05:38
Effective Presentation - Part 3
03:42
Creation of first presentation and saving
07:05
+ Basic Text Formatting
5 lectures 24:32
Creating Slides and text boxes
06:00
Formatting - Part 1
04:52
Formatting - Part 2
05:14
Formatting - Part 3
05:01
Working with Layout Themes
03:25