Curs 50448 Maximizing PivotTable Microsoft Excel

 Curs Excel Maximizing PivotTable Microsoft  Curs 50448

Inregistrati-va

Module 1: Making Data Work For You

This module how to make use of Excel data and maximize it through the use of PivotTable.

Lessons

  • Maximize the Power of PivotTable
  • Ask the Questions
  • Get the Answer

Module 2: Making Data Work For You

  • Maximize the Power of PivotTable

Module 3: A Quick Tour

Lessons

  • Determine What You Need to Know
  • Identify the Source
  • Creating the Pivot Table
  • Working with Pivot Table Layout

After completing this module, students will be able to:

  • Determine the source needed for its PivotTable
  • Create the PivotTable
  • Working with the PivotTable

Module 4: Manipulating the PivotTable

  • Rearranging the Layout
  • Adding New Field
  • Renaming a Field
  • Formatting Numbers
  • Changing Sorting Order
  • Showing Top 10
  • Refreshing Data

Module 5: Manipulating the PivotTable

  • Rearrange the layout of the PivotTable
  • Adding, renaming New Field within the PivotTable
  • Formatting Number in the PivotTable reports
  • Changing Sorting Order
  • Refreshing Source data within the PivotTable

Module 6: Digging Deeper

  • Grouping Items
  • Displaying Subtotals
  • Hiding/Showing Grand Totals
  • Formatting PivotTable
  • Using Slicer
  • Formatting Slicer

After completing this module, students will be able to:

  • Display grouping and subtotals for PivotTable
  • Formatting PivotTable
  • Organize PivotTable through the use of Slicer

Module 7: Beyond the Basics

  • Creating Second Data Field
  • Changing the Summary Function
  • Displaying Numerical Value as a Percentage of the Total
  • Creating a Custom Calculation
  • More Function in Custom Calculation

After completing this module, students will be able to:

  • Create a Second Data Field within the PivotTable
  • Changing Summary Function
  • Displaying Numerical Value as a Percentage of the Total
  • Create custom calculation within the PivotTable

Module 8: More PivotTable Calculations

  • Using Formulas
  • Creating a Calculated Field
  • Creating a Calculated Item
  • Using GetPivotData Function
  • Turn off GetPivotData Function

After completing this module, students will be able to:

  • Use Formulas with the PivotTable
  • Create a calculated field and item
  • Using GetPivotData Function
  • Turn off GetPivotData Function

Module 9: Optional Topics

  • Creating PivotChart
  • Publishing PivotTable to the Web
  • Using Multiple Source Ranges

Module 10: Optional Topics

After completing this module, students will be able to:

  • Creating PivotChart
  • Publishing PivotTable to the Web
  • Using Multiple Source Ranges to create PivotTable

Inregistrati-va

Locatia de desfasurare a cursului:

Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti

Cine susține cursul?

Master Office 2013 Cristi

Master Office 2013 Cristi

Durata Curs
2 zile: 9:00 – 17:00

Cunostinte prealabile

Familiarity with Microsoft Office applications – particularly Excel

Cursuri Conexe

Curs Creare Dashboards Cu PowerPivot Power View Si SharePoint – Curs 55103
Curs 50450 – Curs Excel Creating and Analyzing Database Using Microsoft Excel
Curs 55084 – Curs Excel 2013 Self-Service Analytics with No Code for the End User
Curs Excel 2013 – Advanced Microsoft Excel 2013
Curs Excel 2013 PowerPivot – PowerBI
Curs 50448 Maximizing PivotTable Microsoft Excel
Curs 55143 Microsoft Office Excel Basic Workbooks Formulas and Functions
Curs Microsoft Excel 2016 – Incepator
Curs Microsoft Excel 2016 – Mediu
Curs Microsoft Excel 2016 – Avansat
Curs Microsoft Excel 2013 – Incepator
Curs Microsoft Excel 2013 – Mediu
Curs Microsoft Excel 2013 – Avansat
Curs Microsoft Excel 2010 – Incepator
Curs Microsoft Excel 2010 – Mediu
Curs Microsoft Excel 2010 – Avansat
Curs Microsoft Excel 2007 – Incepator
Curs Microsoft Excel 2007 – Mediu
Curs Microsoft Excel 2007 – Avansat

Abonați-vă la newsletter

Program
Luni – Vineri: 9:00 – 17:00
Sambata, Duminica: Inchis

Ne găsiți la
Telefon/Fax: 021 367 0092
Telefon: 0748.11.23.23
Str. Transilavaniei, nr. 24, Sector 1, Bucuresti,
Cod Postal 010798, ROMANIA