**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 Guide

• Access 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 Beginners

• Launch 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 Beginners

• Navigate 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 Beginners

• Construct 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 Beginners

• Identify 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:

1. 29+ hours of video tutorials

2. 300+ individual video lectures

3. Course and exercise files to follow along

4. Certificate of completion