Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Office Certification Mastery: From Novice to Ninja

Name: Microsoft Office Certification Mastery: From Novice to Ninja
Rating: 4.2 (47 reviews)

Certification Program: Microsoft Word, Excel, Unlock Macros & VBA, PowerPoint, Outlook.

Created bySam s

Last updated 5/2021

English

What you'll learn

Master Microsoft PowerPoint – From Beginner to Advanced
FREE REWARDS upon completion of course: Ready to Use PowerPoint Presentations, PowerPoint Themes, 3D Characters, Icons, HD Backgrounds
Master Microsoft Excel - From Beginner to Advanced
Master Microsoft Outlook – Outlook like a Boss
Master Excel Macros & VBA – From Beginner to Advanced
FREE REWARDS upon completion of course: 100+ Ready to Use VBA Codes
Master Microsoft Word - From Beginner to Advanced
Learn Microsoft office from scratch or fill in the gaps to become confident immediately
Explore the potential of Power Query. You will be surprised at what you achieve with a bit of Power Query knowledge
Get lifetime access to all these courses including quizzes, exercises & FREE access to new featured topics

Course content

50 sections • 253 lectures • 28h 45m total length

A Tour of the screen elements and ribbon5:25
Understanding the screen layout is paramount to mastering this program. Take a tour of the screen elements and ribbon.
Office Management4:55
Monitor inbox size, clean out certain folders, and set up auto-archive functionality.
[Trick] Drag and Drop - Trim Redundant Clicks for most repetitive tasks4:59
Trim redundant clicks from your most repetitive office tasks with this amazing trick!
Second Window - Shuffle between your Calendar and Inbox4:14
Utilize the second window functionality to end the back and forth shuffle between your calendar and inbox.

Emails Do's and Don'ts4:12
A set of email correspondence tips that are good reminders of online professionalism and etiquette.
Learn the Office Protocols - Autofill, Importance and Email Format5:39
Learn the office protocol for marking emails as important, using Plain vs HTML text, and how Autofill addresses really work.
Time Saving Tip - Email Signatures4:36
Signatures are vital to signing off on an email, and here you’ll learn how to apply them, along with a time saving tip to quickly finalize redundant correspondence.
Handling Attachments4:42
Tips on sending, receiving and saving attachments.
Recall a Message3:55
Learn how to recall a message and how to add a button to the ribbon for faster access to this feature.
[Trick] Quick Steps Gallery5:32
Quick Steps provide an alternative to redundant emails, distribution lists, and repetitive (yet unavoidable) office tasks.

Email Options5:38
Buried behind the Options ribbon are a variety of useful tools, including: Read receipts, Delayed send, and Voting buttons.
Voting Buttons4:14
Voting Buttons are useful for Approve/Reject responses, Yes/No responses, and can be customized to contain a list of up to 28 choices.
Set your own preferences and customize - View Ribbon, Layout Group6:14
Set your preferences and customize the Folder Pane, Reading Pane, and To-Do Bar.
Groups and Conversations4:59
Learn to organize your emails into groups and control how you view conversations.
Search for and Color Code Emails - Color coding to make it stand out in a crowd5:35
Never let another important email become visually lost in your inbox. Use Color Coding to make it stand out in a crowded list, and search for related emails.
Inbox Sticky Notes5:32
Sticky notes are handy for paper, so why not emails? This is by far the best little-known tip in Outlook.
Follow-up Flags and Categories4:37
Those little grey flags beside your email list actually have a useful purpose. Click the Flags as a reminder to get back to certain emails first, and apply a Category color to keep track of similar subjects.
Folders and Search Folders - Gather Category of Emails7:02
Folders and Search Folders - Gather Category of Emails
[Trick] Rules and Alerts - Perform time-saving tasks6:27
Set up rules that perform time-saving tasks, for instance filing certain emails automatically into certain folders.

