Microsoft Office suite(Latest 2021) | VBA and Macro

MS Office 2021-Microsoft Word, Excel, Powerpoint, Outlook, Access all in one place. VBA & Macro Included for automation.

3.70 (169 reviews)
Udemy
platform
English
language
Microsoft
category
5,305
students
12.5 hours
content
Nov 2020
last update
$34.99
regular price

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

Usage of VBA and Macro to automate the daily manual tasks

Description

Microsoft Office Suite 2016 for beginners and intermediates.


This course(MS Office 2021) covers wide range of topics such as Microsoft Word, Excel, Powerpoint , Access, 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 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, Pivot Tables

Creation of Macro and VBA in Excel.

4 Mini Project 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 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 sub-forms.


Outlook:

Understand the basic usage of Outlook.

How to create rules in Outlook and group the mails.

How to format message and recall of message.

How to manage your calendar.

How to create to meetings and handling the participants.

How to create tasks using Outlook.

How to create contacts and manage groups in Outlook

Content

Microsoft Word

Introduction
Options in Typing in Word
Text editing in Word
Styles and fun themes

Formatting document in Word

Formatting Introduction and character formatting
Paragraph Formatting
Page and tab formatting
Style and Fun themes
Image Formatting

Layout and sharing document

Header, Footer and URL
Mailing in Microsoft Word
View in Microsoft Word

Other Word functionalities

Table design
Review Option in Word
Table of content and Index
Permission and Author

Microsoft Excel

Introduction
Cell formatting
Essential Operation in Excel
Working with cells and ranges
Working with Tables
Worksheet Formatting and Understanding File

Formulas in Excel

Formula in Excel
Formula- Part 2
Formula - Part 3
Formula - Part 4

Graphics in Microsoft Word

Chart Introduction
Pivot Tables
Conditional Formatting and Sparklines
Other Graphics Options in Excel

Power Point

Introduction
Effective Presentation - Part 1
Effective Presentation - Part 2
Effective Presentation - Part 3
Creation of first presentation and saving

Basic Text Formatting

Creating Slides and text boxes
Formatting - Part 1
Formatting - Part 2
Formatting - Part 3
Working with Layout Themes

Microsoft Access

Introduction
Working with Access Interface
Defining data needs and types

Creating database and tables - Access

Creating Database
Creating Table

Working with tables and database records

Navigate among records
Working with Primary Keys
Find and Replace
Sorting and Filtering
Understanding Table Relation

Modifying Tables and fields

Modifying DB table
Creating field and Modifying field

Creating Form

1. Creating Forms
Sorting and filter using forms

Creating Queries

Create Query
Modifying queries
Sorting and filtering using queries

Create Report

Create Report

Microsoft Outlook

Introduction to Outlook
Introduction- Part 2 - Shortcuts in Outlook

Knowing Outlook Environment

Introduction to managing outlook environment
Mail set-up in Outlook
Appearance of mail
Navigation of outlook
Configuration of program option

View, Print and saving in Outlook

view attachment in Outlook
Saving option in outlook
Search messages in Outlook
Search option- Final

Managing Mails

Managing mail - Introduction
Mail signature
Creating rules in outlook
Rules within rules in outlook
Update and delete rules in Outlook
Junk Email setup in Outlook

Message formatting in Outlook

Create mail in Outlook
Configuring messages in Outlook
Recall messages in outlook

Formatting messages in Outlook

Fonts in Outlook messages
Insert in Outlook messages
Themes and styles in Outlook
Hyperlink in Outlook
Images insert in Outlook

Arranging mails in Outlook

Managing and arranging mails in outlook
Managing and arranging mails in outlook- Part 2

Calender in outlook

Calender in outlook
Calender in outlook- Part 2
Appointment in Outlook
Meetings in Outlook
Meetings in Outlook- Part 2

Task and To-do list

Task and To-do list
Task and To-do list- Part 2

Contact and group

Contact and group

Screenshots

Microsoft Office suite(Latest 2021) | VBA and Macro - Screenshot_01Microsoft Office suite(Latest 2021) | VBA and Macro - Screenshot_02Microsoft Office suite(Latest 2021) | VBA and Macro - Screenshot_03Microsoft Office suite(Latest 2021) | VBA and Macro - Screenshot_04

Reviews

Pam
July 11, 2022
The person talking is hard to understand. He talks fast and is hard to understand words his enunciation on words.
Jennifer
December 2, 2021
It is hard to understand the instructor at some times. He just needs to slow down his speech and it would be much easier to understand.
Daniel
May 11, 2021
so farI am enjoying the co. Its very informative and the way the instructor teaches is very comprehensive. I do have an issue with the instructor's accent. I find myself having to replay constantly in order to get a complete understanding of what the gentleman is saying. I think it may be worth while to pehapshave several versions of these courses with instructors with various accents to provide students with a higher level of comfortability.
Umeko
February 22, 2021
The instructor was very knowledgeable, but I could barely understand what he was saying. From what I could understand helped me to understand how VBA's and Marco works.
Maria
October 26, 2020
I was thinking that will be something more slow ,the guy speak to quickly and his accent is difficult to understand. sorry
Ashwini
June 8, 2020
yes it was informative but the accent was not clear and was very fast as if he wanted to catch a train
Ashley
June 3, 2020
I NEED SOMEONE WHO I CAN UNDERSTAND PLEASE CONTACT ME WITH A BETTER COARSE SAME KIND JUST SOMEONE WHO SPEAKS ENGLISH
Alfred
May 5, 2020
I thought I could hear the instructor. I am not hearing what the instructor is teaching . I only see the mouse running all over the screen. At this time it begin to sink in cause I am hearing the instructor and the course is advancing.
Yandiswa
May 5, 2020
I have bought many courses at Udemy because of the quality of material and information they offer, but this one was very disappointing. I think the guy knows outlook more than any other courses... This should be beginners course and the quality of presentation need to improve. Regards,
Shari
April 21, 2020
70% video was blurred so we couldn't understand , request you to pls check the videos before uploading in such a learning site
Maria
April 12, 2020
It was basic info but I did learn a different way to use the format painter due to the fact that I have not the latest Microsoft Word on my laptop.
Eva
September 24, 2019
I had expected more demonstrations other than examples given by mouth. I would rather have seen the functions for each task. I also find the instructors heavy accent hard to understand.

Coupons

DateDiscountStatus
7/6/2020100% OFF
expired

Charts

Price

Microsoft Office suite(Latest 2021) | VBA and Macro - Price chart

Rating

Microsoft Office suite(Latest 2021) | VBA and Macro - Ratings chart

Enrollment distribution

Microsoft Office suite(Latest 2021) | VBA and Macro - Distribution chart

Related Topics

2274345
udemy ID
3/16/2019
course created date
11/22/2019
course indexed date
Bot
course submited by