WAREZ-V3 https://www.warez-v3.org/ |
|
Microsoft Office 365 Essentials Bundle 5-Course Bundle https://www.warez-v3.org/viewtopic.php?t=293785 |
Page 1 of 1 |
Author: | TUTBB [ Thu Mar 28, 2024 11:32 am ] |
Post subject: | Microsoft Office 365 Essentials Bundle 5-Course Bundle |
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
DOWNLOAD LINK
|
Page 1 of 1 | All times are UTC |
Powered by phpBB® Forum Software © phpBB Limited |