0360 - What's New in Microsoft Office 2010

Course Description

Course Details Get up to speed on the latest version of Microsoft Office 2010! In these lessons, you'll explore all the new features of Office as you work with Word documents, Excel spreadsheets, PowerPoint presentations, and Access databases. As you master each program, you'll explore both the new 2010 features and those added in 2007. If you're still using Office 2003 or 2007, you'll learn how to transition smoothly to this newer version—and if you're already using Office 2010, you'll discover ways to work more quickly, efficiently, and confidently. In Word, you'll learn all about the new 2010 File tab. After that, you'll see how to manage your documents in Backstage View and work with the new Picture SmartArt layouts. Then you'll find out how to make your documents more accessible to all users with the Accessibility Checker, and learn how to find anything in your documents quickly with the Navigation pane. Finally, you'll discover that working in a multicultural world is easier than ever with the new Mini Translator. In Excel, you'll see what the File tab does and find out how to save your worksheet as a PDF file. Next, you'll learn how sparklines let you illustrate your data in a compact format, discover how slicers allow you to summarize data quickly, and delve into brand-new formatting options. In PowerPoint, we'll look at the new File tab and then move on to SmartArt picture layouts and the new Picture background removal feature. In addition, you'll see how video styles can make your videos look spectacular and how the Transitions tab can make slide show transitions easy. You'll also master new animation effects, examine how to organize long presentations using sections, and learn how to create a video from any PowerPoint presentation. In Access, you'll learn how to use the new data type parts to quickly add pre-made fields to a database, and explore application parts (which are like templates you can add to your databases). You'll see how Access 2010 lets you use themes in forms and reports, and how you can share your Access tables, forms, and reports by publishing to other formats and exporting objects to the Web. Before you know it, you'll be using each MS Office 2010 program with ease, accomplishing your work faster, and creating documents that look better than ever! How It Works This course is fully online, you require internet access and an email account. The course duration is 6 weeks, followed by a 2-week period to complete the final exam (online, open book). Lessons are released on Wednesdays and Fridays of each week, for a total of 12. You are not required to be online at any specific time. In addition to the specific lesson content, there is a discussion board with each lesson and often there is an optional assignment to apply the learning. Following each lesson, there is a short multiple choice quiz. Your score on these quizzes does not count towards the final mark but completing these helps solidify your learning as well as prepare you for the final exam. The final exam is an open-book, multiple choice exam and you need to achieve a minimum of 65% on the final exam to pass the course. There is only one opportunity to pass the exam. A certificate of completion from Ed2Go is available for printing immediately upon successful completion of the course and a certificate from the University of Waterloo will be emailed typically 1-2 weeks later. Many of the Ed2Go courses are eligible towards the various online certificates offered by WatSPEED. Requirements • Internet access • Email • One of the following browsers: o Mozilla Firefox o Microsoft Internet Explorer (9.0 or above) o Google Chrome o Safari • Adobe PDF plug-in (a free download obtained at Adobe.com .) Microsoft Office 2010 (Word, Excel, PowerPoint, and Access) SP1 (software must be installed and fully operational before the course begins); Microsoft Windows XP, Vista, or Windows 7. Note: This course is not suitable for Macintosh users. The course assumes a basic knowledge of Word, Excel, PowerPoint, and Access 2003 or 2007. However, all tasks are taught using simple explanations in an easy step-by-step format, so even someone who has little practice at using some features will still be able to master the basics of Office 2010 and complete the course. Note: "Starter Version" and "Web App" versions of Microsoft Word 2010 and Microsoft Excel 2010 will not work with the full version of Word and Excel taught in this course. *Prior experience with at least two Microsoft Office 2003, 2007, or 2010 programs is recommended.