WAREZ-V3

Free Download 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 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
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
Lecture 242 Create and Format Charts
Lecture 243 Use SmartArt to Create Diagrams
Lecture 244 Insert 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.
Homepage

Code: Select all Hello and welcome to Warez-v3 pls Register or Login to see content and download links

DOWNLOAD LINK

Code: Select all Hello and welcome to Warez-v3 pls Register or Login to see content and download links

No Password - Links are Interchangeable