Familiarity with tables, charts and formulas. A web camera (suggested but not required). Access to a computer with speakers & microphone (or the ability to call in via phone). In this module, you will learn about the fundamentals of analyzing data using a spreadsheet, and learn how to filter and sort. Pivot Tables are one of Microsoft Excel’s greatest strengths and most useful tools, allowing for the management of transaction data. Video created by IBM for the course 'Excel Basics for Data Analysis'. Excel Pivot Tables: 2013/2016 NEW This class is offered online using Zoom. How to Create Pivot Tables in Microsoft Excel 2013 Part 1. Prerequisites: Users with a good understanding of Excel. Prerequisites: Users with a good understanding of Excel. ![]() Upon successful completion of this course, you should be able to: ![]() ![]() The class will also include an overview of creating standard tables and charts from an Excel worksheet however, participants need to have a good understanding of and experience with Excel prior to this class. Pivot Tables are interactive and dynamic, enabling you to make comparisons and answer specific questions without having to write new formulas, copy and paste cells, or reorganize rows and columns. NEW! Do you work with Excel documents involving large, cumbersome amounts of data? You can use the Microsoft Excel Pivot Tables feature to quickly extract meaningful, concise information from this data and look at the data in many different ways.
0 Comments
Leave a Reply. |