Microsoft Office 365 Essentials Bundle: 5-Course Bundle

Learn the essentials of Microsoft Office 365 in this amazing value 5-course bundle.

What you'll learn

Accessing the Microsoft 365 online portal, launching Excel desktop, navigating the interface, and improving efficiency with keyboard shortcuts.

Performing lookups with VLOOKUP and XLOOKUP and using logical functions to make better decisions.

Creating, saving, and recovering documents, utilizing Word 365 templates, and saving documents to OneDrive for seamless collaboration.

Navigating the PowerPoint 365 interface efficiently and organizing slides using modern layouts.

Sharing email folders, applying rules, and managing calendars seamlessly for teamwork efficiency with Outlook Online.

Navigating Teams’ interface to access and utilize essential functions and creating public and private teams for effective communication.

Requirements

An active Microsoft 365 account and subscription to access the applications is useful.

No prior experience needed, the course is for complete beginners.

Description

**This bundle includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to the Microsoft Office 365 Essentials Bundle, a comprehensive 5-course bundle designed to enhance your proficiency in fundamental Office 365 applications. With courses covering Microsoft Excel, Word, PowerPoint, Outlook Online, and Teams, you'll learn the essential skills to excel in various professional settings.Starting with the Ultimate Beginner's Guide to Microsoft Excel 365, you'll gain a solid foundation in spreadsheet creation and data analysis, progressing to beginner-level courses in Word, PowerPoint, Outlook Online, and Teams to master document creation, presentation design, email management, and team collaboration.Completing this course bundle will help equip you with versatile skills crucial for productivity and efficiency in today's workplace. Whether you're a student, professional, or entrepreneur, investing in this bundle can help ensure you have the knowledge to navigate Office 365 effectively and excel in your endeavors.What's included?Microsoft Excel 365: Ultimate Beginner GuideAccess the Microsoft 365 online portal, launch Excel desktop, navigate the interface, and improve efficiency with keyboard shortcuts. Understand the order of operations and the BODMAS rule and use the 'Big 6' basic Excel functions to create formulas. Know the difference between absolute and relative referencing, create named ranges, and use named ranges in formulas. Apply number formatting, format cells, rows, and columns, copy formatting with Format Painter, and work with conditional formatting.Perform lookups with VLOOKUP and XLOOKUP and use logical functions to make better decisions. Create and use Excel tables, sort and filter list data, present data with charts, and insert in-cell charts like sparklines. Freeze and unfreeze panes, adjust page setup options, and insert headers, footers, and page breaks. Protect cells, worksheets, and workbooks from editing and save the workbook in different file formats. Work with files in Excel Online, co-author spreadsheets with others in real time, and share workbooks with others. Add an Excel workbook to a Teams channel and share in a Teams meeting. Microsoft Word 365 for BeginnersLaunch Word, explore the start screen, and interact with ribbons, tabs, and menus.Customize the Quick Access Toolbar, employ useful keyboard shortcuts, and check spelling and grammar while typing.Create, save, and recover documents, utilize Word templates, and save documents to OneDrive for seamless collaboration.Switch between document views, utilize the Immersive Reader, and arrange documents with zoom features for enhanced readability.Enter and format text efficiently, master cut, copy, and paste techniques, and use the clipboard, format painter, and paste options.Format paragraphs, adjust alignment, spacing options, bullets, numbered lists, and learn to work with tabs.Understand Word themes, create custom themes with branded colors, and explore styles for consistent document aesthetics.Insert, format, and manipulate pictures, text boxes, shapes, and other graphics, utilizing alignment tools and the selection pane.Set margins, orientation, and page size, work with breaks, headers, footers, and page numbers, and insert hyperlinks and bookmarks.Explore references, perform mail merges, track changes and comments, and finalize documents by checking for issues and adding protection.Microsoft PowerPoint 365 for BeginnersNavigate the PowerPoint 365 interface efficiently.Organize slides using modern layouts.Incorporate multimedia elements like video, audio, and animations.Implement modern text effects to improve visual appeal.Utilize diagrams and charts effectively for data presentation.Create accessible presentations for diverse audiences.Prepare and deliver presentations confidently.Implement time-saving shortcuts and hacks.Stay updated with emerging features in PowerPoint 365.Microsoft Outlook Online 365 for BeginnersConstruct folders and subfolders for efficient email categorization.Employ advanced search and filters to streamline email retrieval effectively.Utilize Focused Inbox, Sweep, and archiving techniques for inbox organization.Share email folders, apply rules, and manage calendars seamlessly for teamwork efficiency.Microsoft Teams 365 for BeginnersIdentify Microsoft Teams' core features and their role in collaboration.Navigate Teams Interface to access and utilize essential functions.Create, join, and manage public and private teams for effective communication.Master messaging skills, including posting, receiving, and managing messages.Efficiently handle private messages to enhance focused communication.Manage teams and channels adeptly, applying actions like leaving and hiding teams.This bundle includes:29+ hours of video tutorials300+ individual video lecturesCourse and exercise files to follow alongCertificate of completion

