• 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
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • 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 Forum|My Online Training Hub

You are here: Home / Excel Forum|My Online Training Hub

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel Forum
sp_GroupIcon
Rules and Guides
Please read before posting
sp_ForumIcon
Forum Rules and Guides
Topics 1
Posts 2
Last Post Philip Treacy - Read This First - May 13, 2020
sp_WriteDenied
sp_GroupIcon
Public Forums - For Registered Users
Anyone who has registered on the site can post in these forums
sp_ForumIcon
General Excel Questions & Answers
Topics 2168
Posts 9426
Last Post Hans Hallebeek - Unpivot Table with multiple headers and columns - May 25, 2023
sp_WriteDenied
sp_ForumIcon
Dashboards & Charts
Topics 433
Posts 1737
Last Post em em - Grand Totals on Pivot Charts - May 28, 2023
sp_WriteDenied
sp_ForumIcon
VBA & Macros
Topics 1082
Posts 5473
Last Post Hans Hallebeek - Help with error and vba code - May 27, 2023
sp_WriteDenied
sp_ForumIcon
Power Query
Topics 1184
Posts 5253
Last Post Riny van Eekelen - Online PDF - May 27, 2023
sp_WriteDenied
sp_ForumIcon
Power Pivot
Topics 272
Posts 1083
Last Post Michael Zandt - Need help about a measure in Powerpivot - May 28, 2023
sp_WriteDenied
sp_GroupIcon
Course Members Only
Only accessible by course members
sp_ForumIcon
Excel Dashboards
Topics 143
Posts 558
Last Post Mynda Treacy - 3.01 Formula for analysis - March 13, 2023
sp_WriteDenied
sp_ForumIcon
Power Query
For Power Query Course Members
Topics 497
Posts 2088
Last Post Mynda Treacy - Get data from file on FTP server - May 24, 2023
sp_WriteDenied
sp_ForumIcon
Power Pivot
For Power Pivot Course Members
Topics 178
Posts 738
Last Post Geoff McClure - Importing text files - delimiters not working - May 25, 2023
sp_WriteDenied
sp_ForumIcon
Xtreme Pivot Tables
Topics 37
Posts 139
Last Post Richard West - Losing the ability to format date cells in a pivot table. - April 14, 2023
sp_WriteDenied
sp_ForumIcon
Excel for Decision Making
Topics 10
Posts 23
Last Post Isaac Gottlieb - Calculating probability of outcome - February 13, 2022
sp_WriteDenied
sp_ForumIcon
Excel for Finance
Topics 5
Posts 11
Last Post Isaac Gottlieb - Time Value of money - NPV and IRR - April 20, 2020
sp_WriteDenied
sp_ForumIcon
Power BI
Topics 210
Posts 743
Last Post Mynda Treacy - Power BI - A calendar visual with an image for birthdays - May 18, 2023
sp_WriteDenied
sp_ForumIcon
Excel
Topics 9
Posts 29
Last Post Steve Talbot - Correct formula or can i use new 365 Formula instead - January 15, 2021
sp_WriteDenied
sp_ForumIcon
Word
Topics 3
Posts 6
Last Post Philip Treacy - creating a form - December 13, 2018
sp_WriteDenied
sp_ForumIcon
Outlook
Topics 3
Posts 9
Last Post Philip Treacy - Can I create a VBA script that is attached to a roaming profile? - October 7, 2016
sp_WriteDenied
sp_ForumIcon
Excel Expert
Topics 55
Posts 225
Last Post Mynda Treacy - Finding Duplicates. - April 23, 2023
sp_WriteDenied
sp_ForumIcon
Excel for Customer Service Professionals
Topics 7
Posts 23
Last Post Harold - Exercise 4 on EC_Poisson Distribution - August 8, 2020
sp_WriteDenied
sp_ForumIcon
Excel Analysis Toolpak
Topics 7
Posts 19
Last Post Isaac Gottlieb - Distribution of Household Income 2014 - March 31, 2020
sp_WriteDenied
sp_ForumIcon
Excel Tables
Topics 2
Posts 5
Last Post Mynda Treacy - IF matching row values in a table - April 23, 2022
sp_WriteDenied
sp_ForumIcon
Excel for Operations Management
Topics 4
Posts 9
Last Post Alaster Nyaude - BEP data file - March 14, 2020
sp_WriteDenied
sp_ForumIcon
Financial Modelling
Topics 17
Posts 60
Last Post stefano baldi - Tax Losses Used Formula - January 5, 2020
sp_WriteDenied
sp_ForumIcon
Advanced Excel Formulas
Topics 14
Posts 62
Last Post Riny van Eekelen - How to use conditional functions on a negative number? - May 5, 2023
sp_WriteDenied
sp_ForumIcon
Pivot Tables Quick Start
Topics 6
Posts 23
Last Post Mynda Treacy - Pivot Table - June 7, 2022
sp_WriteDenied
Unread and recently updated topics
Power Pivot
sp_TopicIconSmall
Need help about a measure in Powerpivot
Last Post sp_ArrowRight Michael Zandt 6 hours ago
Dashboards & Charts
sp_TopicIconSmall
Grand Totals on Pivot Charts
Last Post sp_ArrowRight em em 8 hours ago
Power Pivot
sp_TopicIconSmall
Sorting by sum of count in a pivot table
Last Post sp_ArrowRight Riny van Eekelen 13 hours ago
Power Query
sp_TopicIconSmall
Online PDF
Last Post sp_ArrowRight Riny van Eekelen 19 hours ago
sp_TopicIconSmall
Convert 2 column table with duplicate values in column 1 to table with multiple columns and unique values in column 1
Last Post sp_ArrowRight Alan Sidman 19 hours ago
sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Catalin Bombea, Vrinda Fernando
Guest(s) 9
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
jo moffitt
Michael Zandt
Ibraam Nasif
Gali Balmocena
Jocelyn Degran
Nurul Amalina
Sarah Mooney
Gopinath Gopalan
Nick Pape
Fakhar Zaman
Forum Stats:
Groups: 3
Forums: 24
Topics: 6347
Posts: 27751

 

Member Stats:
Guest Posters: 49
Members: 32305
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • 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
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

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.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x