Microsoft Office 365 Essentials Bundle 5-Course Bundle

[mitsumi]

Microsoft Office 365 Essentials Bundle: 5-Course Bundle

Published 3/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 16.33 GB | Duration: 29h 39m

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 LS