Who it's for: Anyone looking to get started with Microsoft Office by better understanding the basics of Excel, PowerPoint, Outlook, and Teams, four of the top-used apps.
What it is: Microsoft Office is Microsoft's equally popular and powerful productivity suite.
What you'll learn: This training series covers four essential Office apps, with both courses covering two topics each. First, we tackle Excel and PowerPoint. In Excel, learn how to easily enter and manipulate data, then move on to simple calculations, formulas, functions, and more. In PowerPoint, learn how to create and edit slides, then move on to text formatting, adding images, audio, and video, and finally, enhancing your presentations with animations and templates. The next course covers Outlook and Teams. In Outlook, learn how to send messages, communicate with contacts, organize emails, and then move on to scheduling your time with the Outlook calendar. In Teams, learn how to chat, post, meet, and more to take your collaboration skills to the next level.
- Introduction (5:12)
- Excel Basics Overview (1:29)
- Opening Excel and Selecting the Blank Workbook Template (1:27)
- Excel Interface (6:21)
- Entering Data and Using AutoFill (3:05)
- Numbers (2:51)
- Sorting Lists and Saving Files (2:51)
- Basic Formulas (3:56)
- Basic Functions (4:10)
- SUM Function and Function Arguments (4:59)
- AutoSum (2:16)
- Average (3:58)
- MAX and MIN Functions (1:45)
- COUNT Function (3:10)
- IF Function (4:09)
- Relative and Absolute Cell References (4:10)
- Nested IF Functions (6:04)
- Adjusting Column Widths and Formatting Numbers (4:12)
- Using Cell Styles to Format Data (3:51)
- Inserting and Hiding Rows and Columns (3:54)
- Cutting, Copying, and Pasting Data (6:52)
- Inserting New Worksheets, Renaming Tabs, and Printing (6:35)
- Excel Basics Recap (0:20)
- PowerPoint Basics Overview (0:55)
- PowerPoint Interface (5:19)
- Creating Slides (3:16)
- Duplicating and Deleting Slides (3:24)
- SmartArt (4:20)
- Moving Slides (1:08)
- Keyboard Shortcuts (1:04)
- Formatting Graphics and Saving Presentations (2:50)
- Formatting Text and Using the Format Painter (3:32)
- Duplicating Slides and Updating Text (1:47)
- Inserting Images (5:23)
- Formatting Images (3:15)
- Inserting Shapes (1:52)
- Formatting and Aligning Shapes (4:00)
- Grouping Shapes (3:31)
- Animation (6:31)
- Themes (4:08)
- Reviewing with Spell Check and Rehearsing (8:19)
- PowerPoint Takeaways (4:23)
- PowerPoint Basics Recap (0:24)
- Outlook Basics Overview (1:10)
- Outlook Interface (3:43)
- Composing and Sending Emails (4:27)
- Setting Up Auto Spell Check (0:48)
- Formatting Emails (5:25)
- Attaching Files (7:50)
- Tracking Emails (5:23)
- Email Recall and Resend (7:01)
- Marking Emails (2:23)
- Organizing with Folders and Search Folders (6:56)
- Scheduling Meetings (7:12)
- Adding Emails to Calendars and Printing (6:29)
- Outlook Basics Recap (0:29)
- Teams Basics Overview (0:58)
- Why Use Teams (3:08)
- Teams Interface (5:23)
- Profile and Status Options (3:13)
- Chat (2:46)
- Group Chat (2:55)
- Chatting with External Users (1:40)
- Video Calls (5:23)
- Sharing Files (1:29)
- Creating Teams, Channels, and Posts (6:10)
- Search (1:58)
- Scheduling Meetings (6:14)
- Notification Settings (3:43)
- Teams Overview Recap (0:27)
- Conclusion (5:55)