PivotTables & PivotCharts in Excel 2013 for Windows

Excel 2013 (Windows)    |    Intermediate
  • 14 videos | 1h 19m 18s
  • Earns a Badge
Likes 62 Likes 62
Analyze data efficiently using Excel 2013. Discover how to work with PivotTables, including formatting, sorting, filtering, grouping, and using slicers. In addition, explore how to insert, modify, and analyze using PivotCharts.

WHAT YOU WILL LEARN

  • Creating a PivotTable
    Creating a PivotTable with multiple data tables
    Editing your PivotTable
    Formatting your PivotTable
    Copying & reusing your PivotTable
    Inserting a calculation in your PivotTable
    Sorting & filtering data in your PivotTable
  • Grouping data in your PivotTable
    Inserting a slicer in your PivotTable
    Customizing your slicer
    Comparing values in a PivotTable
    Inserting a PivotChart
    Modifying your PivotChart
    Analyzing your database tables in a PivotChart

IN THIS COURSE

  • Playable
    1.  Creating a PivotTable in Excel 2013 for Windows
    4m 29s
    A PivotTable can be used to reanalyze data that has been inserted into your table. Excel 2013's PivotTable is extremely flexible and can be modified in a variety of different ways to extract previously-unseen patterns… FREE ACCESS
  • Playable
    2.  Creating a PivotTable with multiple data tables in Excel 2013 for Windows
    5m 47s
    A new feature introduced in Excel 2013 is the ability to create PivotTables that combine values from a variety of different data sources within your workbook. This allows you to reuse data found in distinct tables in your… FREE ACCESS
  • Locked
    3.  Editing your PivotTable in Excel 2013 for Windows
    5m 17s
    Excel 2013's PivotTables are extremely customizable. You can change the different fields that have been added and change the calculations that are performed. You can also update your PivotTable to ensure that it uses… FREE ACCESS
  • Locked
    4.  Formatting your PivotTable in Excel 2013 for Windows
    6m 2s
    If you want to improve the appearance of your PivotTable, you can change its formatting settings. In Excel 2013, you can change your PivotTable's style, color settings, and even the font that is used for your data… FREE ACCESS
  • Locked
    5.  Copying & reusing your PivotTable in Excel 2013 for Windows
    6m 51s
    Once you have created your PivotTable, you can move it, copy it, and reuse it. Once you have created a copy of your PivotTable, you can modify it as you see fit. You can copy and paste your PivotTables as much as you want… FREE ACCESS
  • Locked
    6.  Inserting a calculation in your PivotTable in Excel 2013 for Windows
    5m 26s
    As well as standard data fields, your Excel 2013 PivotTables can also be modified to display calculated fields. These are fields that are created using existing data and a calculation method. In this way, you can create… FREE ACCESS
  • Locked
    7.  Sorting & filtering data in your PivotTable in Excel 2013 for Windows
    8m 9s
    Excel 2013's PivotTables can be used to cross-reference different data values. You can also use the fields that you have inserted to filter and sort your data values. You can even add a special filter field, which is… FREE ACCESS
  • Locked
    8.  Grouping data in your PivotTable in Excel 2013 for Windows
    4m 39s
    Another useful way of sorting and organizing your data in your Excel 2013 PivotTable is to create data groups. You can, for example, group your data by month, year or category. You can also choose to temporarily hide data… FREE ACCESS
  • Locked
    9.  Inserting a slicer in your PivotTable in Excel 2013 for Windows
    4m 49s
    A slicer is a special filter tool offered by Excel 2013. It can be used to adjust the data that is visible in your PivotTable. It can also allow you to identify quickly the data filters that are currently applied. You can… FREE ACCESS
  • Locked
    10.  Customizing your slicer in Excel 2013 for Windows
    5m 56s
    If you use PivotTables and in particular slicers on a frequent basis, then you may find it useful to know how to customize these tools. In Excel 2013, you can change your slicer's style and appearance using a variety… FREE ACCESS
  • Locked
    11.  Comparing values in a PivotTable in Excel 2013 for Windows
    4m 47s
    In Excel 2013, you can change the way in which you compare the values in your PivotTable. You can visualize your values in percentages, as a difference, and you can even sort and recalculate your data in chronological… FREE ACCESS
  • Locked
    12.  Inserting a PivotChart in Excel 2013 for Windows
    5m 14s
    A PivotChart is a visual representation of the data contained in your PivotChart. This makes it extremely flexible and easy to modify. You can use the PivotChart tool in Excel 2013 to push the analysis of your original… FREE ACCESS
  • Locked
    13.  Modifying your PivotChart in Excel 2013 for Windows
    5m 29s
    PivotCharts are extremely customizable. In Excel 2013, you can change a number of different elements in your chart, including its style, color theme, and its label settings. FREE ACCESS
  • Locked
    14.  Analyzing your database tables in a PivotChart in Excel 2013 for Windows
    6m 24s
    If you have already created a database in Access, you can import your data tables into Excel 2013. This is a great time saver, as it means you can not only take advantage of the data that has already been collected, but… FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE