Microsoft Office Suite 2016 All-In-One Training
Master 5 platforms, including Advanced Excel, World, Powerpoint, Outlook, and Access. Includes Power pivot, Macros, and basic VBA.
Lectures -155
Resources -3
Duration -11.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Microsoft Office Suite 2016 All-In-One Training is a convenient resource to learn Microsoft Office Suite 2016 for beginners and intermediates.
The Microsoft Office Suite is one of the most popular and widely used productivity software suites in the world. It includes a variety of applications that allow users to create and edit documents, spreadsheets, presentations, databases, and more.
Course Overview
This all-in-one online video course will teach you everything you need to know about the Microsoft Office Suite 2016. You will learn about the different applications in the suite, how to use them effectively, and how to get the most out of their features.
This course covers a wide range of topics, such as Microsoft Word, Excel, PowerPoint, Access, and Outlook Using Microsoft Professional 2016, all in one place.
Updated VBA and Macro as promised in Excel. I will update the usage of VBA across all the others as well in 3-6 Months.
This course will be updated every 3 months.
Excel:
- Master Microsoft Excel from Beginner to Advanced
- Build a solid understanding of 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, Pivot Tables
- Creation of Macro and VBA in Excel.
- 4 Mini Projects in VBA and Macro.
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 in presentations by using graphs and images
- Work comfortably with PowerPoint and many of its advanced features
- Become one of the top PowerPoint users on 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.
- 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 sub-forms.
Outlook:
- Understand the basic usage of Outlook.
- How to create rules in Outlook and group the emails.
- How to format message and recall a message.
- How to manage your calendar.
- How to create meetings and handle the participants.
- How to create tasks using Outlook.
- How to create contacts and manage groups in Outlook
Goals
- Create your first Macro
- Creation of your official document
- Creation of your presentation
- Create your query without programming
- Create your email, task, meeting, etc
Prerequisites
- Basic computer
- Microsoft Office software
![Microsoft Office Suite 2016 All-In-One Training Microsoft Office Suite 2016 All-In-One Training](https://d3mxt5v3yxgcsr.cloudfront.net/courses/4258/course_4258_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Section 1: Excel Introduction
11 Lectures
-
Introduction to Excel 07:39 07:39
-
2.1 Cell formatting 05:36 05:36
-
Cell formatting- Part 2 06:25 06:25
-
Essential Operation 06:57 06:57
-
Names and ranges 08:54 08:54
-
Cell formatting 09:04 09:04
-
Searching and commenting 05:39 05:39
-
Tables in excel 04:32 04:32
-
Fonts in excel 08:08 08:08
-
Styles and themes 05:26 05:26
-
File recovery and protection 02:50 02:50
Formula in Excel
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Graphics in Excel
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Advanced Excel videos
21 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Macro in Excel
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
VBA in Excel
14 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Microsoft Word
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Formatting document using Word
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Layout, view and sharing document
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
All other option functionality
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Powerpoint
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Basic text formatting in PPT
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Graphics and multimedia
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Animation and transition
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Outlook Introduction
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
View, print and save
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Managing mail
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Messages and formatting mail
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Format message
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Arranging and managing
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Calendars in mail
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Tasks ,To-do List, Contact and group in Outlook
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Microsoft Access
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working with Database and tables
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Modify Tables ,fields and Forms in Access
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Query and Reports
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Chandramouli Jayendran](https://www.tutorialspoint.com/assets/profiles/297891/profile/200_249122-1613373341.jpg)
Chandramouli Jayendran
I am a software engineer turned into stock trader. Author of 12+ courses with more than 50K students enrolled. I am very passionate on teaching office productivity, software programming and stock market analysis.
Worked with teaching several corporate on Office productivity and Programming. Running an teaching centre of my own.
Trade in stock market whenever I could see opportunity.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)