Various ways of Calendar Views4:52
When you find yourself searching for an appointment or an open date, changing the Calendar view will help zoom into details or view a month at a glance.
Calendar Display Options5:20
Customize your Display Option preferences to suit your particular situation.
Appointments, Meetings and Events5:34
Use these scheduling tools to schedule appointments, meetings and events and make it easy for others to confirm their attendance.
Schedule Resources and Schedule View5:54
The ability to view multiple calendars in a horizontal format for easy comparison.
[Trick] Recurring Appointments - Awesome feature5:02
Use the Recurring Appointments feature to save you from the redundancy of scheduling multiple occurrences manually.
Color Code Appointments6:27
Color-Coding calendar items is known as “prioritizing”. Use this feature to produce at-a-glance decisions about your daily grind.
Search the Calendar quickly4:36
How to search and find a certain appointment or date quickly.
Printing and Calendar Best practices5:44
How to print a hard copy of the calendar and good tips for calendar management.
Test Yourself!

[Trick] New Contacts - Quick tips to add new contacts5:17
Quick tips on how to add new contacts efficiently.
Contact Groups aka Distribution Lists4:52
Previously known as Distribution lists, a Contact Group is one contact record that contains multiple people.
Search Contacts & People Pane - Best way to find contact & people activities5:30
Learn how to find a contact and use the People Pane to find all related activities.
Contact Folders and Groups - Keep your Contacts organized5:59
Keep your contacts organized by using multiple Folders and Groups.
Contact Categories - Keep your Contacts organized5:23
Keep your contacts organized by using Category colors.
Contact Views - View your contact data to get desired results & make decisions5:59
How you view your contact data will help you get to the information you need and make decisions faster.
Contacts Backup5:52
Secure your most important data from a disaster and backup your contacts!
Test your Knowledge with this Quiz

Tasks - New and Recurring4:38
Tasks are to-do items that are tracked electronically and can be recurring weekly or monthly.
Task Assignment to assistant or co-worker and Change View with simple click4:52
Tasks can be assigned to an assistant or co-worker via email, and an automated response keeps you updated on the status. Also change the view with a simple click.
Task To-Do Bar4:34
Viewing Tasks in other Outlook windows is easily customized with the To-Do Bar.
[Trick] Using Notes - Tips to make the most of your notes5:01
Learn tips to make the most of your notes, which are handy as a place to store info.
Test your Knowledge with this Quiz

Email Merge5:27
Send individual – but duplicate – emails to multiple people with one easy process.
Email Merge - Personalized5:49
Send individual, personalized emails to multiple people with one easy process.
Email Merge - Full Color Flyers7:16
Send individual, full color flyer emails to multiple people with one easy process.
Backup Outlook Folder6:22
Learn how to back up - also known as export - your Outlook folder.
Store Emails Outside of Outlook4:58
Store emails outside Outlook with other related files in one location, rather than digging through your inbox to find them.
Test Yourself!

Launching PowerPoint & Choosing a Theme6:55
Use a professionally designed template to save time creating a presentation.
Adding Slides, Changing Layouts & Exploring the Outline Feature4:34
Add slides, which are the building blocks of a presentation, and understand how layouts can provide you with quick ways to insert content aligned on your slide.
Exploring PowerPoint's Views4:54
The different PowerPoint views allow you to work on different parts of your presentation such as slides, slide thumbnails, text and running your presentation as a slideshow.
[Trick] Clever Location to add extra text to a slide5:48
A very clever location to add extra text to a slide that your audience may not see, but you can use as an aid when presenting or as printed handouts.
Customizing the PowerPoint Interface6:29
Find and add menu items and buttons that you frequently use to your ribbon or quick access toolbar to give you faster access to the PowerPoint features you probably use the most.
Changing Themes & Colors6:47
Quickly change the colors, fonts, effects or design of your entire presentation in almost a single mouse click.