Overview

Section 1: Excel 365 Beginners: Introduction

Lecture 1 Course Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Exercise Files

Lecture 4 DOWNLOAD ME: Course Instructor Files

Lecture 5 Excel 365 Online Portal

Lecture 6 Exercise 01

Section 2: Excel 365 Beginners: Get Started in Excel 365

Lecture 7 Launch Excel

Lecture 8 Explore the Interface

Lecture 9 Work with Contextual Menus, Ribbons, and Panes

Lecture 10 Customize the Quick Access Toolbar

Lecture 11 Keyboard Shortcuts

Lecture 12 Exercise 02

Section 3: Excel 365 Beginners: Create an Excel Spreadsheet

Lecture 13 Excel Templates

Lecture 14 Work with Workbooks and Worksheets

Lecture 15 Save Workbooks to OneDrive

Lecture 16 Enter Text, Numbers, and Dates

Lecture 17 Custom Lists

Lecture 18 Exercise 03

Section 4: Excel 365 Beginners: Introduction to Excel Formulas

Lecture 19 The Order of Operations (BODMAS Rule)

Lecture 20 A Simple Formula

Lecture 21 The 'Big 6' Functions

Lecture 22 Absolute vs Relative Referencing

Lecture 23 Quick Calculations with Autosum

Lecture 24 Auto-Fill and Flash Fill

Lecture 25 Exercise 04

Section 5: Excel 365 Beginners: Use Named Ranges

Lecture 26 What are Named Ranges?

Lecture 27 Create Named Ranges

Lecture 28 Use Named Ranges in Formulas

Lecture 29 Exercise 05

Section 6: Excel 365 Beginners: Format Numbers and Cells

Lecture 30 Apply Number Formats

Lecture 31 Format Cells, Rows, and Columns Manually

Lecture 32 AutoFormat Data

Lecture 33 Find and Replace Formatting

Lecture 34 Copy Formatting: Format Painter

Lecture 35 Clear Cells

Lecture 36 Exercise 06

Section 7: Excel 365 Beginners: Excel Tables

Lecture 37 Excel Tables Explained

Lecture 38 Format Data as an Excel Table

Lecture 39 Table References in Formulas

Lecture 40 Exercise 07

Section 8: Excel 365 Beginners: Format Worksheets

Lecture 41 Work with Rows and Columns

Lecture 42 Align Text and Numbers

Lecture 43 Merge Cells vs Center Across Selection

Lecture 44 Apply and Modify Themes

Lecture 45 Exercise 08

Section 9: Excel 365 Beginners: Excel Lists

Lecture 46 How to Structure a List

Lecture 47 Sort a List: Single-Level Sort

Lecture 48 Sort a List: Multi-Level Sort

Lecture 49 Sort a List: Sort with Custom Lists

