0302 - Microsoft Excel - Pivot Tables
Course Description
Course Details Wouldn't it be great to learn how to effectively use all the advanced Excel pivot table features? In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities. Most organizations rely heavily on Microsoft Excel pivot tables to analyze and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. You'll see how to work with the numerous pivot table options and system settings to become skilled in developing useful analysis models and reports within your company. Impress your coworkers by learning how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. You'll discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid reporting mistakes when data is added or deleted. Whether you're new to pivot tables, need a refresher, or want to become the pivot table guru within your organization, this course is for you!
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 WatSPEED is available within four weeks of successful completion of each course and can be accessed in your student portal. Many of the Ed2Go courses are eligible towards the various online certificates offered by WatSPEED.
Requirements Microsoft Windows 7, Microsoft Windows 8.x, or Microsoft Windows 10; Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Office 2016. A free 30-day trial of Office 365 Home Premium may be available at Office Online. Then, a subscription can be purchased for as little as $6.99 per month. Please be sure to install the software on your computer before the course begins. Note: This course is not suitable for Macintosh users who are using the Office Mac Home versions or for users of older versions of Microsoft Excel. "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.