Microsoft Office 2013 for Business (Voucher Included)

ID : 32535

Description: 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 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.

Instructor Description: Elizabeth Ann Nofs is the designer, developer, and instructor of the Comma Mama Guides. She developed a successful method for teaching visually that is based on observation, orientation and notation. The books that I wrote for this course meet the Microsoft Vendor of Approved course ware. As the instructor for this program, Elizabeth is available to provide guidance and motivation for learners throughout the duration of this program. As an expert mentor, she will provide answers to learner questions, monitor learner's program progression, and review lesson and program quiz/test results.

Certification: Demonstrate that you have the skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program. Holding a MOS certification can earn an entry-level business employee as much as $16,000 more in annual salary than uncertified peers.* If you are pursuing the higher level Microsoft Office Specialist Expert and Microsoft Office Specialist Master certifications, becoming a certified Microsoft Office Specialist is a great entry point.Our new project-based testing for MOS 2013 provides industry-leading assessments of skills and knowledge, giving students and professionals real-world exercises to appraise their understanding of Microsoft Office.There are 7 exams that make up the MOS certification:MOS: Microsoft Office Word 2013MOS: Microsoft Office Excel 2013MOS: Microsoft Office PowerPoint 2013MOS: Microsoft Office Outlook 2013MOS: Microsoft Office Access 2013MOS: Microsoft SharePoint 2013MOS: Microsoft Office OneNote 2013

RequirementsThis program can only be taken on a PC. It is not compatible with a Mac. It is compatible with Windows 7 and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and an e-mail account. You should also have Microsoft Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word.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

II. Working with Outlook: Email, Calendar and Tasks• Learn how to customize E-mail stationery, signatures and replies• Create and modify appointments, schedule meetings and track responses• Learn how to use Tasks and Time Management• Learn which Print options work best for E-mail, Calendars and Lists• Use Advanced Search options to find the data in the Outlook folders

Microsoft Office WordI. Beginning Microsoft Word• Get skilled at working with Text and Pictures• Use Quick parts to create professional documents• Create a professional newsletter that includes graphics and charts

II. Intermediate Microsoft Word• 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• Use Microsoft Word Online

III. Advanced Microsoft Word• Learn effective methods for creating and formatting Tables• Understanding Font Styles and apply professional document formatting including creating a Tables of Contents, using Headers and Footers• Prepare to Share Documents by using the Proofing Tools and Tack Changes

Microsoft Office Excel I. Beginning Microsoft Excel • Enter data, format labels and create formulas in a price sheet• Use formulas to calculate numbers, text, dates and financial payments• Insert and modify Charts with the Chart Tools and the new Quick Click options• Use, format and modify Shapes, SmartArt, and ViewsMicrosoft Office Excel, ContinuedII. Intermediate Microsoft Excel • Create formulas that use Relative and Absolute values and audit the formulas• Use and modify TEXT formulas to combine cells (Concatenate) and format the data• 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• Excel Online: Use and modify Sparklines and hyperlinks

Microsoft PowerPoint I. Beginning Microsoft PowerPoint• Learn how to navigate the online course and submit your assignments• 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

II. Advanced Microsoft PowerPoint• 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• Add videos to a PowerPoint presentation and trim the media• Practice Delivering Presentations with the Presenter’s Tools• Use the Review Tools to Proof and Protect Presentations• Learn Options for saving and sharing PowerPoint presentations