Lecture 50 Filter a List - Numbers and Text

Lecture 51 Filter and Sort by Color

Lecture 52 Add Subtotals to a List

Lecture 53 Exercise 09

Section 10: Excel 365 Beginners: Move and Link to Data

Lecture 54 Cut, Copy, and Paste

Lecture 55 Paste Options

Lecture 56 Paste From Clipboard

Lecture 57 Move and Copy Worksheets

Lecture 58 3D Referencing

Lecture 59 Insert Hyperlinks to Worksheets

Lecture 60 Exercise 10

Section 11: Excel 365 Beginners: Introduction to Intermediate Formulas

Lecture 61 Lookup Functions: VLOOKUP Explained

Lecture 62 Lookup Functions: XLOOKUP Explained

Lecture 63 Logical Functions: IF, AND, OR

Lecture 64 Text Functions: PROPER, TRIM, CLEAN

Lecture 65 Time and Date Functions: TODAY, NOW, WORKDAY

Lecture 66 Exercise 11

Section 12: Excel 365 Beginners: Analyze Data

Lecture 67 Quick Analysis Button

Lecture 68 Choose the Right Chart Type

Lecture 69 Present Data with Charts

Lecture 70 Format a Chart

Lecture 71 In-Cell Charts: Sparklines

Lecture 72 In-Cell Charts: The REPT Function

Lecture 73 Exercise 12

Section 13: Excel 365 Beginners: Conditional Formatting

Lecture 74 Highlight Cell Values

Lecture 75 Data Bars

Lecture 76 Color Scales

Lecture 77 Icon Sets

Lecture 78 Exercise 13

Section 14: Excel 365 Beginners: Insert Pictures and Other Graphics

Lecture 79 Add Interest with Pictures and Icons

Lecture 80 Insert Shapes and Text Boxes

Lecture 81 Create Diagrams using SmartArt

Lecture 82 Insert Screenshots and Clips

Lecture 83 Insert and Respond to Threaded Comments

Lecture 84 Exercise 14

Section 15: Excel 365 Beginners: Work with Views

Lecture 85 Workbook Views and Zoom

Lecture 86 Arrange Workbooks and Worksheets

Lecture 87 Freeze Panes

Lecture 88 Exercise 15

Section 16: Excel 365 Beginners: Prepare for Printing

Lecture 89 Set Margins and Orientation

Lecture 90 Set and Clear the Print Area

Lecture 91 Insert Page Breaks

Lecture 92 Set Print Titles and a Background

Lecture 93 Insert Headers and Footers

Lecture 94 Print a Workbook

Lecture 95 Exercise 16

Section 17: Excel 365 Beginners: Finalizing the Spreadsheet

Lecture 96 Protect Cells, Worksheets, and Workbooks

Lecture 97 Inspect the Workbook for Issues

Lecture 98 Save the Workbook in Different Formats

Lecture 99 Exercise 17

Section 18: Excel 365 Beginners: Excel 365 Online

Lecture 100 Work with Files in Excel Online

Lecture 101 Share Workbooks with Others

Lecture 102 Co-Author Workbooks in Real-Time

Lecture 103 Add an Excel Workbook to Microsoft Teams

Lecture 104 Excel Live: Share a Workbook in a Teams Meeting

Lecture 105 Exercise 18

Section 19: Excel 365 Beginners: Course Close

Lecture 106 Course Close

Section 20: Word 365: Introduction

Lecture 107 Course Introduction

Lecture 108 WATCH ME: Essential Information for a Successful Training Experience

Lecture 109 DOWNLOAD ME: Course Exercise Files

Lecture 110 DOWNLOAD ME: Course Instructor Files

Lecture 111 Word Online vs Word Desktop

Lecture 112 Exercise 01

Section 21: Word 365: The Basics

Lecture 113 Launch Word and Explore the Start Screen

Lecture 114 Get Familiar with the Word Interface

