Microsoft Office suite 2016 (Latest 2019) Beginner to Pro

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.