Mastering Pivot Table with Microsoft Excel
Mastering Pivot Table with Microsoft Excel MICROSOFT OFFICE PRO Microsoft Office Application Training Selangor, Malaysia, Kuala Lumpur (KL), Shah Alam Training, Workshop | Iconic Training Solutions Sdn Bhd

MAXIMIZING PIVOT TABLE WITH EXCEL
DURATION: 1 DAY

WHO IS THIS COURSE FOR?

Our Microsoft Excel Pivot Tables course is suitable for those with a basic working knowledge of Pivot Tables who want a greater understanding of the more sophisticated functions and features available.

PREREQUISITES

Prior use of Pivot Tables or our Excel Advanced course.

BENEFITS

At the end of this course you will have a greater understanding of the functionality and potential of Pivot Tables.
You will be able to construct and manipulate complex summaries and analyses of data using Pivot Table tools, control visual and data formatting, manage and add to the statistical analysis of your data, deal with varying data sources, automate, troubleshoot and utilise Pivoted data in many different contexts.

KEY CONTENT

Unit 1: Pivot Table Fundamentals

  • What is a Pivot Table?
  • When and why use a Pivot Table?
  • Anatomy of a Pivot Table
  • Limitations of Pivot Tables

Unit 2: Creating Basic Pivot Tables

  • Preparing your data
  • Tabular Layout
  • Removing Section Headings
  • Removing Repeated Column Groups
  • Eliminating Gaps
  • Type Formatting
  • Creating Pivot Tables
  • Adding Fields
  • Adding Layers
  • Altering Structure
  • Report Filters
  • Managing Changes in Your Source Data
  • Dynamic Named Ranges
  • Dealing with Zeroes
  • Subtotals
  • Summary Calculations
  • Running totals
  • Differences (year on year, month on month)
  • Percentages of Rows, Columns, Totals and other fields
  • Running Totals and Top 10 reports
  • Pivot Table Tools
  • Layout Updates
  • Refreshing & Restarting
  • Moving Pivot Tables

Unit 3: Pivot Table Views

  • Conditional formatting
  • Sorting, Filtering and Re-ordering
  • Slicers (2010 and above)
  • Timeline (2013 and above)
  • Saving Custom Views

Unit 4: Pivot Table Calculations

  • Calculated Fields and Items
  • Managing & maintaining Pivot Table calculations

Unit 5: Pivot Charts

  • What is a Pivot Chart?
  • Creating a Pivot Chart
  • Pivot Chart Rules
  • · Managing the underlying data
  • · Adding Layers
  • · Altering Structure
  • Pivot Chart Alternatives
  • · Dynamic Charts
  • · Transition tables

Unit 6: Working with Data Sources

  • Consolidating multiple sheets or ranges of data
  • Using external data sources (Access)

Unit 7: Automating Pivot Tables with Macros

  • Introducing Macros
  • Recording Pivot Table macros
  • Tidying and refining recorded macros
  • The Power Pivot add-in (2010 and above
METHODOLOGY

Informative presentation, Group Discussion & Presentations, Hands on Session Practical Session


Please leave your enquiry here, we will reply as soon as possible.


*only support gif, jpeg, jpg, png, pdf
Switch To Desktop Version