This section focuses on one of Excel’s most powerful tools: PivotTables. Participants will explore all aspects of PivotTables, including creating a PivotTable; using the contextual tabs; pivoting, summarizing, and analyzing data; formatting the PivotTable; and using external data with a PivotTable. This section also includes information on Slicers (a new feature that lets users analyze and interpret pivoted data with ease) and the classic PivotTable frame (used in Excel 2003 and earlier). The session will conclude with a comprehensive introduction to integrating data with PowerPivot and creating a PivotTable from that data.
Related Products
-
Online Tools for Small Business
$15.00At the end of this course, you will know about popular free online tools for small business owners, understand basic functions of Google Docs, Canva, Trello, Survey Monkey, and MailChimp, be able to select tools that meet or match your business needs, and know how to use these tools in your business. -
Microsoft Excel Online: Getting Started
$0.00In this course you will learn how to use formulas and functions, work with data, rows, and columns, and sort and filter data. -
Microsoft Excel Online: Organizing Worksheet Data with Tables and Charts
$0.00In this course you will learn how to create and modify tables and charts. -
Introduction to HTML and CSS Coding: Getting Started with CSS
$15.00In this course you will learn how to add the "style" tag to the HTML code, add colors to elements with CSS, and use identifiers to select elements to style.
Reviews
There are no reviews yet.