Complete Guide to Excel Pivot Tables

337 CQ
79 Lessons
Previous...
  • Playing
    3 CQ
    61. Intro to GetPivotData Formulas
    A lesson with MyExcelOnline
    View lesson

    As MyExcelOnline explains in this lesson, the GetPivotData formula uses the pivot table to create customized reports that give the user more flexibility.

    As MyExcelOnline explains in this lesson, the GetPivotData formula uses the pivot table to create customized reports that give the user more flexibility.

  • Playing
    3 CQ
    62. Custom Reports with GetPivotData
    A lesson with MyExcelOnline
    View lesson

    Now that you've learned about the benefits of working with GetPivotData formulas, begin creating your own custom reports in this MS Excel lesson!

    Now that you've learned about the benefits of working with GetPivotData formulas, begin creating your own custom reports in this MS Excel lesson!

  • Playing
    2 CQ
    63. Referencing Dates with GetPivotData
    A lesson with MyExcelOnline
    View lesson

    Learn how to reference dates using GetPivotData formula, using pivot table data that includes order dates as row labels and sum of sales in the values area.

    Learn how to reference dates using GetPivotData formula, using pivot table data that includes order dates as row labels and sum of sales in the values area.

  • Playing
    3 CQ
    64. Data Validation with GetPivotData
    A lesson with MyExcelOnline
    View lesson

    Find out how to use data validation to make an interactive GetPivotData formula! Create drop-down lists that update GetPivotData results based on the selection.

    Find out how to use data validation to make an interactive GetPivotData formula! Create drop-down lists that update GetPivotData results based on the selection.

  • Playing
    2 CQ
    65. Referencing Cells with GetPivotData
    A lesson with MyExcelOnline
    View lesson

    The most important data is not always the most visible. Learn how to move grand total data to the left column using the GetPivotData formula to reference cells.

    The most important data is not always the most visible. Learn how to move grand total data to the left column using the GetPivotData formula to reference cells.

More...
  • Recommended Recommended
  • History & In Progress History
  • Browse Library
  • Most Popular Library

Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

Start Interview

You don't have any lessons in your history.
Just find something that looks interesting and start learning!

Comments
500 characters max