IIRF Online > Office Productivity > Microsoft > Microsoft 365 (Office) > Ultimate Microsoft Office; Excel, Word, PowerPoint & Access
Ultimate Microsoft Office; Excel, Word, PowerPoint & Access by Udemy
Learn basic to advanced Microsoft Office skills in this 9-course bundle for Office 365 or Office 2019
Course Highlights
- Learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint, Outlook, Teams and Access
- HUGE Value Bundle - Eight Courses!
- Learn practical methods to backup and recover your Excel spreadsheets and never lose data
- Effectively use autofill and flashfill so you are more productive in Microsoft Excel.
- Discover the essentials of using formulas and functions in Excel
- Discover how to create stunning charts and graphs in Excel
- Learn practical methods to sort and filter your data in Excel
- Discover new features in PowerPoint 2019 including Icons and 3D Models
- Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint
- Add charts, graphs and tables to your PowerPoint presentation information in a non-text format
- Wow your audience by adding animations, audio and video to PowerPoint
- Discover practical tips to present your PowerPoint presentation to your audience
- Learn time saving techniques including how to copy slides, and exporting your presentation
- Master the most common uses of Microsoft Word
- Learn Word tools including using columns, indents, footers, borders and watermarks.
- How to create a mail merge in Microsoft Word
- Learn how to correctly Print envelopes and labels in Word
- Learn to protect your Word document from changes
- Insert professional pictures and graphics in your Word document
- Make your Word documents look amazing by inserting and editing tables
- Sorting information and running queries in Access
- Navigating the Access 2019 interface
- Discover how to into import data from Excel in Access
- Learn Queries, use validations, how to create and print reports in Access
- How to compact, repair and backup your Access database
- How to create a linked table in Access
- How to get set up in Outlook
- All about sending and receiving emails
- How to customize your mailbox and view
- How to organize and manage your mail including ignoring, flagging and conditional formatting
- How to organize and manage your mail including ignoring, flagging and conditional formatting
- Creating and managing tasks and reminders
- How to use signatures and voting buttons
- Adding, managing and searching contacts in the address book
- Working with the Outlook Calendar, including creating meetings and appointments
- How to create Notes and link Outlook to OneNote
Skills you will learn!
Curriculum
10 Topics
Intro to Excel
WATCH ME: Essential Information for a Successful Training Experience
Course Exercise Files
Downloadable Course Transcript
What's New In Excel 2019
Course Overview
Overview of the Excel window
Mouse-Features
Back Stage View
Section Quiz
7 Topics
Entering Text and Numbers
Creating Basic Formulas
Relative References
Order of Operations
Working with Ranges
Module 2 - Practice Exercise
Section Quiz
4 Topics
Working with the Save and Save As Commands
File Extensions Share Export and Publish Files
Module 3 - Practice Exercise
Section Quiz
6 Topics
Opening a File
Working with Larger Files
Freeze Panes Option
Split Screen Option
Module 4 - Practice Exercise
Section Quiz
8 Topics
Headers and Footers
Print Titles
Comments
Page Setup Options
Fit to Print on One Page
Printing Workbooks
Module 5 - Practice Exercise
Section Quiz
4 Topics
Adding and deleting rows columns and cells
Changing Column and-Row Widths
Module 6 - Practice Exercise
Section Quiz
4 Topics
Cut Copy and Paste
Copying Formulas
Module 7 - Practice Exercise
Section Quiz
6 Topics
Overview of Formulas
Create Formulas Using Functions Part 1
Create Formulas Using Functions Part 2
Absolute Values
Module 8 - Practice Exercise
Section Quiz
5 Topics
Adding Deleting and Renaming Sheets
Additional Sheet Tab Options
3 Dimensional Formulas
Module 9 - Practice Exercise
Section Quiz
11 Topics
Formatting Cells Part 1
Formatting Cells Part 2
Formatting Numbers
Borders and Shading
Format as Table
Using Styles
Using Format Painter
Protecting Sheets
Fill Handle and Custom Lists
Module 10 - Practice Exercise
Section Quiz
8 Topics
Creating Charts
Types of Charts
Editing Charts Part 1
Editing Charts Part 2
Using Graphics to Enhance Charts
Linking Chart Titles
Module 11 - Practice Exercise
Section Quiz
5 Topics
Creating Range Names
Managing Names
Using Names in Formulas
Module 12 - Practice Exercise
Section Quiz
6 Topics
Remove Duplicates
Sort Data
Filter Data
Advanced Filters
Module 13 - Practice Exercise
Section Quiz
4 Topics
Creating an Outline
Subtotals
Module 14 - Practice Exercise
Section Quiz
5 Topics
Arranging Files
New Window Option
Custom Views
Module 15 - Practice Exercise
Section Quiz
5 Topics
Creating Formulas Between File
Working with Links
Consolidating Data
Module 16 - Practice Exercise
Section Quiz
6 Topics
If Statements
VLookups
Data Validation
Formula Auditing
Module 17 - Practice Exercise
Section Quiz
4 Topics
Pivot Tables
Pivot Charts
Module 18 - Practice Exercise
Section Quiz
7 Topics
Slicers
Goal Seeker
Text to Columns
Watch Window
Customizing Ribbons and Tabs
Module 19 - Practice Exercise
Section Quiz
1 Topic
Excel Shortcuts Every User Should Know
1 Topic
Closing Video
6 Topics
Introduction to the Course
WATCH ME: Essential Information for a Successful Training Experience
Excel 2019 Advanced Course Exercise Files
Excel 2019 Advanced Course Demo Files
Downloadable Course Transcripts
Course Structure
4 Topics
Functions - Part 1
Functions - Part 2
Autosum
Section Quiz
4 Topics
How Date and Time Works
Basic Date and Time Functions
Complex Date and Time Functions
Section Quiz
3 Topics
Using Text Functions - Part 1
Using Text Functions - Part 2
Section Quiz
3 Topics
Logical Functions
Exercise 01
Section Quiz
4 Topics
Lookup Functions - Part 1
Lookup Functions - Part 2
Exercise 02
Section Quiz
6 Topics
Financial Functions and Terminology
Personal Financial Functions
Principal and Interest Payments
Depreciation
Exercise 03
Section Quiz
8 Topics
Statistical Functions for Description - Part 1
Statistical Functions for Description - Part 2
Statistical Functions for Forecasting - Part 1
Statistical Functions for Forecasting - Part 2
Exercise 04
One Click Forecasting
Statistical Functions for Inference
Section Quiz
6 Topics
Connecting to Other workbooks
Connecting to Access Databases
Connecting Web Data Sources
Get and Transform
Exercise 05
Section Quiz
6 Topics
Introduction to Tables
Working with Tables
Table References
Table Styles
Exercise 6
Section Quiz
6 Topics
Introduction to Pivot Tables
Working with Pivot Tables
Filters and Slicers
Pivot and Charts
Exercise 07
Section Quiz
6 Topics
What If Analysis
Scenario Manager
Goal Seek
Solver
Exercise 08
Section Quiz
8 Topics
Area Charts
Surface Charts
Radar Charts
Bubble Charts
Sparklines
Stock Charts
Exercise 9
Section Quiz
3 Topics
Web App - Part 1
Web App - Part 2
Section Quiz
1 Topic
Close
6 Topics
Welcome and Overview
WATCH ME: Essential Information for a Successful Training Experience
Course exercise files
Downloadable Course Transcripts
Overview of the MS Word Screen
The Backstage View
9 Topics
Creating a New Blank Document
Working with Non-Printing Characters and Line Spacing
Saving a Document
Opening a Document
Navigating a Document
Go To Find and Replace
Editing a Document
Practice Exercise
Section Quiz
9 Topics
AutoCorrect Options
Selecting Text
Cut Copy and Paste
Character Formatting Options
Format Painter
Working with Numbers
Working with Bullets
Creating an Outline
Practice Exercise
6 Topics
Alignment Options
Line Spacing Options
Working with Indents
Working with Tabs
Practice Exercise
Section Quiz
1 Topic
Sorting a List
12 Topics
Working with Tables
Creating a Table
Adding Rows and Columns to a Table
Formatting Table Data
Borders and Shading
Sorting in a Table
Drawing in a Table
Converting Existing Data to a Table
Quick Tables
Using Formulas in Tables
Practice Exercise
Section Quiz
5 Topics
Working with Styles
Creating Styles
Editing Styles
Practice Exercise
Section Quiz
5 Topics
Working with Page Breaks
Working with Columns
Adding a Watermark
Headers and Footers
Section Quiz
5 Topics
What is Sectioning?
Sectioning a document
Odd and Even Sections
Practice Exercise
Section Quiz
8 Topics
Inserting Pictures
Inserting Pictures into Existing Documents
Picture Options
Working with Shapes
Icons and 3D Models
SmartArt Charts and Screenshots
Practice Exercise
Section Quiz
3 Topics
Working with Envelopes
Working with Labels
Section Quiz
8 Topics
What is Mail Merge?
Creating a Mail Merge Document - Part 1
Creating a Mail Merge Document - Part 2
Merging a Document with an Existing Data Source
Merging Envelopes and Labels
Merging a Directory
Practice Exercise
Section Quiz
4 Topics
Building Blocks
Auto Text
Practice Exercise
Section Quiz
4 Topics
Creating an Index
Creating a Table of Contents
Practice Exercise
Section Quiz
6 Topics
Using the Thesaurus and Spell Check
Comments
Page Setup Options
Printing
Practice Exercise
Section Quiz
3 Topics
Word Options
Protecting a Document
Macros
1 Topic
Closing
4 Topics
Welcome and Overview
WATCH ME: Essential Information for a Successful Training Experience
Course Exercise Files
Downloadable Course Transcripts
3 Topics
Navigate a PowerPoint Presentation
Overview of the Screen and Views
Exercise 1
6 Topics
Presentation Tips and Guidelines
Creating a New Presentation
Working with Slides
Saving a Presentation
Exercise 02
Section Quiz
4 Topics
Formatting Text
Working with Bullets and Numbered Lists
Exercise 03
Section Quiz
6 Topics
Inserting Shapes
Inserting Graphics
Inserting Icons and 3D Models
Inserting Pictures
Exercise 04
Section Quiz
8 Topics
Selecting Objects
Editing Objects
Formatting Objects - Part 1
Formatting Objects - Part 2
Arranging Objects
Grouping Objects
Exercise 05
Section Quiz
6 Topics
Picture Options
Cropping Pictures
Formatting Pictures
Things You Can Do with Pictures
Exercise 06
Section Quiz
5 Topics
Creating SmartArt
Modifying SmartArt
Creating a Flowchart using SmartArt
Exercise 07
Section Quiz
5 Topics
Creating Tables
Formatting Tables
Inserting Tables
Exercise 08
Section Quiz
5 Topics
Adding Charts
Formatting Charts
Inserting Charts from Microsoft Excel
Exercise 09
Section Quiz
5 Topics
Using Master Slides
Modifying Master Slides
Creating a New Master Design Template
Exercise 10
Section Quiz
4 Topics
Adding Video to a Presentation
Adding Audio to a Presentation
Exercise 11
Section Quiz
4 Topics
Applying Transitions
Transition Options
Exercise 12
Section Quiz
7 Topics
Animating an Object
Effect Options
Working with the Animation Pane
Motion Paths
Triggers
Exercise 13
Section Quiz
4 Topics
Working with Action Buttons
Working with Hyperllinks
Exercise 14
Section Quiz
6 Topics
Onscreen Presentation Options
Hiding Slides
Changing the order of slides
Copying slides
Slideshow Options
Exercise 15
5 Topics
Rehearse Timings
Recording a Presentation
Slide Show Settings
Creating a Custom Slide Show
Exercise 16
4 Topics
Exporting options
The Backstage Area
Printing a Presentation
Exercise 17
1 Topic
Conclusion
8 Topics
Introduction to Access 2019
WATCH ME: Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Downloadable Course Transcripts
Acquiring Access 2019
Structure of the Course
Section Quiz
5 Topics
Using Database Templates
Creating Saving and Opening Databases
The Access Workspace and Backstage
Online Help and Tell Me What You Want To Do
Section Quiz
5 Topics
Working with the Ribbon
The Quick Access Toolbar
Contextual Menus
The Status Bar
Section Quiz
3 Topics
Keyboard Shortcuts
Key Tips
Section Quiz
2 Topics
Exploring Access Options
Section Quiz
6 Topics
Creating a Table and Fields
Indexed Field
Lookup Wizard
Numeric Fields
Practice Exercise 01
Section Quiz
3 Topics
Importing Data from Excel
Practice Exercise 02
Section Quiz
3 Topics
Backing up your Database
Compact and Repair
Section Quiz
4 Topics
Design in the Datasheet View
Sorting and Filtering in Datasheet View
Entering and Modifying Data in Datasheet View
Section Quiz
4 Topics
Creating a Link Table
Setting up Relationships
Exercise 03
Section Quiz
8 Topics
Creating a Form
Modifying a Form
Practice Exercise 04
Forms in Layout View
Forms in Design View
Form Design
Practice Exercise 05
Section Quiz
5 Topics
Setting Up Subforms - Part 1
Setting Up Subforms - Part 2
Setting Up Subforms - Part 3
Practice Exercise 06
Section Quiz
5 Topics
Creating a Query
Joins
Query Wizard
Practice Exercise 07
Section Quiz
3 Topics
Setting Up Validations
Calculation using Expressions
Section Quiz
5 Topics
Basic Reports
Report Design
Complex Reports
Practice Exercise 08
Section Quiz
2 Topics
Printing and Print Properties
Section Quiz
2 Topics
Yes/No OLE Objects and Hyperlink Data Types
Section Quiz
4 Topics
Form Controls
Form Themes
Navigation Forms
Section Quiz
2 Topics
Exporting an Access Database
Section Quiz
1 Topic
Adding Application Parts to a Database
2 Topics
Additional Access 2019 Options
Section Quiz
2 Topics
Edit Database Properties and Encrypt with Password
Section Quiz
1 Topic
Course Close
6 Topics
Course Overview and Content
WATCH ME: Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Downloadable Course Transcripts
Section Quiz
3 Topics
Primary Keys and Indexing Rules and Guidelines
More About Indexes
Section Quiz
6 Topics
Setting-up Northwind Database
Working in a Datasheet View
Customizing Datasheet View and Advanced Sorting and Filtering
Subdatasheets
Exercise 01
Section Quiz
2 Topics
Linking Two Tables to Other Access Databases
Section Quiz
4 Topics
Acquiring and Installing SQL Server Express
Setting Up SQL Server Database
Exercise 02
Section Quiz
5 Topics
Splitting an Access Database into Front-end and Back-end
Converting Shared Table into Local Table; Moving Back-end Database
Exercise 03
Addressing Multi-user Issues when Sharing Data
Section Quiz
6 Topics
Basics of Macros
Macros on Events; AutoExec
More About AutoExec; Bypassing AutoExec
Macro Security Settings
Exercise 04
Section Quiz
2 Topics
Customizing the Ribbon and Quick Access Tool
Section Quiz
6 Topics
Convert Macros to VBA; VBA Editor and Property Windows
VBA Modules; Running Code and Error Handling
Creating Modules; Subs Functions Intellisense and Variables
Scope Variable Naming and Strings
Standard Functions; Logical Case and Loop Statements
Section Quiz
6 Topics
Adding Events to Assets Database
Exercise 05
Common Events; Form and Report Events
Switchboard and Navigation Form; Error Handling
Exercise 06
Section Quiz
6 Topics
Formatting Bound and Control Form
Split Forms; Macro Error Handling
Creating Form with Tab
Go To Combo Box and Its Properties
Exercise 07
Section Quiz
7 Topics
Basics of Queries
Syntax of SQL Statements
Use of Multiple Where Criteria & Select Statements Function
Exercise 08
Action Queries - Part 1
Action Queries - Part 2
Section Quiz
3 Topics
Steps in Packaging Access Application
Exercise 9
Section Quiz
1 Topic
Course Close
8 Topics
An Overview of Outlook 2019
READ ME: Essential Information for a Successful Training Experience
Downloadable Course Transcripts
Outlook 2019 vs Outlook Online in Office 365
What to Expect from this Course
Getting Help with Outlook 2019
Keyboard Shortcuts
Section 1 Quiz
5 Topics
Navigating the Outlook Interface
The Ribbons and the Quick Access Toolbar
Adding an Email Account
Practice Exercise 01
Section 2 Quiz
7 Topics
Sending and Receiving Mail
Focused Inbox
Customizing the Inbox
Saving Attachments
Customizing Mail Views
Practice Exercise 02
Section 3 Quiz
4 Topics
Searching Mail
Creating Search Folders
Practice Exercise 03
Section 4 Quiz
11 Topics
Ignoring Conversations
Deleting Archiving and Restoring Mail
Cleaning Up Conversations
Using Follow Up Flags and Categories
Organizing Mail with Folders and Subfolders
Using Quick Steps to Process Mail
Working with Conditional Formating and Mail
Auto-Process Mail using Rules
Managing Junk Mail
Practice Exercise 04
Section 5 Quiz
11 Topics
Creating a New Mail Message
Attaching Files Photos Graphics and Other Items
Directing Mail with @mentions
Recalling a Message
Making decisions with Voting Buttons
Adding an Email Signature
Delivery Options
Sending Automatic Replies
Navigating using Hyperlinks and Bookmarks
Practice Exercise 05
Section 6 Quiz
6 Topics
Adding a New Contact
Utilizing the Contact Card
Creating a Contact Group
Managing Contacts using Folders
Practice Exercise 06
Section 7 Quiz
8 Topics
Overview of the Calendar and Views
Customizing the Look and Feel
Creating an Appointment or All Day Event
Creating a Meeting and Inviting Others
Responding to Meeting Invites
Sharing Calendars and Delegating Access
Practice Exercise 07
Section 8 Quiz
6 Topics
Creating a New Task
Assigning and Completing Tasks
Creating Notes
Working with OneNote
Practice Exercise 08
Section 9 Quiz
4 Topics
Opening and Exporting Data
Printing
Customizing Outlook Options
Section 10 Quiz
1 Topic
Course Close
1 Topic
BONUS Lecture
8 Topics
What is Microsoft Teams and why is it useful?
READ ME: Essential Information for a Successful Training Experience
Downloadable Course Transcripts
What to Expect from this Course
How to access/download Teams
Overview of the Teams Dashboard
Getting Help with Microsoft Teams
Section 122 Quiz
16 Topics
Create a Team and Add Internal and External Team Members
Join an Existing Team
Manage teams and members
Create and Manage Channels
Post and Receive Messages
Target messages using @mentions
Editing and Deleting Messages
Bookmark and Like Messages
Add images emojis aand gifs to messages
Formatting Messages
Make a Announcement
Using Tags
Attaching Files and Images
Send a Private Message
Add Messaging Extensions
Section 123 Quiz
7 Topics
Video and Audio Calls on Demand
Sharing Files
Schedule a Meeting
Schedule a Live Event
Record a Video Meeting or Call
Notes
Section 125 Quiz
4 Topics
Use the Wiki tab to share information
Using apps bots and connectors
Customizing Channel Tabs
Section 125 Quiz
3 Topics
Use Search to find specific messages files or people
Using Quick Commands
Section 126 Quiz
3 Topics
Adjust user settings
Explore the administration settings
Section 127 Quiz
2 Topics
Working with the Teams Mobile App
Section 128 Quiz
16 Topics
Out of Office
Notification Settings
Bypass the Lobby (Invitees)
Control Attendees Mic Settings
Share to Teams from Outlook
Meet Now from the Calendar
Recap of Meeting
Use Grid View to share PowerPoint Content
View Activity History
Feel Connected with Together Mode
Apply Background Effects
React to Conversations with Emojis
Publish a Company-wide Task list
Approvals
Breakout Rooms
Section Quiz
1 Topic
Course Close
8 Topics
What to Expect from this Course
READ ME: Essential Information for a Successful Training Experience
Downloadable Course Transcripts
OneNote Versions
Working with Keyboard Shortcuts
Customizing the Quick Access Toolbar
Using Touch Mode
Section Quiz
10 Topics
Opening a OneNote notebook and Touring the Interface
Creating a OneNote Notebook
Changing Notebook Properties and Closing
Deleting a Notebook Stored in OneDrive
Creating and Managing Locally Stored Notebook
Creating Moving and Deleting Sections
Creating Section Groups
Working with Pages and Subpages
WINDOWS 10: Getting Started with OneNote
Section Quiz
13 Topics
Creating a Note on a Page
Sending Content to OneNote
Using the OneNote Clipper
Using the Screen Clipper
Adding Pictures and Online Pictures
Embedding Online Video
Adding Files
Recording Audio and Video
Inserting Links
Inserting Equations and Symbols
Copying and Pasting Content
WINDOWS 10: Adding Content
Section Quiz
8 Topics
Formatting Text
Using the Format Painter
Using Styles
Organize Content with a Table
Creating a Todo List
Checking Spelling
WINDOWS 10: Formatting Notes
Section Quiz
6 Topics
Searching a Notebook
Tagging Notes
Organizing the Interface
Linking Notes
WINDOWS 10: Organizing Content
Section Quiz
6 Topics
Page Setup Options
Changing the Page Color and Background
Customizing Fonts Themes and the Interface
Setting Paper Size
WINDOWS 10: Formatting Pages
Section Quiz
4 Topics
Applying a OneNote Template to a Page
Creating Your Own Template
WINDOWS 10: Working with Templates
Section Quiz
5 Topics
Working in Pen Mode
Drawing Shapes with Touch
Converting Handwriting to Typed Text
WINDOWS 10: Using Drawing Tools
Section Quiz
5 Topics
Working with Outlook Tasks
Outlook Meetings and Meeting Notes
Sending Page Information by Email
Windows 10: Interacting with Outlook
Section Quiz
7 Topics
Saving to OneDrive
Inviting Others to a Notebook
Converting Notebooks to Other Formats
Exporting OneNote Content
Synching Notebooks
WINDOWS 10: Sharing a Notebook
Section Quiz
5 Topics
Author Indicators
Page Versions
The Notebook Recycle Bin
WINDOWS 10: Collaborating on a Notebook
Section Quiz
5 Topics
Customizing OneNote Options
Password Protection
Setting Backup Options
WINDOWS 10: Setting OneNote Options
Section Quiz
3 Topics
Using OneNote Online
Working with OneNote Mobile app
Section Quiz
1 Topic
Course Close
8 Topics
EXTRA LESSON: Designing Better Spreadsheets Webinar Recording
EXTRA LESSON: Data Cleaning in Excel Webinar Recording
EXTRA LESSON: Top Ten Excel Functions You HAVE to Know Webinar Recording
EXTRA LESSON: Creating Engaging PowerPoint Presentations Webinar Recording
EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic
EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic
EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic
EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic
4 Topics
READ ME: This Additional Training Is Optional
Ten Excel Tips and Tricks - Part 1
Ten Excel Tips and Tricks - Part 2
Ten Excel Tips and Tricks - Part 3
Ultimate Microsoft Office; Excel, Word, PowerPoint & Access
Related Microsoft 365 (Office) Courses
Thank You!
Your review has been submitted successfully.