Microsoft 365 Administration

What Will You 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.