Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

BY
Udemy

Acquire a thorough understanding of both basic and advanced principles and methodologies related to Microsoft Office 365 or Office 2019.

Mode

Online

Fees

₹ 4099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access certification course is designed by Simon Sez IT - Certified IT Professional & Trainer which is made available by Udemy which is meant for the students who want to learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint, Outlook, Teams, OneNote, and Access. The Ultimate Microsoft Office; Excel, Word, PowerPoint, and Access online classes are designed to provide students a thorough understanding of both fundamental and advanced principles and functions related to Microsoft Office applications.

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access online course is a self-paced training program that includes more than 70.5 hours of detailed video lectures, as well as 27 articles, 22 downloadable resources, and quizzes that cover topics such as using formulas and functions in Excel to create charts and graphs, inserting graphics, pictures, shapes, audio and video in PowerPoint presentations, using queries, validations, and working with Access databases, and creating notes and linking Outlook to OneNote.

The highlights

  • Certificate of completion
  • Self-paced course
  • 70.5 hours of pre-recorded video content
  • 27 articles 
  • 22 downloadable resources
  • Quizzes

Program offerings

  • Online course
  • Learning resources. 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 4,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Teamwork Knowledge of excel

After completing the Ultimate Microsoft Office; Excel, Word, PowerPoint & Access online certification, students will obtain an understanding of the foundations of Microsoft Office. Students will learn how to use applications such as Word, PowerPoint, Excel, Teams, Access, Outlook, and OneNote, as well as the principles behind them. Students will learn how to build graphs and charts in Excel using a variety of formulae and functions, as well as how to insert images, shapes, photographs, audio, and video into PowerPoint presentations. Candidates will also learn about Access, including queries, validation, report generation, and printing, as well as how to use the Outlook calendar to schedule meetings and appointments. Candidates will also learn how to use Word to create a mail merge, as well as how to generate notes and link Outlook to OneNote.

The syllabus

Excel 2019: Introduction

  • 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

Excel 2019 Beginner: Creating Workbooks

  • Entering Text and Numbers
  • Creating Basic Formulas
  • Relative References
  • Order of Operations
  • Working with Ranges
  • Module 2 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Saving Workbooks

  • Working with the Save and Save As Commands
  • File Extensions, Share, Export and Publish Files
  • Module 3 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Navigating Workbooks

  • Opening a File
  • Working with Larger Files
  • Freeze Panes Option
  • Split Screen Option
  • Module 4 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Page Setup & Print Options

  • Headers and Footers
  • Print Titles
  • Comments
  • Page Setup Options
  • Fit to Print on One Page
  • Printing Workbooks
  • Module 5 - Practice Exercise
  • Section Quiz

Excel 2019 Beginners: Working with Rows, Columns and Cells

  • Adding and deleting rows columns and cells
  • Changing Column and-Row Widths
  • Module 6 - Practice Exercise
  • Section Quiz

Excel 2019 Beginners: Moving Data

  • Cut, Copy and Paste
  • Copying Formulas
  • Module 7 - Practice Exercise
  • Section Quiz

Excel 2019 Beginners: Formulas & Functions

  • Overview of Formulas
  • Create Formulas Using Functions Part 1
  • Create Formulas Using Functions Part 2
  • Absolute Values
  • Module 8 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Working with Sheets

  • Adding Deleting and Renaming Sheets
  • Additional Sheet Tab Options
  • 3 Dimensional Formulas
  • Module 9 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Formatting Worksheets

  • 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

Excel 2019 Beginner: Charts

  • 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

Excel 2019 Beginner: Working with Names

  • Creating Range Names
  • Managing Names
  • Using Names in Formulas
  • Module 12 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Sorting and Filtering

  • Remove Duplicates
  • Sort Data
  • Filter Data
  • Advanced Filters
  • Module 13 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Outlining and Subtotaling

  • Creating an Outline
  • Subtotals
  • Module 14 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Working with Views

  • Arranging Files
  • New Window Option
  • Custom Views
  • Module 15 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Linking Files

  • Creating Formulas Between File
  • Working with Links
  • Consolidating Data
  • Module 16 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Advanced Formula Creation

  • If Statements
  • VLookups
  • Data Validation
  • Formula Auditing
  • Module 17 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Pivot Tables

  • Pivot Tables
  • Pivot Charts
  • Module 18 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Additional Excel Features

  • Slicers
  • Goal Seeker
  • Text to Columns
  • Watch Window
  • Customizing Ribbons and Tabs
  • Module 19 - Practice Exercise
  • Section Quiz

