• 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 Factor 6 Auto Refresh PivotTables

Excel Factor 6 Auto Refresh PivotTables

July 18, 2012 by Mynda Treacy

This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Excel PivotTables are one of the greatest tools in the spreadsheet user’s toolkit. However, there is one tiny bit of functionality that appears to be missing: the ability of pivot tables to automatically update when information in the source data changes. Most …

Read moreExcel Factor 6 Auto Refresh PivotTables
Excel Factor Entry 1 - Reverse PivotTable

Excel Factor Entry 1 – Reverse PivotTable

June 20, 2012 by Mynda Treacy

How to Create a Reverse PivotTable - this is genius. This tutorial was sent in by Bryon Smedley of Bristol, Tennessee. There comes a time when you are presented with data in a cross-tabular format but your analysis requires that the data be formatted into a traditional table (or normalized) structure. Your report is in …

Read moreExcel Factor Entry 1 – Reverse PivotTable
Excel Pivot Table Video Tutorial

Excel Pivot Table Video Tutorial

January 21, 2011 by Mynda Treacy

An Excel Pivot Table is one of the most powerful productivity tools available, but some common data layout mistakes can make Pivot Tables difficult, frustrating and downright scary for some users. Thankfully these issues are easily fixed. I've put together a short video that'll get you started with Pivot Tables, and when your data is …

Read moreExcel Pivot Table Video Tutorial

Excel Pivot Tables Explained

November 1, 2010 by Mynda Treacy

Excel Pivot Tables are one of the most powerful tools at our disposal, and once you understand how they work, they’re actually quite easy to insert and modify.  In this example we’re going to work with a small amount of data (see image below) for illustration purposes, but they are in their element with huge …

Read moreExcel Pivot Tables Explained
  • Previous
  • Go to page 1
  • Interim pages omitted …
  • Go to page 3
  • Go to page 4
  • Go to page 5
  • 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.