Skip to content
sparrowsolutions.ca
  • Home
  • Training
  • Contact Us
  • Blog
  • Privacy Policy
  • Toggle website search
Menu Close
  • Home
  • Training
  • Contact Us
  • Blog
  • Privacy Policy
  • Toggle website search

Excel tips

  1. Home>
  2. Blog>
  3. Excel tips

How to Add Mean (Average), Median, or other calculations to a pivot table column

  • Post author:sparr652
  • Post published:November 17, 2023
  • Post category:Excel tips

How can you add an AVERAGE calculation to a pivot table column? Pivot tables are a great tool for summarizing data and include many helpful features, including the ability to…

Continue ReadingHow to Add Mean (Average), Median, or other calculations to a pivot table column
Read more about the article Multiple Criteria Lookup Formula, or How to Create Complicated Formulas When Required

Multiple Criteria Lookup Formula, or How to Create Complicated Formulas When Required

  • Post author:sparr652
  • Post published:September 8, 2021
  • Post category:Excel tips

Multiple Criteria Lookup options, and how to break a complex problem down into a series of manageable pieces

Continue ReadingMultiple Criteria Lookup Formula, or How to Create Complicated Formulas When Required

Separate Data From Reports for Best Results

  • Post author:sparr652
  • Post published:January 21, 2021
  • Post category:Excel tips

Two Good Reasons to Separate Your Data From Your Reports While it is convenient to have everything in one spreadsheet, and even on one worksheet, there are a number of…

Continue ReadingSeparate Data From Reports for Best Results
  • 1
  • 2
  • 3
  • Go to the next page

About Me

About Me

Tim Easter

After working as a finance officer and in other roles, I am now using my experiences to help others overcome their frustrations with spreadsheets, reporting, and analysis so they can get the results they are looking for.

Recent Posts

  • How to Add Mean (Average), Median, or other calculations to a pivot table column
  • Excel Power Features To Learn
  • Multiple Criteria Lookup Formula, or How to Create Complicated Formulas When Required
  • Separate Data From Reports for Best Results

Recent Posts

  • How to Add Mean (Average), Median, or other calculations to a pivot table column
  • Excel Power Features To Learn
  • Multiple Criteria Lookup Formula, or How to Create Complicated Formulas When Required
  • Separate Data From Reports for Best Results
  • Open Database Connectivity (ODBC) Drivers – freeing data from programs​

Recent Comments

  • Excel Power Features To Learn - Sparrowsolutions.ca on A Key Advantage of Tables
  • Multiple Criteria Lookup Formula, Or How To Create Complicated Formulas When Required - Sparrowsolutions.ca on A Key Advantage of Tables
  • Multiple Criteria Lookup Formula, Or How To Create Complicated Formulas When Required - Sparrowsolutions.ca on VLOOKUP vs INDEX MATCH
  • Elementor #443 - sparrowsolutions.ca on A Key Advantage of Tables

Archives

  • November 2023
  • January 2022
  • September 2021
  • January 2021
  • December 2020
  • May 2020
  • April 2020
  • February 2020
  • January 2020
  • December 2019
  • October 2019

Categories

  • Excel tips
  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright - WordPress Theme by OceanWP