Rating 5.0 out of 5 (1 ratings in Udemy)
What you'll 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 …
Rating 5.0 out of 5 (1 ratings in Udemy)
What you'll 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
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
Paid
Self paced
All Levels
English (US)
1
Rating 5.0 out of 5 (1 ratings in Udemy)
Go to the Course