(PRWEB) March 24, 2014
Software training firm Infinite Skills Inc. this week released its "Microsoft Excel - Pivot Tables In-Depth Tutorial," an intermediate course concentrating on one of the most powerful tools in Excel for quickly and simply producing visual summaries of complex data.
Pivot tables can automatically perform many functions on spreadsheet data, including sorting, counting, and averaging, as well as more advanced calculations, providing users with quick, easy access to data summaries and visualizations.
Infinite Skills' Microsoft Excel - Pivot Tables In-Depth Tutorial offers targeted training on pivot tables, allowing Excel users to master this powerful feature in a matter of hours, and begin using pivot tables efficiently in a daily workflow.
Course author and Microsoft Certified Instructor Erin Olsen, began working with Excel and SharePoint while running her own small business. She holds a master's degree in education with emphasis on instructional design and technology and has been a computer trainer since 1994, starting with Windows 3.1. Her training style is based on real-world experience as an entrepreneur, orienting her instruction style toward the practical needs of everyday users in a business environment.
Following an introduction to the course and an overview of pivot tables, Olsen begins by explaining the various elements of a pivot table. This chapter also explains how to prepare data for use in a pivot table, and the various ways of creating pivot tables.
Olsen then teaches how to manage data in a pivot table, explaining how to work with the data source, control pivot table refresh, work with the pivot cache, and how to pivot data in a pivot table.
The course continues with chapters on formatting, where students learn to apply basic sorting, filtering, and grouping commands, leading into lessons teaching how to work with advanced calculations in pivot tables.
Olsen closes with a chapter devoted to data visualization, where students learn to create and manipulate pivot charts.
"Pivot tables are the most important tool in Excel that can organize, filter, summarize, and make sense of enormous amount of data with relative ease and little technical skill," Olsen says.
"The goal of this course is to help you learn to leverage existing data, regardless of its complexity, and summarize it in an organized, meaningful way, successfully turning raw data into useful information."
Free demo videos and a full list of course contents can be found on the Microsoft Excel - Pivot Tables In-Depth training page of the Infinite Skills website:
Infinite Skills offers its Microsoft Excel - Pivot Tables In Depth as a direct download from the company website at a retail price of $24.95. All titles and formats are compatible with Mac and Windows operating systems. Shipping is available around the globe. Additionally, Infinite Skills tutorials are supported by project files which correspond to examples in the videos, allowing users to work alongside experienced instructors right on their computer or iPad.
About Infinite Skills Inc.
A leader in the field of software training, Infinite Skills designs its courses on a task-oriented model, teaching complex skills by providing hands-on examples and guiding users as they carry out essential functions. Infinite Skills offers a wide range of software titles available as DVDs, digital downloads, and in iPad editions. Infinite Skills now offers a subscription service, providing access to all its training content for a monthly fee, keeping with company's aim of delivering professional training to customers anywhere they want to learn.