[Trick] How to quickly add content to your Slides6:43
Use placeholders to quickly add content to your slides including text, diagrams, and charts so that you can later change the location and proportions of these objects, often with a single mouse click.
Formatting Text5:48
Format text in your presentation so that it is legible and perhaps even pleasant to look at!
Adding and Manipulating Shapes5:28
Add and work with shapes which are one of the most important building blocks on a slide, including rectangles, ovals, and triangles.
Duplicate and Add Multiple Shapes4:18
Reuse existing, formatted shapes to save time inserting shape content on your slides.
Align and Distribute Shapes5:42
Align and distribute shapes (and other content) so that they are correctly positioned to quickly balance the content on your slides and prevent the same objects on different slides jumping to different locations during a slideshow.
Group and Ungroup Shapes3:36
Group various shapes together into a single slide object to help you position the group of shapes in a specific location, while still gaining access to the size and formatting options available within PowerPoint for those individual shapes.

Working with Pictures5:43
Since a picture is really worth 1000 words, add pictures, change their appearance and do so much more with these fundamental slide objects.
Remove Picture Backgrounds4:37
Make the selected part of a picture transparent to either cleverly crop parts of the picture, or make parts of the picture transparent to overlay in front of other pictures without obscuring them.
[Trick] How to quickly add multiple pictures in presentation4:19
Quickly add multiple pictures to a presentation even in the format of two or four pictures per slide.

Requirements

Require a computer with MS office installed (2010, 2013 or 2016 - All versions after 2007 were pretty much same).
Require a computer with MS office installed (2016 version or later recommended) and a willingness to learn.
No prior knowledge is required as each step is explained in this Mastery series course.

Description

Why to buy individual courses when this complete package will give you everything you need! Boost your career and stand out from others in crowd!!

1. Microsoft Word (Basic course)

2. Microsoft Word (Advanced course)

2. Microsoft Excel (Basic course)

4. Microsoft Excel (Advanced course)

3. Unlock Macros & VBA Programming course

4. Microsoft Outlook - Basic & Advanced

5. Microsoft PowerPoint - Basic & Advanced

Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course:

Looking for an online Excel course to improve your skills and save time but don't know where to start?
I have picked out the Excel Essential skills and packaged them in a structured course.
I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects.

Microsoft Word complete Package - Don't use just Word, learn tips and tricks with this course to be a smart user. This course includes basic level, intermediate level and advanced level of MS Word. Enroll now to go from beginning to Advanced user. At completion of this course you will have mastered the Microsoft Word.

Microsoft Excel:

By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to:

Input Data and Navigate Large Spreadsheets
Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
Apply Excel hacks to get your work done faster
Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more)
Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions
Get Answers from your Data
Organize, Clean and Manage Large Data
Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines
Import & transform data with tools like Get & Transform (Power Query)
Manipulate dates, times, text, and arrays
Reduce manual routine tasks to the click of button
VBA programming & read, write own Macro to automate the tasks

We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn:

Useful Excel shortcuts for data entry and navigation.
Protect your Excel files and worksheets properly.
To apply formatting correctly for cleaner and more professional reports.
To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell.
Add Comments & Notes to cells & how to print the same if needed.
Add Data & time Stamps to your reports.
Lookup/Reference Functions.
Statistical Functions.
Logic Functions.
Text Functions.
Date & Time Functions.
The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more.
Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.)
Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data.
What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets
Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data.
Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables.
Import data from Text File.
Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons.
More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced.

Microsoft Word:

At completion of this course you will have mastered the most popular and sought after Microsoft Word tools and come away with confidence to complete many Word tasks with efficiency and grace. Below are just a few of the topics you will master.

Highlights:

Creating Dynamic Microsoft Word Documents
Effectively Formatting a Document with Styles
Prepare Documents for Printing and Exporting
Manage Large Documents
Working with Page and Section Breaks
Control Page Orientation
Create and Manage Table Layouts
Work with Tab Stops to Align Content Properly
Insert Media and Images
Perform Mail Merges to create Mailing Labels and Form Letters
Manage Templates
Protect Documents from Edits
Track and Accept/Reject Changes to a Document
Build Dynamic Table of Contents
and much, much more...

