Microsoft Office 365 - What you'll Learn
- Creating professional documents with Microsoft Word.
- Performing advanced data analysis using Excel.
- Crafting dynamic and engaging presentations in PowerPoint.
- Managing emails and scheduling with Outlook.
- Creating and hosting virtual meetings using Microsoft Teams.
- Exploring cloud storage and file sharing with OneDrive.
Microsoft Office 365
Master the essential tools of Microsoft Office 365 and take your productivity to the next level! This comprehensive course is designed to equip you with the skills to efficiently use Office 365 applications like Word, Excel, PowerPoint, Outlook, Teams & Forms.
Whether you’re a student, professional, or business owner, this course provides hands-on training to streamline your workflow, collaborate effectively, and harness the full potential of cloud-based features. Learn how to create polished documents, analyze data, design impactful presentations, and manage communications—all within the powerful Microsoft Office 365 suite.
Course Content
Microsoft Word 365
- Creating, saving, and opening documents.
- Formatting text, paragraphs, and sections.
- Inserting headers, footers, and page numbers.
- Working with templates and SmartArt.
- Advanced formatting (styles, columns, page breaks).
- Creating tables, inserting images, shapes, charts, and hyperlinks.
- Reviewing tools (Track Changes, Comments).
- Mail Merge (with Excel).
- Working with long documents: sections, footnotes, references.
Microsoft Excel 365
- Workbook and Worksheet management.
- Formatting cells, rows, and columns.
- Using basic formulas (SUM, AVERAGE, COUNT).
- Creating and formatting tables.
- Using charts and graphs (bar, pie, line).
- Working with functions (IF, VLOOKUP, HLOOKUP).
- Data management: sorting, filtering, and validating data.
- Working with multiple worksheets.
- Pivot Tables and Pivot Charts.
- Data analysis tools: Goal Seek, Scenario, What-If Analysis.
- Protecting and locking sheets and workbooks.
Microsoft PowerPoint 365
- Creating and saving presentations.
- Adding and formatting text, images, and SmartArt.
- Working with slides: layout, background, and themes.
- Slide transitions and animations.
- Adding audio and video to presentations.
- Using the Slide Master for consistent formatting.
- Recording presentations with narration and timings.
Microsoft Outlook
- Setting up and organizing emails.
- Sending, receiving, and managing emails.
- Using attachments and links.
- Managing meetings, events, and appointments in the calendar.
- Creating and organizing contacts and contact groups.
- Scheduling meetings and inviting participants.
- Automating email management using Rules.
- Setting up automatic replies (Out of Office).
- Sharing calendars and tasks with others.
Microsoft Teams
- Setting up and joining Teams.
- Channels and Tabs: Organizing conversations and files.
- Sending messages, sharing files, and co-editing documents.
- Scheduling, joining, and managing online meetings.
- Breakout Rooms, Polls, and Recording features.
- Integrating Teams with Outlook for seamless communication.
- Working with shared files (Word, Excel, PowerPoint) in real-time.
Microsoft Forms
- Creating Forms: Designing surveys, quizzes, and polls.
- Adding multiple question types (multiple choice, text, rating).
- Managing Responses: Sharing forms with participants.
- Viewing and analyzing responses in real-time.
- Integrating Forms with Other Apps: Exporting responses to Excel for data analysis.
- Embedding forms in websites or emails.
