Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Microsoft Office Pro Plus Training Video “Includes Software”

Microsoft Office 2021 Bundle: Training Tutorials ** SOFTWARE INCLUDED ** Microsoft Office Pro Plus 2021 1PC License
0.0
☆☆☆☆☆ 0.0/5
(0 reviews)
1 students
Created by
Ed Gamble

9.5

CourseMarks Score®

10.0

Freshness

N/A

Feedback

8.5

Content

Detailed Analysis »

Microsoft Office 2021 Bundle: Training Tutorials ** SOFTWARE INCLUDED ** Microsoft Office Pro Plus 2021 1PC License
Go to class »
Platform: Udemy
Price: check current price
Video: 24h 27m
Language: English
Next start: On Demand

Table of contents

Description

  What you'll learn
  Requirements
  Who this course is for
Instructor
Recommended courses

Description

Microsoft Office 2021 Bundle: Training & Beginners Tutorials ** SOFTWARE INCLUDED ** Microsoft Office Pro Plus 2021 1PC/Windows ( Not For Mac OS )
( 1 PC/Windows, Download Direct From Microsoft Website )
•Word 2021
•Excel 2021
•PowerPoint 2021
•OneNote 2021
•Outlook 2021
•Publisher 2021
•Access 2021

**This course includes practice exercises and LIFETIME access**
Learn Excel, PowerPoint, Access, Outlook, Teams, OneNote, and Word with this tremendous value 9-course bundle from Simon Sez IT.
The Microsoft Office suite is used by millions worldwide. Unlocking its full potential could see you drastically improve your productivity.
But you know all that because you’re on this page.
Instead, you’re probably wondering whether we’re the right team to teach you Office.
Simon Sez IT has been teaching MS Office for over 13 years, and we’ve got pretty good at it. Just take a look at our Udemy ratings if you don’t believe us.
For this Ultimate Microsoft Office 2019 course, we’ve bundled together 9 of our best-selling titles into one huge value offering.
You don’t just get access to beginner courses either. You get advanced training in Microsoft Excel and Microsoft Access and a comprehensive grounding in Microsoft PowerPoint, Microsoft Outlook, Microsoft Teams, Microsoft Word, and Microsoft OneNote.

What’s covered in each course?
Microsoft Excel
•What’s new in Excel
•Creating workbooks
•Entering text, numbers and working with dates
•Navigating workbooks
•Page setup and print options
•Working with rows, columns, and cells
•Cut, Copy and Paste
•Introduction to Functions and Formulas
•Formatting in Excel, including formatting cells and numbers
•Creating charts and graphs
•Sorting and Filtering
•Introduction to PivotTables
•Logical and lookup formulas – the basics

Advanced Microsoft Excel
•What’s new/different in Excel
•Advanced charting and graphing in Excel
•How to use detailed formatting tools
•Lookup and advanced lookup functions
•Financial functions including calculating interest and depreciation
•Statistical functions
•Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
•How to create awesome visualizations using sparklines and data bars
•Mastery of PivotTables and Pivot Charts
•Scenario Manager, Goal Seek, and Solver
•Advanced charts such as Surface, Radar, Bubble, and Stock Charts

Microsoft PowerPoint
•How to navigate around PowerPoint
•Presentation dos and don’ts
•Text and bullet edition options
•How to use graphics, images, objects, and shapes
•Using SmartArt
•Working with Charts and Graphs
•How to utilize Master Slides and just how much time this could save you
•How to add audio and video to a presentation
•All about transitions between slides
•Animation, the animation pane, and motion paths
•Setting your slideshow options
•Presentation preparation and delivery
•The backstage area of PowerPoint including printing a presentation

Microsoft Word
•How to get started with Word
•Word 2019 basics including navigation, editing, and saving
•Character formatting in Word including Format Painter and AutoCorrect
•How to properly work with bullets and numbering in Microsoft Word
•All about formatting paragraphs and managing lists
•Working with Tables in Word including formatting, converting data and formulas
•Page appearance including page-breaks, watermarks, and styles
•All about Sectioning a document
•Inserting graphics, pictures, shapes, icons, and 3d models (new for 2019)
•How to work with envelopes and labels
•All about mail-merge and operating Word at scale
•How to create an Index or Contents page
•Reviewing and Printing in Word and Page Setup
•Protecting a Word document and basic macros in Word

Microsoft Access
•Where to start in Microsoft Access and whether to use a template or not
•How to modify Access to suit your needs
•All about importing data and the datasheet view
•How tables work in Access and how to create relationships between them
•Creating forms and sub-forms that feed data into your tables
•How to run queries in Access
•Setting up validations and calculations using expressions in Access
•Printing from Access
•To start to use macros and Modal Dialog
•The basics of the Access web app
•Exporting and reporting in Access

Microsoft Publisher
• Working with Microsoft Publisher Environment + Creating and Working with a Publicatio
• Creating and Working with Text in a Publication
•Creating, Formatting and Managing Text in a Publication
•Working with Layouts in a Publication
•Working with Tables in a Publication + Graphics and Designs

