• theexcelclub (67)in Excel For All • 5 years ago

  RE: Answered - Help needed with Tables - Why cant I set a date or formula in my column header

  Hi Dernan, you can not use either formulas or dates column headers to tables. You are doing nothing wrong, its just how Excel works. When I am faced with this issue myself…

  $0.31

  • Past Payouts $0.31
  • - Author $0.16
  • - Curators $0.16

   2 1
• paulag (73)in #excel • 6 years ago

  RE: Excel Superstars you need to be following

  Hi @dernan. I can't believe I didn't include Excelisfun. I have just updated the list. Mike has some of the most awesome classes. There is nothing left untouched on his…

  $0.00

   0 0
• paulag (73)in #excel • 6 years ago

  RE: 5 Reasons Spreadsheet Users should be using Excel 365

  I never signed up to be an affiliate. I don't even know if they do affiliates. Thanks for mentioning it, I will look into it :-) The live chat is a cool feature, but it is text chat.

  $0.00

   0 0
• theexcelclub (67)in #excel • 6 years ago

  RE: XLOOKUP V's VLOOKUP - 8 Limitations Removed

  Sup @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.

  $0.00

   0 0
• theexcelclub (67)in #excel • 6 years ago

  RE: Easy Excel Solutions: Power Pivot Many to Many Relationships

  hi @dernan, I'm glad you enjoyed the post. thanks for taking part in the learn and earn activity

  $0.00

   0 0
• steemitboard (66)in #art • 6 years ago

  RE: Did you Know - Cash Collages - Ladies and Gentleman There is No Cause for Alarm

  Congratulations @dernan! You received a personal award! Birthday! - You are on the Steem blockchain for 2 years! You can view your badges on your Steem Board and…

  $0.00

   0 0
• theexcelclub (67)in #excel • 6 years ago

  RE: Finding Your Way around Power Pivot - An Orientation

  the uptake as been a bit slow, but I have seen a shift now with people using Power BI more

  $0.00

   0 0
• theexcelclub (67)in #excel • 6 years ago

  RE: Excel 101 – Getting Started with Excel 365

  Hi @dernan, I knew even experienced excel users like you would enjoy this resource. I look forward to seeing you complete the rest of the activities and I do hope that you will…

  $0.00

   1 0
• paulag (73)in #excel • 6 years ago

  RE: Step by Step - Named Ranges in Excel

  I think I have to make a tutorial on dynamic named ranges now too, tables do rock and that is a great alternative :-)

  $0.00

   0 0
• theexcelclub (67)in #excel • 6 years ago

  RE: How to Reconcile Accounts using Power Query

  I look forward to seeing your solutions or questions so. Thank you for your feedback, I am glad you found this article and video of value

  $0.06

  • Past Payouts $0.06
  • - Author $0.05
  • - Curators $0.00

   2 0
• theexcelclub (67)in #excel • 6 years ago

  RE: The Secret Power of SUMPRODUCT in Excel

  Dernan I should have known you would be the first in here to solve this, you will have to wait now till next week when I publish the solutions to find out if you are right

  $0.00

   0 0
• theexcelclub (67)in #excel • 6 years ago

  RE: Related and RelatedTable - DAX for Power Pivot, Power BI and SSAS

  Hi Dernan, and thank you for your feedback. It looks like people are enjoying the ability to earn some of these tokens while earning about excel and powerbi. Well done also on…

  $0.22

  • Past Payouts $0.22
  • - Author $0.17
  • - Curators $0.06

   1 0
• paulag (73)in #excel • 6 years ago

  RE: Power BI Custom Visuals - Dial Gauge

  hello @dernan, great visualization, thanks for sharing

  $0.00

   0 0
• paulag (73)in #excel • 6 years ago

  RE: Tips for Analyzing Categorical Data in Excel

  Hi @dernan, yes the COUNTA function in excel is great when working with categorical data.

  $0.00

   0 0
• theexcelclub (67)in #excel • 6 years ago

  RE: Excel's Map Charts

  hi dernan and thanks for stopping by. Great suggestion on the tutorial thanks.

  $0.00

   0 0
• steemitboard (66)in #art • 7 years ago

  RE: Did you Know - Cash Collages - Ladies and Gentleman There is No Cause for Alarm

  Congratulations @dernan! You received a personal award! Early AccessThank you for taking part in the early access of Drugwars. You can view your badges on your Steem…

  $0.00

   0 0
• theexcelclub (67)in #excel • 7 years ago

  RE: SWITCH Function in DAX for Excel and Power BI

  Hi @dernan, yes there is a switch function in Excel. I havent yet covered it as a learning blog. as for the calculated column - you are correct, columns can be used as fields…

  $0.00

   0 0
• theexcelclub (67)in #excel • 7 years ago

  RE: How to carry out a VLOOKUP within Text in Excel

  Nice work @dernan, you are correct. thank you for taking part in our learn and earn activity

  $0.00

   0 0
• paulag (73)in #excel • 7 years ago

  RE: How to Parse Custom JSON Data using Excel

  thanks for the share @dernan, and yep it is advanced, but you should try it, its not that difficult. And next week I will have the video solution to the activity

  $0.12

  • Past Payouts $0.12
  • - Author $0.09
  • - Curators $0.03

   2 0
• paulag (73)in #excel • 7 years ago

  RE: Learn to use VLOOKUP in Excel

  Nice work @dernan, you got all of this correct. There is actually a LOOKUP skills test available free on the website if you would like to try it out http

  $0.00

   0 0