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 2013Intermediate Guide to Microsoft Word 2013Advanced Guide to Microsoft Word 2013Beginning Guide to Microsoft Excel 2013Intermediate Guide to Microsoft Excel 2013Advanced Guide to Microsoft Excel 2013Beginning Guide to Microsoft PowerPoint 2013Advanced 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 ParagraphsGet skilled at working with Text and PicturesLearn how to create and format SmartArtUnderstand how to use and edit Templates to create documents and resumesCreate a Mail Merge that sends a personalized invitation to each recipient Learn how to select the Mail Merge recipients and troubleshoot errorsCreate 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 formulasUse and modify TEXT, DATES and FINANCIAL data with formulas Create, use and troubleshoot Named Ranges and use Named Ranges in formulasUnderstand how to create and use Lookup Tables and use the IF functionsExcel 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 ThemesInsert, format and adjust Pictures with the Picture ToolsInsert and format Shapes and SmartArt to create an effective presentationUse Tables and Spreadsheets to display data in a presentationLearn how to add, format and edit Charts with the Chart Tools and Quick ClicksLearn how to design Slide Masters and apply slide TransitionsApply 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