EXCEL PIVOT TABLES – ONE DAY WORKSHOP

Prerequisites

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level.

Goals

Master everything related to Pivot Tables. Create Reports and deal with PT problems.

Excel Pivot Tables Topics

  1. Understanding Pivot Tables
  2. Source data for Pivot Table reports
  3. Creating Worksheet Lists
  4. Using a Name in a Formula
  5. Creating Names for a Multiple Rows or Columns
  6. Creating Names for a Value or Formula
  7. Creating a Pivot Table
  8. Pivot Table Field List
  9. Pivot Table Tools
  10. Rearranging the Pivot Table
  11. Changing the Report Field Titles
  12. Formatting Data Fields
  13. Using the Report Filter
  14. Displaying Filtered Fields on Separate Worksheets
  15. Formatting the Pivot Table
  16. Sorting Data
  17. Using Formulas Functions
  18. Create a Calculated Field
  19. Add or remove subtotals in a Pivot Table report
  20. Display or Hide Details
  21. Working with Multiple Data Ranges
  22. Setting up the source data
  23. Creating Pivot Charts
  24. Using Pivot Table Data Outside the Pivot Table Report
  25. Create relationships between data from different sources
  26. Creating a Pivot Table from a Database
Share This Post
Have your say!
0 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

SUBSCRIBE TO OUR EMAILING LIST AND RECEIVE FREE BOOK

Receive my Amazing Textbook “Pivot Tables From Zero To Hero” Totally FREE when you subscribe below to our emailing list.
SUBSCRIBE NOW
close-link