• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Excel PivotTables

Excel PivotTable Calculated Item

Excel PivotTable Calculated Items

May 12, 2015 by Mynda Treacy

Inserting Excel PivotTable Calculated Items is a great way to analyse your data and automatically incorporate that analysis in your PivotTables. Another way to think of them is the ability to add a new item to your report based on a formula which uses other items in the column. You can then include this new …

Read moreExcel PivotTable Calculated Items
Excel Slicers for Fiscal Years

Excel Slicers for Fiscal Years

May 6, 2015 by Mynda Treacy

There’s no built-in way to create Excel Slicers for fiscal years, however the solution is easily achieved by adding an extra column to your source data to classify each date into its relevant fiscal year. Download the Workbook Enter your email address below to download the sample workbook. Get Workbook By submitting your email address …

Read moreExcel Slicers for Fiscal Years
Excel Slicer rolling periods

Excel Slicers for Rolling Periods

May 6, 2015 by Mynda Treacy

Excel Slicers for rolling periods, for example; the last 12 months, requires a column in your source data that looks up the date and compares it to today’s date to see if it falls into the current period. Download the Workbook Enter your email address below to download the sample workbook. Get Workbook By submitting …

Read moreExcel Slicers for Rolling Periods
Single Slicer for Year and Month

Create a Single Excel Slicer for Year and Month

April 28, 2015 by Mynda Treacy

In this tutorial we’re going to look at how we can create a single Excel Slicer for Year and Month, as opposed to the default of having the Year and Month in separate Slicers. Let’s rewind a tad and look at how we got here in the first place. Below is an extract of my …

Read moreCreate a Single Excel Slicer for Year and Month

Excel PivotTable FAQ’s

March 4, 2015 by Mynda Treacy

After having thousands of people recently attend our free PivotTable webinar we found there were 3 questions that were asked again and again, which are: How do I format my data in an Excel Table so I can refresh my PivotTable and it automatically picks up any new data added? How do I change the …

Read moreExcel PivotTable FAQ’s
Excel PivotTable Expand and Collapse options

Excel PivotTable Expand, Collapse and Show Details

February 25, 2015 by Mynda Treacy

Excel PivotTables are a treasure trove of features. One of my favourites is the ability to expand/collapse and drill down into the data. Let’s look at an example; the first column of the PivotTable below lists Categories, which group and summarise Products. We can click on the + symbols to the left of the Category …

Read moreExcel PivotTable Expand, Collapse and Show Details
Excel PivotTable Calculated Field

Excel PivotTable Calculated Fields

February 4, 2015 by Mynda Treacy

Excel PivotTable Calculated Fields are easy to add but there are a couple of ‘gotchas’ you should be aware of. Calculated Field Definition Microsoft Definition: A Calculated Field is a user-defined field in a PivotTable that can perform calculations using the contents of other fields in the PivotTable. Calculated field formulas can refer to one …

Read moreExcel PivotTable Calculated Fields
getpivotdata function

Excel GETPIVOTDATA Function

October 20, 2014 by Mynda Treacy

In its simplest form the Excel GETPIVOTDATA function enables you to extract values from a PivotTable report, but if you’re like me when you first tried to figure out how to use GETPIVOTDATA, you were less than pleased with the results. Understandably so, because in its default form it’s quite inflexible. However, the benefit in …

Read moreExcel GETPIVOTDATA Function

Excel Pivot Tables Year on Year Change

September 8, 2014 by Mynda Treacy

PivotTables are a treasure trove of features and one that has been brought out of the dungeons in more recent Excel versions is ‘Show Values As’. In Excel 2007 it was hidden 3 clicks away in the Value Field Settings dialog box (see below): Then in Excel 2010 it was given prime position in the …

Read moreExcel Pivot Tables Year on Year Change
Excel Slicers

I’ll Have a Slicer That!

August 12, 2014 by Mynda Treacy

Not cake, sorry. I’m talking about Excel Slicers and while they are 'sweeeet', as my 8 year old says, and a piece of cake to use, they aren't quite as tasty. Slicers were introduced in Excel 2010 and they’re an interactive control that enables you to filter data in PivotTables, PivotCharts, Excel Tables and CUBE …

Read moreI’ll Have a Slicer That!
  • Previous
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to page 5
  • Next
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.