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

29+ hoursof video tutorials

300+ individual videolectures

Course and exercise filesto follow along

Certificate of completion

Who this course is for:
- 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 and Teams.
More Info