Lecture 115 Work with Ribbons, Tabs and Menus

Lecture 116 Customize the Quick Access Toolbar

Lecture 117 Useful Keyboard Shortcuts

Lecture 118 Check Spelling and Grammar as You Type

Lecture 119 Exercise 02

Section 22: Word 365: Get Started - Work with Documents

Lecture 120 Word Templates

Lecture 121 Create and Save a Document

Lecture 122 Save Documents to OneDrive

Lecture 123 Recover Unsaved Documents

Lecture 124 Navigate Around a Document

Lecture 125 Find Tools in Word

Lecture 126 Exercise 03

Section 23: Word 365: View Documents

Lecture 127 Switch Document Views

Lecture 128 Use the Immersive Reader and Focus

Lecture 129 Arrange Documents and Zoom

Lecture 130 Exercise 04

Section 24: Word 365: Work with Text in Documents

Lecture 131 Enter and Format Text

Lecture 132 Move Text with Cut, Copy and Paste

Lecture 133 Work with the Clipboard

Lecture 134 Copy Formatting: Format Painter

Lecture 135 Paste Options

Lecture 136 Find and Replace Tool

Lecture 137 Dictate and Transcribe

Lecture 138 Exercise 05

Section 25: Word 365: Work with Paragraphs

Lecture 139 Format Paragraphs and Alignment

Lecture 140 Line and Paragraph Spacing Options

Lecture 141 Show/Hide Markers (Non-Printing Characters)

Lecture 142 Bullets and Numbered Lists

Lecture 143 Indent Paragraphs

Lecture 144 Align Text with Tabs

Lecture 145 Exercise 06

Section 26: Word 365: Themes

Lecture 146 Word Themes Explained

Lecture 147 Create a Custom Theme with Branded Colors

Lecture 148 Exercise 07

Section 27: Word 365: Word Styles

Lecture 149 Word Styles Explained

Lecture 150 Modify Styles in the Styles Pane

Lecture 151 Reset to Default Styles

Lecture 152 Create a Custom Style

Lecture 153 Exercise 08

Section 28: Word 365: Insert Pictures, Tables, Shapes and Other Objects

Lecture 154 Resources: Free Images and Video

Lecture 155 Insert and Format Pictures

Lecture 156 Background Remover Tool

Lecture 157 Insert and Format Text Boxes

Lecture 158 Insert and Format Shapes

Lecture 159 Alignment Tools

Lecture 160 Use the Selection Pane

Lecture 161 Insert Other Graphics

Lecture 162 Insert SmartArt, Charts and Screenshots

Lecture 163 Draw with Touch

Lecture 164 Organize Information in a Table

Lecture 165 Calculations in Word

Lecture 166 Add a Watermark and Page Color

Lecture 167 Exercise 09

Section 29: Word 365: Format Pages

Lecture 168 Set Margins, Orientation and Page Size

Lecture 169 Work with Page and Section Breaks

Lecture 170 Insert Additional Pages: Cover Page and Blanks

Lecture 171 Apply Column Layout (Newspaper Format)

Lecture 172 Add Headers, Footers and Page Numbers

Lecture 173 Insert Hyperlinks

Lecture 174 Insert Bookmarks

Lecture 175 Insert Reusable Content with Quick Parts

Lecture 176 Exercise 10

Section 30: Word 365: References

Lecture 177 Work with a Table of Contents

Lecture 178 Use Footnotes and Endnotes

Lecture 179 Build a Bibliography

Lecture 180 Insert Captions and a Table of Figures

Lecture 181 Create an Index

Lecture 182 Insert a Table of Authorities

Lecture 183 Exercise 11

Section 31: Word 365: Mail Merge

Lecture 184 Mail Merge Wizard: Create Letters

Lecture 185 Mail Merge Wizard: Create Envelopes

Lecture 186 Create Labels with Merge Fields

Lecture 187 Exercise 12

Section 32: Word 365: Track Changes and Comments

