Ultimate Microsoft Office 365 Bundle
Master Microsoft Office 365 with this 11-course Bundle
4.49 (197 reviews)
1,195
students
48.5 hours
content
Feb 2025
last update
$19.99
regular price
What you will 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.
6035304
udemy ID
6/21/2024
course created date
7/17/2024
course indexed date
Bot
course submited by