Excel 2019 Beginner: Shortcutsh

  • Excel Shortcuts Every User Should Know

Excel 2019 Beginner: Closing

  • Closing Video

Excel 2019 Advanced: Intro to Advanced Course

  • 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

Excel 2019 Advanced: Functions

  • Functions - Part 1
  • Functions - Part 2
  • Autosum
  • Section Quiz

Excel 2019 Advanced: Date and Time Functions

  • How Date and Time Works
  • Basic Date and Time Functions
  • Complex Date and Time Functions
  • Section Quiz

Excel 2019 Advanced: Text Functions

  • Using Text Functions - Part 1
  • Using Text Functions - Part 2
  • Section Quiz

Excel 2019 Advanced: Logical Functions

  • Logical Functions
  • Exercise 01
  • Section Quiz

Excel 2019 Advanced: Lookup Functions

  • Lookup Functions - Part 1
  • Lookup Functions - Part 2
  • Exercise 02
  • Section Quiz

Excel 2019 Advanced: Financial Functions

  • Financial Functions and Terminology
  • Personal Financial Functions
  • Principal and Interest Payments
  • Depreciation
  • Exercise 03
  • Section Quiz

Excel 2019 Advanced: Statistical Functions

  • 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

Excel 2019 Advanced: Connecting to External Data

  • Connecting to Other workbooks
  • Connecting to Access Databases
  • Connecting Web Data Sources
  • Get and Transform
  • Exercise 05
  • Section Quiz

Excel 2019 Advanced: Tables

  • Introduction to Tables
  • Working with Tables
  • Section Quiz
  • Table References
  • Table Styles
  • Exercise 6

Excel 2019 Advanced: Pivot Tables

  • Introduction to Pivot Tables
  • Working with Pivot Tables
  • Filters and Slicers
  • Pivot and Charts
  • Exercise 07
  • Section Quiz

Excel 2019 Advanced: Data Analysis

  • What If Analysis
  • Scenario Manager
  • Goal Seek
  • Solver
  • Exercise 08
  • Section Quiz

Excel 2019 Advanced: Graphs and Charts

  • Area Charts
  • Surface Charts
  • Radar Charts
  • Bubble Charts
  • Sparklines
  • Stock Charts
  • Exercise 9
  • Section Quiz

Excel 2019 Advanced: Excel Web App

  • Web App - Part 1
  • Web App - Part 2
  • Section Quiz

Excel 2019 Advanced: Course Conclusion

  • Close

Word 2019: Introduction

  • 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

Word 2019: Getting Started with Word

  • 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

Word 2019: Character Formatting

  • AutoCorrect Options
  • Selecting Text
  • Cut, Copy and Paste
  • Character Formatting Options
  • Format Painter
  • Working with Numbers
  • Working with Bullets
  • Creating an Outline
  • Practice Exercise

Word 2019: Paragraph Formatting

  • Alignment Options
  • Line Spacing Options
  • Working with Indents
  • Working with Tabs
  • Practice Exercise
  • Section Quiz

Word 2019: Managing Lists

  • Sorting a List

Word 2019: Tables

  • 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

Word 2019: Styles

  • Working with Styles
  • Creating Styles
  • Editing Styles
  • Practice Exercise
  • Section Quiz

Word 2019: Controlling Page Appearance

  • Working with Page Breaks
  • Working with Columns
  • Adding a Watermark
  • Headers and Footers
  • Section Quiz

Word 2019: Sectioning

  • What is Sectioning?
  • Sectioning a document
  • Odd and Even Sections
  • Practice Exercise
  • Section Quiz

Word 2019: Graphics

  • Inserting Pictures
  • Inserting Pictures into Existing Documents
  • Picture Options
  • Working with Shapes
  • Icons and 3D Models
  • SmartArt, Charts and Screenshots
  • Practice Exercise
  • Section Quiz

Word 2019: Envelopes and Labels

  • Working with Envelopes
  • Working with Labels
  • Section Quiz

Word 2019: Mail Merges

  • 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

Word 2019: Page Setup Options

  • Building Blocks
  • Auto Text
  • Practice Exercise
  • Section Quiz

Word 2019: Indexing and Table of Contents

  • Creating an Index
  • Creating a Table of Contents
  • Practice Exercise
  • Section Quiz

Word 2019: Review and Printing

  • Using the Thesaurus and Spell Check
  • Comments
  • Page Setup Options
  • Printing
  • Practice Exercise
  • Section Quiz

Word 2019: Other Word Options

  • Word Options
  • Protecting a Document
  • Macros

Word 2019: Wrap Up

  • Closing

PowerPoint 2019: Course Introduction

  • Welcome and Overview
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Downloadable Course Transcripts

PowerPoint 2019: Overview

  • Navigate a PowerPoint Presentation
  • Overview of the Screen and Views
  • Exercise 1

PowerPoint 2019: Getting Started

  • Presentation Tips and Guidelines
  • Creating a New Presentation
  • Working with Slides
  • Saving a Presentation
  • Exercise 02
  • Section Quiz

PowerPoint 2019: Text and Bullet Editing Options

  • Formatting Text
  • Working with Bullets and Numbered Lists
  • Exercise 03
  • Section Quiz

PowerPoint 2019: Adding Graphics

  • Inserting Shapes
  • Inserting Graphics
  • Inserting Icons and 3D Models
  • Inserting Pictures
  • Exercise 04
  • Section Quiz

PowerPoint 2019: Working with objects

  • Selecting Objects
  • Editing Objects
  • Formatting Objects - Part 1
  • Formatting Objects - Part 2
  • Arranging Objects
  • Grouping Objects
  • Exercise 05
  • Section Quiz

PowerPoint 2019: Editing pictures

  • Picture Options
  • Cropping Pictures
  • Formatting Pictures
  • Things You Can Do with Pictures
  • Exercise 06
  • Section Quiz

PowerPoint 2019: Working with SmartArt

  • Creating SmartArt
  • Modifying SmartArt
  • Creating a Flowchart using SmartArt
  • Exercise 07
  • Section Quiz

PowerPoint 2019: Working with Tables

  • Creating Tables
  • Formatting Tables
  • Inserting Tables
  • Exercise 08
  • Section Quiz

PowerPoint 2019: Working with Charts

  • Adding Charts
  • Formatting Charts
  • Inserting Charts from Microsoft Excel
  • Exercise 09
  • Section Quiz

PowerPoint 2019: Unlocking the Power of Masters

  • Using Master Slides
  • Modifying Master Slides
  • Creating a New Master Design Template
  • Exercise 10
  • Section Quiz

PowerPoint 2019: Adding Media

  • Adding Video to a Presentation
  • Adding Audio to a Presentation
  • Exercise 11
  • Section Quiz

PowerPoint 2019: Working with Transitions

  • Applying Transitions
  • Transition Options
  • Exercise 12
  • Section Quiz

PowerPoint 2019: Animation

  • Animating an Object
  • Effect Options
  • Working with the Animation Pane
  • Motion Paths
  • Triggers
  • Exercise 13
  • Section Quiz

PowerPoint 2019: Hyperlinks and Action Buttons

  • Working with Action Buttons
  • Working with Hyperllinks
  • Exercise 14
  • Section Quiz

PowerPoint 2019: Slideshow Options

  • Onscreen Presentation Options
  • Hiding Slides
  • Changing the order of slides
  • Copying slides
  • Slideshow Options
  • Exercise 15

PowerPoint 2019: Preparing a presentation for delivery

  • Rehearse Timings
  • Recording a Presentation
  • Slide Show Settings
  • Creating a Custom Slide Show
  • Exercise 16

PowerPoint 2019: Exploring the Backstage Area

  • Exporting options
  • The Backstage Area
  • Printing a Presentation
  • Exercise 17

PowerPoint 2019: Course Close

  • Conclusion

Access 2019 Beginners: Introduction

  • 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

Access 2019 Beginners: Getting Started with Access 2019

  • 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

Access 2019 Beginners: The Ribbon and Toolbars

  • Working with the Ribbon
  • The Quick Access Toolbar
  • Contextual Menus
  • The Status Bar
  • Section Quiz

Access 2019 Beginners: Keyboard Shortcuts and Key Tip

  • Keyboard Shortcuts
  • Key Tips
  • Section Quiz

Access 2019 Beginners: Access Options

  • Exploring Access Options
  • Section Quiz

Access 2019 Beginners: Tables

  • Creating a Table and Fields
  • Indexed Field
  • Lookup Wizard
  • Numeric Fields
  • Practice Exercise 01
  • Section Quiz

