Select Page

Excel Charts and Pivot Tables

R1,890.00

  • 03:28:00

    Hours of learning

  • Presented by highly qualified, industry leading experts
  • 12 Months access
SKU: 545eb795aea0 Category:
DESCRIPTION

Overview

Can you create a chart or run a report in Excel for Windows? Can you make a dashboard? In this series,  learn how to create charts,   PivotTables,   and PivotCharts.   In this Daniel and Vonne kick off the Excel Charts and Pivot tables series by building your foundational knowledge in regards to Charts.   Here they will identify the parts of a Chart,   define terms used,   and look at the contextual tabs you'll use when working with Charts.

Objectives

  1. Interpreting a Data Dictionary.
  2. Creating a PivotTable.
  3. Manipulating PivotTable Fields.
  4. Using Slicers.

Prerequisites

  • Navigate an Excel spreadsheet
  • Create basic formulas
  • Sort and filter data
  • Work with tables
  • Manage named ranges

Target Audience

  • Individual
  • Accountants
  • Auditor
  • Financial analyst