Master Microsoft Excel, Outlook and Word 2013 - 26 Hours

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy

Course Description

Master the Ins and Outs of Microsoft Office 2013

  • Spreadsheets with Excel 2013
  • Emails and Calendars with Outlook 2013
  • Documents with Word 2013

Contents and Overview

The course is designed for individuals and office professionals who need to master the capabilities of Microsoft Office 2013.

Through 26 hours of video lectures, you'll learn the essentials with these 3 popular courses:

  • Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.
  • Outlook 2013: Get organized with your emails and calendar so you can start getting more done.
  • Word 2013: Create documents, embed videos, and set up for online collaboration for joint projects for school or work.

When you complete this course, you'll be well on your way to becoming a master at workplace efficiency with the tools available in Microsoft Office 2013.

What People Are Saying:

★★★★★ “The lesson is very clear. Easy to understand and perfect for beginners like me.” –Rachelle Deciembre

★★★★★ It’s very straight forward from what I have seen so far. Great resource for someone who has never used excel with clear explanations.” -Jennifer Janczak

** Updated June 2017. Course transcripts now available.

Expected Outcomes

  1. Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  2. Tips for mouse and touch screen users.
  3. Graphs and charts using templates or custom designs.
  4. SkyDrive and other tools for sharing work.
  5. Pivot tables and slicing.
  6. Working with flash fill.
  7. Bonus exercise files.
  8. Working with dates and times
  9. Calculating depreciation
  10. Averages, percentiles, and LINEST functions
  11. Payments
  12. Inserting and formatting tables
  13. Sparklines and data bars
  14. Pivot charts
  15. Inserting images and videos directly from the internet
  16. Opening and editing PDFs
  17. Read mode, resume reading, object zoom, and collapsible headings
  18. Protecting data with back-up and AutoRecover
  19. Sharing work through email, blogs, and SkyDrive
  20. Document security and editing restrictions
  21. Setting up email accounts, POP and Gmail
  22. Using touch devices
  23. Importing contacts
  24. Calendar appointments and attachments
  25. Tasks and reminders
  26. Email signatures
  27. ‘Sneak a Peek’ and workspace customization
  28. RSS feeds
  29. Archiving and the Trust Center
  30. Spam and junk mail removal