Access 2019 Beginners: Importing Data

  • Importing Data from Excel
  • Practice Exercise 02
  • Section Quiz

Access 2019 Beginners: Backup, Restore and Repair

  • Backing up your Database
  • Compact and Repair
  • Section Quiz

Access 2019 Beginners: Datasheet View

  • Design in the Datasheet View
  • Sorting and Filtering in Datasheet View
  • Entering and Modifying Data in Datasheet View
  • Section Quiz

Access 2019 Beginners: Relationships

  • Creating a Link Table
  • Setting up Relationships
  • Exercise 03
  • Section Quiz

Access 2019 Beginners: Forms

  • Creating a Form
  • Modifying a Form
  • Practice Exercise 04
  • Forms in Layout View
  • Forms in Design View
  • Form Design
  • Practice Exercise 05
  • Section Quiz

Access 2019 Beginners: Subforms

  • Setting Up Subforms - Part 1
  • Setting Up Subforms - Part 2
  • Setting Up Subforms - Part 3
  • Practice Exercise 06
  • Section Quiz

Access 2019 Beginners: Queries

  • Creating a Query
  • Joins
  • Query Wizard
  • Practice Exercise 07
  • Section Quiz

Access 2019 Beginners: Expressions

  • Setting Up Validations
  • Calculation using Expressions
  • Section Quiz

Access 2019 Beginners: Reports

  • Basic Reports
  • Report Design
  • Complex Reports
  • Practice Exercise 08
  • Section Quiz

Access 2019 Beginners: Printing

  • Printing and Print Properties
  • Section Quiz

Access 2019 Beginners: More Data Types

  • Yes/No, OLE Objects and Hyperlink Data Types
  • Section Quiz

Access 2019 Beginners: More About Forms

  • Form Controls
  • Form Themes
  • Navigation Forms
  • Section Quiz

Access 2019 Beginners: Exporting

  • Exporting an Access Database
  • Section Quiz

Access 2019 Beginners: Application Parts

  • Adding Application Parts to a Database

Access 2019 Beginners: More Access Options

  • Additional Access 2019 Options
  • Section Quiz

Access 2019 Beginners: Info Tab

  • Edit Database Properties and Encrypt with Password
  • Section Quiz

Access 2019 Beginners: Course Close

  • Course Close

Access 2019 Advanced: Introduction

  • Course Overview and Content
  • WATCH ME: Essential Information for a Successful Training Experience
  • Course Exercise Files
  • Section Quiz

Access 2019 Advanced: Primary Keys and Indexes

  • Primary Keys and Indexing Rules and Guidelines
  • More About Indexes
  • Section Quiz

Access 2019 Advanced: Using Datasheet View

  • Setting-up Northwind Database
  • Working in a Datasheet View
  • Customizing Datasheet View and Advanced Sorting and Filtering
  • Subdatasheets
  • Exercise 01
  • Section Quiz

Access 2019 Advanced: Linking to Other Access Databases

  • Linking Two Tables to Other Access Databases
  • Section Quiz

Access 2019 Advanced: Using ODBC and SQL Server

  • Acquiring and Installing SQL Server Express
  • Setting Up SQL Server Database
  • Exercise 02
  • Section Quiz

Access 2019 Advanced: Splitting an Access Database

  • 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

Access 2019 Aadvanced: Macros

  • Basics of Macros
  • Macros on Events; AutoExec
  • More About AutoExec; Bypassing AutoExec
  • Macro Security Settings
  • Exercise 04
  • Section Quiz

Access 2019 Advanced: The Ribbon

  • Customizing the Ribbon and Quick Access Tool
  • Section Quiz

Access 2019 Advanced: Visual Basic for Applications

  • 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

Access 2019 Advanced: Access Events Model

  • Adding Events to Assets Database
  • Exercise 05
  • Common Events; Form and Report Events
  • Switchboard and Navigation Form; Error Handling
  • Exercise 06
  • Section Quiz

Access 2019 Advanced: Forms

  • 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

Access 2019 Advanced: Advanced Use of Queries

  • 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

Access 2019 Advanced: Packaging You Application

  • Steps in Packaging Access Application
  • Exercise 9
  • Section Quiz

Conclusion

  • Course Close

  • Course Close

Outlook 2019: Introduction

  • An Overview of Outlook 2019
  • READ ME: Essential Information for a Successful Training Experience
  • Outlook 2019 vs Outlook Online in Office 365
  • What to Expect from this Course
  • Getting Help with Outlook 2019
  • Keyboard Shortcuts
  • Section 1 Quiz

