Ultimate Microsoft Office 365 Bundle

Master Microsoft Office 365 with this 11-course Bundle

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I Learn?

• Perform lookups with VLOOKUP, INDEX/MATCH, and XLOOKUP.
• Protect cells, worksheets, and workbooks from editing.
• Add an Excel workbook to a Teams channel and share in a Teams meeting.
• Design spreadsheets for improved readability using cell styles.
• Implement data validation for accurate input control.
• Utilize logical functions like AND, OR, and IF for decision-making.
• Identify and handle duplicates in data using conditional formatting and formulas.
• Perform what-if analysis using functions like PMT, Goal Seek, and Data Tables.
• Extract and count unique entries using Dynamic Array Functions.
• Differentiate between unique and distinct values in Excel spreadsheets.
• Utilize SORT and SORTBY functions for data organization and analysis.
• Employ FILTER functions with logical operators for precise data filtration.
• Generate random arrays and values with RANDARRAY and RANDBETWEEN functions.
• Develop custom formulas with LET and LAMBDA functions for tailored analysis.
• Create and manage data models with Power Pivot, including table relationships.
• Launch Word and customize the Quick Access Toolbar.
• Create, save, and recover documents, and switch between document views.
• Enter and format text efficiently, and format paragraphs.
• Organize slides using modern layouts.
• Incorporate multimedia elements like video, audio, and animations.
• Utilize diagrams and charts effectively for data presentation.
• Create accessible presentations for diverse audiences.
• Prepare and deliver presentations confidently.
• Identify Microsoft Teams' core features and their role in collaboration.
• Create, join, and manage public and private teams for effective communication.
• Master messaging skills, including posting, receiving, and managing messages.
• Manage teams and channels adeptly, applying actions like leaving and hiding teams.
• 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.
• Demonstrate efficient OneDrive integration with Office applications for seamless file handling.
• Utilize OneDrive interface features to navigate and manage files effectively.
• Implement file synchronization strategies for optimal OneDrive for Business functionality.
• Master collaborative workflows, including sharing, co-authoring, and file recovery processes.
• Create OneNote notebooks efficiently for various purposes.
• Organize content using sections and pages.
• Collaborate effectively by sharing and co-authoring notebooks.
• Format columns, rows, and cells with Copilot in Excel.
• Create and modify presentations from scratch with Copilot in PowerPoint.
• Draft and refine documents efficiently with Copilot in Word.
• Draft new messages and summarize replies in Outlook using Copilot.
• Collaborate with Copilot in Microsoft Teams for enhanced productivity.
• Brainstorm ideas effectively using Copilot in OneNote.
• Generate images efficiently with Copilot in Bing.

Requirements

• No prior experience needed. This course is designed for absolute beginners.
• Microsoft Excel 365, Word 365, and PowerPoint 365 for Windows installed and ready to use on your computer.
• Access to Copilot and an active Microsoft 365 account and subscription to access the applications is useful.

Target audience

• Suitable for learners of all levels.
• Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 365 knowledge.
• 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, OneDrive, OneNote, and Teams.
• Anyone who wants to learn Microsoft Copilot and its integration with Microsoft 365 suite of applications.
• Professionals who want to be more productive by using AI tools.