bobumlas (25)in Excel For All • 4 years agoRE: [QUESTION- HELP NEEDED] I can't set a date as the column header in a table? Unfortunately, no you can't.paulag (73)in #excel • 5 years agoRE: Excel Superstars you need to be followingHi @dernan. I can't believe I didn't include Excelisfun. I have just updated the list. Mike has some of the most…paulag (73)in #excel • 5 years agoRE: 5 Reasons Spreadsheet Users should be using Excel 365I never signed up to be an affiliate. I don't even know if they do affiliates. Thanks for mentioning it, I will look…theexcelclub (66)in #excel • 5 years agoRE: XLOOKUP V's VLOOKUP - 8 Limitations RemovedSup @dernan, as always thanks for stopping by. I'm sure you won't be too long waiting. I will let you know when it's available.theexcelclub (66)in #excel • 5 years agoRE: Easy Excel Solutions: Power Pivot Many to Many Relationshipshi @dernan, I'm glad you enjoyed the post. thanks for taking part in the learn and earn activitysteemitboard (66)in #art • 5 years agoRE: Did you Know - Cash Collages - Ladies and Gentleman There is No Cause for AlarmCongratulations @dernan! You received a personal award! Birthday! - You are on the Steem blockchain for 2…theexcelclub (66)in #excel • 5 years agoRE: Finding Your Way around Power Pivot - An Orientationthe uptake as been a bit slow, but I have seen a shift now with people using Power BI moretheexcelclub (66)in #excel • 5 years agoRE: Excel 101 – Getting Started with Excel 365Hi @dernan, I knew even experienced excel users like you would enjoy this resource. I look forward to seeing you…paulag (73)in #excel • 5 years agoRE: Step by Step - Named Ranges in ExcelI think I have to make a tutorial on dynamic named ranges now too, tables do rock and that is a great alternative :-)theexcelclub (66)in #excel • 5 years agoRE: How to Reconcile Accounts using Power QueryI look forward to seeing your solutions or questions so. Thank you for your feedback, I am glad you found this article and video of valuetheexcelclub (66)in #excel • 5 years agoRE: The Secret Power of SUMPRODUCT in ExcelDernan I should have known you would be the first in here to solve this, you will have to wait now till next week when…theexcelclub (66)in #excel • 5 years agoRE: Related and RelatedTable - DAX for Power Pivot, Power BI and SSASHi Dernan, and thank you for your feedback. It looks like people are enjoying the ability to earn some of these…paulag (73)in #excel • 5 years agoRE: Power BI Custom Visuals - Dial Gaugehello @dernan, great visualization, thanks for sharingpaulag (73)in #excel • 5 years agoRE: Tips for Analyzing Categorical Data in ExcelHi @dernan, yes the COUNTA function in excel is great when working with categorical data.theexcelclub (66)in #excel • 5 years agoRE: Excel's Map Chartshi dernan and thanks for stopping by. Great suggestion on the tutorial thanks.steemitboard (66)in #art • 6 years agoRE: Did you Know - Cash Collages - Ladies and Gentleman There is No Cause for AlarmCongratulations @dernan! You received a personal award! Early AccessThank you for taking part in the early access…theexcelclub (66)in #excel • 6 years agoRE: SWITCH Function in DAX for Excel Power Pivot and Power BIHi @dernan, yes there is a switch function in Excel. I havent yet covered it as a learning blog. as for the…theexcelclub (66)in #excel • 6 years agoRE: How to carry out a VLOOKUP within Text in ExcelNice work @dernan, you are correct. thank you for taking part in our learn and earn activitypaulag (73)in #excel • 6 years agoRE: How to Parse Custom JSON Data using Excelthanks for the share @dernan, and yep it is advanced, but you should try it, its not that difficult. And next week I…paulag (73)in #excel • 6 years agoRE: Learn to use VLOOKUP in ExcelNice work @dernan, you got all of this correct. There is actually a LOOKUP skills test available free on the website…