Microsoft Outlook:

Outlook is an essential office software and understanding it fully is the best way to keep your daily correspondence running smoothly. This online course will help you learn tips and tricks for sending and organizing email, reducing inbox clutter, how to manage your calendar, contacts and tasks to maximize efficiency.

Highlights:

Office management tips to monitor inbox size, set up auto-archive, search for and organize email in folders and groups.
Best practices for sending, receiving, and saving attachments.
Set up email signatures and explore options such as read receipts and delayed send.
Stay organized by using the calendar to schedule appointments, meetings, and events.
Add and group contacts; create, assign, and filter tasks.
Design Quick Steps to save time on repetitive yet unavoidable office tasks.
Use mail merge to send personalized emails automatically to an entire list.
Back up your Outlook file, export contacts and set up additional email accounts.

Microsoft PowerPoint:

Material was recorded using Microsoft PowerPoint 2019 but is relevant to PowerPoint 2010, 2013 and 2016. MAC users, since the videos are recorded with the Windows version of Microsoft PowerPoint, the interface will be a bit different.

This Course Includes 3 Sections

Microsoft PowerPoint 101 - Introductory Level
Microsoft PowerPoint 102 - Intermediate/Advanced Level
Microsoft PowerPoint 103 - Tips and Tricks

At completion of this course you will have mastered the most popular and sought after Microsoft PowerPoint tools and come away with confidence to complete many PowerPoint tasks with efficiency and grace. Below are just a few of the topics you will master:

Build and Deliver Effective PowerPoint Presentations
Integrate Data from other Microsoft Office Applications
Pick the Proper PowerPoint Slide Layouts for your Content
Animate PowerPoint Content without Distracting the Audience
Automate PowerPoint Formatting and Slide Layouts with Master Slides
and much, much more...

So, what are you waiting for, enroll now and take the next step in mastering Microsoft office essential tools and go from Newb to Guru!

What differentiates this course from other Courses?

Yes, there are many Microsoft Office Courses out there teaching you the important functions and features you need to master. BUT, do you get step-step-step learning with of Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft PowerPoint with Quizzes, Exercises and VBA programming all in one course?

So, what are you waiting for? Enroll Today and take the next step in mastering Excel, Word, Outlook, PowerPoint and VBA Programming. Boost your career and stand out from others in crowd. Go from Novice to Ninja in all this complete package of Microsoft Word, Microsoft Excel, Microsoft Outlook, Microsoft Powerpoint, Macros & VBA! Become a certified Microsoft Office specialist and be a Excel, Word, Outlook, Powerpoint & VBA Ninja Today.

The course comes with lifetime access. Buy now. Watch anytime.

Who this course is for:

This is being utilized in almost every office in the world, thus offers a great scope. Excel, Word, PowerPoint, Outlook are highly used in decision making and a kind of analysis tool that represents data into graphical form.
This online course is suitable for anyone who wants to learn Excel from Scratch to VBA Programmer in order to edit the recorded macro for automating the tasks.
This MS Office Course will take you through 4 levels of Microsoft Word, Excel, Outlook & PowerPoint Topics (Beginner, Intermediate, Advanced and Beyond).
Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help to take your skills to the next level.

Microsoft Office Certification Mastery: From Novice to Ninja

What you'll learn

Explore related topics

Course content

Microsoft Outlook: An Introduction to Outlook4 lectures • 20min

Emails - Sending and Receiving6 lectures • 29min

Email - Organizing9 lectures • 50min

Microsoft Outlook: Calendar8 lectures • 43min

Microsoft Outlook: Contacts7 lectures • 39min

Microsoft Outlook: Task and Notes4 lectures • 19min

Microsoft Outlook: Advanced Features5 lectures • 30min

Microsoft PowerPoint: Interface and Basics6 lectures • 35min

Microsoft PowerPoint: Adding Text and Shapes6 lectures • 32min

Microsoft PowerPoint: Pictures3 lectures • 15min

Requirements

Description

Who this course is for: