Mastering Excel PivotTables and PivotCharts Course

Excel PivotTables and PivotCharts Training Course

Excel PivotTable/樞紐分析表 是Excel中最具有代表性,功能最強大之一的工具。 只需幾步便將大量數據轉換為報告。

Excel樞紐分析表課程將教您從頭開始到終結報告的製作過程,包括準備適合Excel樞紐分析表的數據,選擇正確的樞紐分析表顯示模式,使用 Excel公式和函數插入計算欄保護數據,並合併來自不同文件的數據。 可以使用 Excel PivotCharts /樞紐分析圖

互相交模式地呈現最終結果。

整個學習過程全部是實踐練習,學員可以利用所學到的知識來分析數據及匯出報告,並且我們是小班教學,學員可以進一步提高成效。

Excel PivotTables and PivotCharts Training Course

What you’ll learn

Understanding Pivottables

  • Understanding Data Analysis.
  • Introducing the PivotTable.
  • Learn PivotTable Benefits.
  • Survey PivotTable Uses.
  • Explore PivotTable Features.

Building A Pivottable

  • Prepare Your Worksheet Data.
  • Create a Table for a PivotTable Report.
  • Build a PivotTable from an Excel Table.
  • Build a PivotTable from an Excel Range.
  • Re-create an Existing PivotTable.

Manipulating Your Pivottable

  • Turn the PivotTable Field List On and Off.
  • Customize the PivotTable Field List.
  • Select PivotTable Items.
  • Remove a PivotTable Field.
  • Refresh PivotTable Data.
  • Display the Details Behind PivotTable Data.
  • Create a Chart from PivotTable Data.
  • Enable the Classic PivotTable Layout.
  • Add Multiple Fields to the Row or Column Area.
  • Add Multiple Fields to the Data Area.
  • Add Multiple Fields to the Page Area.
  • Convert a PivotTable to Regular Data.
  • Delete a PivotTable.

Changing The Pivottable View

  • Move a Field to a Different Area.
  • Display a Different Page.
  • Change the Order of Fields Within an Area.
  • Change the Report Layout.
  • Sort PivotTable Data with AutoSort.
  • Move Row and Column Items.
  • Filter Row or Column Items.
  • Filter PivotTable Values.
  • Hide Items in a Row or Column Field.
  • Show Hidden Items in a Row or Column Field.
  • Show Pages as Worksheets.
  • Group Numeric Values.
  • Group Date and Time Values.
  • Group Text Values.
  • Hide Group Details.
  • Show Group Details.
  • Ungroup Values.
  • Change the Page Area Layout.

Customizing Pivottable Fields

  • Rename a PivotTable Field.
  • Rename a PivotTable Item.
  • Format a PivotTable Cell.
  • Apply a Numeric Format to PivotTable Data.
  • Apply a Date Format to PivotTable Data.
  • Apply a Conditional Format to PivotTable Data.
  • Show Items with No Data.

Setting Pivottable Options

  • Apply a PivotTable Quick Style.
  • Create a Custom PivotTable Quick Style.
  • Preserve PivotTable Formatting.
  • Rename the PivotTable.
  • Turn Off Grand Totals.
  • Merge Item Labels.

Performing Pivottable Calculations

  • Change the PivotTable Summary Calculation.
  • Create a Difference Summary Calculation.
  • Create a Percentage Summary Calculation.
  • Create a Running Total Summary Calculation.
  • Turn Off Subtotals for a Field.
  • Display Multiple Subtotals for a Field.

Creating Custom Pivottable Calculations

  • Introducing Custom Calculations.
  • Understanding Custom Calculation Limitations.
  • Insert a Custom Calculated Field.
  • Insert a Custom Calculated Item.
  • Edit a Custom Calculation.

Creating A Pivotchart

  • Understanding PivotChart Limitations.
  • Create a PivotChart from a PivotTable.
  • Create a PivotChart Beside a PivotTable.
  • Create a PivotChart from an Excel Table.
  • Move a PivotChart to Another Sheet.
  • Filter a PivotChart.
  • Change the PivotChart Type.
  • Sort the PivotChart.
  • Add PivotChart Titles.
  • Move the PivotChart Legend.
  • Display a Data Table with the PivotChart.
  • Print a PivotChart.
  • Delete a PivotChart.

Disperate And External Data Sources

  • Create a PivotTable from Multiple Consolidation Ranges.
  • Create a PivotTable from an Existing PivotTable.
  • Create a PivotTable from External Data.

SCHEDULES
 
WPT0113 - 廣東話 24 Nov enrol
 
WPT0114 - 廣東話 29 Nov enrol
 
WPT0121 - Eng 03 Dec enrol
 
WPT0122 - 廣東話 16 Dec enrol
 
WPT0123 - 廣東話 29 Dec enrol
RELATING COURSES
  Excel VBA
  Excel Dashboards and Reports
  Excel-Advanced
  Excel-formulas & functions
  Financial Accounting with Excel