Lecture 188 Track Changes: Markup a Document

Lecture 189 Accept and Reject Changes

Lecture 190 Add Comments

Lecture 191 Exercise 13

Section 33: Word 365: Finalize a Document

Lecture 192 Printing Documents

Lecture 193 Check a Document for Issues, Compatibility and Accessibility

Lecture 194 Document Protection

Lecture 195 Exercise 14

Section 34: Word 365: Online

Lecture 196 Work with Files in Word Online

Lecture 197 Share Files with Others

Lecture 198 Add a Word Document to Microsoft Teams

Section 35: Word 365: Course Close

Lecture 199 Course Close

Section 36: PowerPoint 365: Introduction

Lecture 200 Course Introduction

Lecture 201 WATCH ME: Essential Information for a Successful Training Experience

Lecture 202 DOWNLOAD ME: Course Exercise Files

Lecture 203 DOWNLOAD ME: Course Instructor Files

Lecture 204 PowerPoint 365 Desktop vs Powerpoint Online

Lecture 205 Exercise 01

Section 37: PowerPoint 365: Modern Slide Layouts

Lecture 206 The Golden Rules of Good Presentation Design

Lecture 207 Free Resources and Inspiration

Lecture 208 Exercise 02

Section 38: PowerPoint 365: Quick Start

Lecture 209 Start Quickly with Themes and Templates

Lecture 210 Quick Starter Outline Slides

Lecture 211 Save Presentations to the Cloud (OneDrive)

Lecture 212 Exercise 03

Section 39: PowerPoint 365: Essential Basics

Lecture 213 Understand the PowerPoint Interface

Lecture 214 Add Commands to the Quick Access Toolbar

Lecture 215 Keyboard Shortcuts and Key Tips + Copilot for Bing

Lecture 216 Exercise 04

Section 40: PowerPoint 365: Work with Slides

Lecture 217 Slide Layouts

Lecture 218 Organize Slides: Add, Remove, Duplicate and Rearrange

Lecture 219 Change the Slide Background

Lecture 220 Add a Transparent Overlay

Lecture 221 AI in PowerPoint: Designer

Lecture 222 Change Multiple Slides: Slide Master

Lecture 223 Work with Text Boxes

Lecture 224 Add Sections to a Presentation

Lecture 225 Find and Replace Fonts

Lecture 226 Copy Slides Between Presentations

Lecture 227 Exercise 05

Section 41: PowerPoint 365: Get Creative with Images and Shapes

Lecture 228 Add Images to a Presentation

Lecture 229 Work with Shapes

Lecture 230 Align and Group Objects

Lecture 231 Z-Order and the Selection Pane

Lecture 232 Fill Shapes with Images

Lecture 233 Format and Add Effects to Objects

Lecture 234 Copy Formatting: Format Painter and Eyedropper

Lecture 235 Remove the Background from Pictures

Lecture 236 Insert and Customize Icons and Other Graphics

Lecture 237 Exercise 06

Section 42: PowerPoint 365: Modern Text Effects

Lecture 238 Fill Text with an Image

Lecture 239 Text Effect with Layers

Lecture 240 Create Gradient Filled Text

Lecture 241 Exercise 07

Section 43: PowerPoint 365: Diagrams, Charts and Screenshots

Lecture 242 Create and Format Charts

Lecture 243 Use SmartArt to Create Diagrams

Lecture 244 Insert Screenshots and Clippings

Lecture 245 Exercise 08

Section 44: PowerPoint 365: Video, Audio and Animation

Lecture 246 Add Video and Control Playback

Lecture 247 Create a 'Talking Head' Video with Cameo

Lecture 248 Add and Work with Audio Files

Lecture 249 Add Animation Effects to Objects

Lecture 250 Use Slides Transitions in Presentations

Lecture 251 The Morph Transition

Lecture 252 Create Slide, Summary and Section Zooms

Lecture 253 Exercise 09