Setting Up Outlook

  • Navigating the Outlook Interface
  • The Ribbons and the Quick Access Toolbar
  • Adding an Email Account
  • Practice Exercise 01
  • Section 2 Quiz

Sending and Receiving Mail

  • Sending and Receiving Mail
  • Focused Inbox
  • Customizing the Inbox
  • Saving Attachments
  • Customizing Mail Views
  • Practice Exercise 02
  • Section 3 Quiz

Searching Mail

  • Searching Mail
  • Creating Search Folders
  • Practice Exercise 03
  • Section 4 Quiz

Organizing and Managing Mail

  • 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

Creating and Sending Mail

  • 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

Working with People

  • Adding a New Contact
  • Utilizing the Contact Card
  • Creating a Contact Group
  • Managing Contacts using Folders
  • Practice Exercise 06
  • Section 7 Quiz

Working with the Calendar

  • 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

Tasks and Notes

  • Creating a New Task
  • Assigning and Completing Tasks
  • Creating Notes
  • Working with OneNote
  • Practice Exercise 08
  • Section 9 Quiz

The Backstage Options

  • Opening and Exporting Data
  • Printing
  • Customizing Outlook Options
  • Section 10 Quiz

Congratulations!

  • BONUS Lecture

Microsoft Teams: Introduction

  • What is Microsoft Teams and why is it useful?
  • READ ME: Essential Information for a Successful Training Experience
  • What to Expect from this Course
  • How to access/download Teams
  • Overview of the Teams Dashboard
  • Getting Help with Microsoft Teams
  • Section 122 Quiz

Creating Teams and Starting Conversations

  • 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

Video and Audio Meetings

  • 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

Additional Features

  • Use the Wiki tab to share information
  • Using apps, bots and connectors
  • Customizing Channel Tabs
  • Section 125 Quiz

Searching

  • Use Search to find specific messages, files or people
  • Using Quick Commands
  • Section 126 Quiz

Settings

  • Adjust user settings
  • Explore the administration settings
  • Section 127 Quiz

Mobile App

  • Working with the Teams Mobile App
  • Section 128 Quiz

Teams Updates (2021)

  • 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

MS Teams: Conclusion

  • Course Close

An Introduction to OneNote

  • What to Expect from this Course
  • READ ME: Essential Information for a Successful Training Experience
  • OneNote Versions
  • Working with Keyboard Shortcuts
  • Customizing the Quick Access Toolbar
  • Using Touch Mode
  • Section Quiz

OneNote: Getting Started

  • 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

OneNote: Adding Content

  • 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

OneNote: Formatting Notes

  • 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

OneNote: Organizing Content

  • Searching a Notebook
  • Tagging Notes
  • Organizing the Interface
  • Linking Notes
  • WINDOWS 10: Organizing Content
  • Section Quiz

OneNote: Formatting Pages

  • Page Setup Options
  • Changing the Page Color and Background
  • Customizing Fonts, Themes and the Interface
  • Setting Paper Size
  • WINDOWS 10: Formatting Pages
  • Section Quiz

OneNote: Working with Templates

  • Applying a OneNote Template to a Page
  • Creating Your Own Template
  • WINDOWS 10: Working with Templates
  • Section Quiz

OneNote: Using Drawing Tools

  • Working in Pen Mode
  • Drawing Shapes with Touch
  • Converting Handwriting to Typed Text
  • WINDOWS 10: Using Drawing Tools
  • Section Quiz

OneNote: Interacting with Outlook

  • Working with Outlook Tasks
  • Outlook Meetings and Meeting Notes
  • Sending Page Information by Email
  • Windows 10: Interacting with Outlook
  • Section Quiz

OneNote: Sharing a Notebook

  • 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

OneNote: Collaborating on a Notebook

  • Author Indicators
  • Page Versions
  • The Notebook Recycle Bin
  • WINDOWS 10: Collaborating on a Notebook
  • Section Quiz

OneNote: Setting OneNote Options

  • Customizing OneNote Options
  • Password Protection
  • Setting Backup Options
  • WINDOWS 10: Setting OneNote Options
  • Section Quiz

Other Versions of OneNote

  • Using OneNote Online
  • Working with OneNote Mobile app
  • Section Quiz

OneNote: Course Close

  • Course Close

Extras

  • 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

Additional Training

  • 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

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books