The Business Guide to Microsoft Office

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

Course Description

The Business Guide to Microsoft Office

If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBook with detailed instructions
  • Sample documents and images
  • Practice, Quizzes and Skill Tests

All materials for this program are available online. The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Word 2013
  • Intermediate Guide to Microsoft® Word 2013
  • Advanced Guide to Microsoft® Word 2013
  • Beginning Guide to Microsoft® Excel 2013
  • Intermediate Guide to Microsoft® Excel 2013
  • Advanced Guide to Microsoft® Excel 2013
  • Beginning Guide to Microsoft® PowerPoint 2013
  • Advanced Guide to Microsoft® PowerPoint 2013

With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market.

In Microsoft Word, you will cover important topics, including how to:

  • Format Text and Paragraphs
  • Get skilled at working with Text and Pictures
  • Learn how to create and format SmartArt
  • Understand how to use and edit Templates to create documents and resumes
  • Create a Mail Merge that sends a personalized invitation to each recipient
  • Learn how to select the Mail Merge recipients and troubleshoot errors
  • Create a Web Page that uses a Table for consistent layout

In Microsoft Excel, you will cover business topics, including how to:

  • Create formulas that use Relative and Absolute values and audit the formulas
  • Use and modify TEXT, DATES and FINANCIAL data with formulas
  • Create, use and troubleshoot Named Ranges and use Named Ranges in formulas
  • Understand how to create and use Lookup Tables and use the IF functions
  • Excel In Print: Use page Layout and Page Set up to modify print settings

In Microsoft PowerPoint, you will learn how to:

  • Know how to work with Text Boxes, Format Shapes and apply Themes
  • Insert, format and adjust Pictures with the Picture Tools
  • Insert and format Shapes and SmartArt to create an effective presentation
  • Use Tables and Spreadsheets to display data in a presentation
  • Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks
  • Learn how to design Slide Masters and apply slide Transitions
  • Apply Animations to images in a slide show and edit the timing


Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need.

This course teaches the objectives for the following certification tests:
Core Certification: Pass any 1 test:
Word 2013 Core: Exam 77-418
Excel® 2013 Core: Exam 77-420
PowerPoint® 2013: Exam 77-422

Expected Outcomes

  1. Learn how to navigate online and submit assignments
  2. Format Text and Paragraphs in Microsoft Word
  3. Work with Text and Pictures in Microsoft Word
  4. Learn how to create and format SmartArt
  5. Use Quick parts to create professional documents
  6. Create a professional newsletter that includes graphics and charts
  7. Create a Mail Merge that sends a personalized invitation to each recipient
  8. Create a Web Page that uses a Table for consistent layout
  9. Create formulas that use Relative and Absolute values and audit the formulas
  10. Use and modify TEXT, DATE and FINANCIAL formulas in Microsoft Excel
  11. Create, use and troubleshoot Named Ranges and use Named Ranges in formulas
  12. Understand how to create and use Lookup Tables and use the IF functions
  13. Excel In Print: Use page Layout and Page Set up to modify print settings
  14. Learn PowerPoint basics: Entering text in presentations
  15. Know how to work with Text Boxes, Format Shapes and apply Themes in Microsoft PowerPoint
  16. Use Tables and Spreadsheets to display data in a presentation
  17. Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks
  18. Learn how to design Slide Masters and apply slide Transitions
  19. Apply Animations to images in a slide show and edit the timing
  20. Add videos to a PowerPoint presentation and trim the media
  21. Add videos to a PowerPoint presentation and trim the media