Section 45: PowerPoint 365: Create Accessible Presentations

Lecture 254 The Dictation Utility

Lecture 255 Add Subtitles and Adjust Subtitle Settings

Lecture 256 Add Alt Text to Images

Lecture 257 Exercise 10

Section 46: PowerPoint 365: Prepare a Presentation for Delivery

Lecture 258 Add Speaker Notes

Lecture 259 Rehearse Timings and Rehearse with Coach

Lecture 260 Custom Slide Show: Retain Audience Focus

Lecture 261 Share and Collaborate on a Presentation

Lecture 262 Restore Previous Revisions

Lecture 263 Exercise 11

Section 47: PowerPoint 365: Deliver the Presentation

Lecture 264 Use Presenter View

Lecture 265 Present in Teams: PowerPoint Live

Lecture 266 Get Live Audience Feedback with Integrated Forms

Lecture 267 Exercise 12

Section 48: PowerPoint 365: Reuse the Presentation

Lecture 268 Create and Save a Custom Theme

Lecture 269 Create a Template to Reuse Later

Lecture 270 Record and Export a Presentation

Lecture 271 Export a Presentation as Other File Types

Lecture 272 Exercise 13

Section 49: PowerPoint 365: The Future of PowerPoint

Lecture 273 PowerPoint + Microsoft Copilot

Lecture 274 Work with Copilot in Microsoft Bing

Lecture 275 Unleash your Creativity with Microsoft Create

Lecture 276 Exercise 14

Section 50: PowerPoint 365: Course Close

Lecture 277 Course Close

Section 51: Outlook Online 365

Lecture 278 Course Introduction

Lecture 279 Outlook Email Basics - Part 1

Lecture 280 Outlook Email Basics - Part 2

Lecture 281 Create Outlook Folders and Subfolders

Lecture 282 Email Search, Filter and Search Folders

Lecture 283 Managing Emails: Focused Inbox and Sweep

Lecture 284 Flag and Categorize Mail

Lecture 285 Archive Emails

Lecture 286 Create an Email Signature

Lecture 287 Set up Automatic Replies

Lecture 288 Share Email Folders with Others

Lecture 289 Rules in Outlook

Lecture 290 Advanced Email Settings

Lecture 291 Outlook Calendar Basics

Lecture 292 Add and Edit Events and Meetings

Lecture 293 Share Your Calendar and Open Other Calendars

Lecture 294 Export Outlook Data to a PST File

Lecture 295 Work with Notes

Lecture 296 Manage and Organize People (Contacts)

Lecture 297 Add People (Contacts)

Lecture 298 Course Exercise

Lecture 299 Course Conclusion

Section 52: Microsoft Teams

Lecture 300 Course Introduction

Lecture 301 What is Microsoft Teams?

Lecture 302 Explore the Teams Interface

Lecture 303 Create or Join Public and Private Teams

Lecture 304 Post and Receive Messages

Lecture 305 Bookmark, Edit and Delete Messages

Lecture 306 Private Messages

Lecture 307 Manage Teams and Channels

Lecture 308 Leave, Hide and Delete a Team

Lecture 309 Add Tabs and Search in Teams

Lecture 310 Set Up Teams for Meetings and Calls

Lecture 311 Initiate a Video or Audio Call On-Demand (Meet Now)

Lecture 312 Schedule a Video or Audio Call (Teams and Outlook)

Lecture 313 Share Your Screen and Files

Lecture 314 PowerPoint and Excel Live in Teams Meetings

Lecture 315 Brainstorm Ideas with Whiteboard

Lecture 316 Breakout Rooms

Lecture 317 Course Exercise

Lecture 318 Course Close

Users new to Microsoft Office 365 and those upgrading from older stand-alone versions.,Anyone who wants to be more productive at work and organize their spreadsheets, documents, mail, calendar, meetings, or presentations.,Those who want to get the most out of Microsoft 365, including Outlook Online andTeams.