Microsoft Outlook
•How to get set up in Outlook
•Some useful Outlook keyboard shortcuts
•All about sending and receiving emails
•How to customize your mailbox and view
•How to search in Outlook
•How to organize and manage your mail including ignoring, flagging, and conditional formatting
•How to effectively deal with Junk Mail
•Attaching files, photos, and graphics in Outlook
•About recalling a message
•How to use signatures and voting buttons
•How to best use, add to, and manage contacts
•Working with the Outlook Calendar, including creating meetings and appointments
•How to share Calendars with colleagues
•How to use Tasks in Outlook
•How to create Notes and link Outlook to OneNote
•How to print the right thing in Outlook

Microsoft Teams
•How to access, download and set up Teams
•How to create your first team and manage members and channels
•All about posting and receiving public and private messages
•How to do user announcements, tags, and message extensions
•How to schedule an audio or video call
•How to use the audio and video calling options including recording calls
•How to use the meeting notes function
•How to create a wiki
•All about using apps, bots, and connectors
•How to adjust admin and user settings
•How to use Teams on your mobile device

Microsoft OneNote
•How to get started using OneNote Desktop or OneNote Windows 10
•How to add text, videos, images, clips, and links to OneNote
•How to use the screen clipping tool in OneNote
•How to format notes in OneNote
•How to create a to-do list in OneNote
•How to add tags in OneNote and search for content
•How to link notes in OneNote
•How to format pages in OneNote
•How to use the pen tools in OneNote, including handwriting to text
•How to link OneNote with Outlook
•How to share notebooks in OneNote
•How to collaborate using OneNote
•How to customize your options in OneNote
•About using OneNote Online and the OneNote App

You will learn

✓ Learn Microsoft Office Skills in this 20 hour-course Bundle: Excel, Word, PowerPoint, OutLook ” Microsoft Office Pro Plus 2021 1PC Software License Included “
✓ Learn to protect your Word document from changes
✓ How to create a mail merge in Microsoft Word
✓ Master the most common uses of Microsoft Word
✓ Manage Large Sets of Data in Microsoft Access Relational Design
✓ Control User Data Entry Effectively
✓ Present Dynamic Reports
✓ Build an Efficient Database Table Design
✓ Build Dynamic Access Database Queries
✓ Build Automation, Saving Time and Money
✓ Create Publications
✓ Add, Delete, and Format Objects, Add, Delete, Modify, and Format Text
✓ Use Building Blocks,Customize Schemes Use Tables Adjust Page Setup and Layouts
✓ Create and send email messages, Schedule and organize Events and Appointments
✓ Create, update and completing Tasks, Create, categorize and organize Contacts
✓ Schedule Meetings, track replies and send updates
✓ Taught by Certified Microsoft Office Outlook 2000, 2002, 2003, 2007, 2010, 2013, 2016, 2019 and 2021 Specialist with over 18 years of Outlook training
✓ Insert professional pictures and graphics in your Word document
✓ Learn how to correctly Print envelopes and labels in Word
✓ How to controlling page appearance including using columns, indents, footers, borders and watermarks.
✓ Discover the essentials of using formulas and functions

Requirements

• Word, Excel,PowerPoint, outlook, Access, Publisher and OneNote installed on your PC or Laptop. Preferably Office 2021 or Office 365 ” Microsoft Office Pro Plus 2021 1PC Software License Included “

This course is for

• Anyone new to Microsoft Office or upgrading from a previous version
• Anyone looking to improve their productivity by mastering Microsoft Office Beginning and Advanced
• Microsoft Office Online Beginners Training Bundle with Bonus Material Microsoft Office Software License included
• Valid only within USA and Canada. This is a Microsoft forever Office License and will never expire (No Subscription Required). The software will bind with your Microsoft account and email address once you complete your installation.

More info about the instructor,

Ed Gamble

Learn Microsoft Office Suites ” Software License Included “
We have been teaching Microsoft office suites since 2005, learning Microsoft made easy with our tutorials and training video courses plus each course includes a genuine Microsoft software license which will include: Excel, Word, PowerPoint, OneNote, Access, Publisher, OutLook. Only Microsoft Office Pro Plus will include Access and Publisher.
Valid only within USA and Canada. This Training Course Includes a Microsoft forever Office License and will never expire (No Subscription Required). The software will bind with your Microsoft account and email address once you complete your installation.

A proven Master Teacher in the field of Technology and Software. Generate productivity and efficiency by removing the frustration from technical woes. The ability to simplify complexity. Involved and sympathetic to understanding client’s needs; dependable, solid communication and interpersonal skills, ability to be personable yet persistent; excellent rapport with various agencies, officials and key personalities in the San Francisco Bay Area communities; self-motivated and enthusiastic; highly inventive; poised and confident; team player, leader, and motivator who is dedicated to pursuing goals while recognizing accomplishments on an individual and group level; ability to multitask and adapt to various situations efficiently, attention to detail in every facet of program development and administration; organizational skills with a tenacious work ethic; service and results-oriented with a dash of humor.
Ed Gamble's full profile and courses »
Go to class »
Microsoft Office 2021 Bundle: Training Tutorials ** SOFTWARE INCLUDED ** Microsoft Office Pro Plus 2021 1PC License
Go to class »
Platform: Udemy
Price: check current price
Video: 24h 27m
Language: English
Next start: On Demand

Students are also interested in

Go to class »