Posts

Comments

Payouts

• dernan (47)in Excel For All • 4 years ago

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

  Working that way, the table headers can not be dynamic, which is really a function I need from the tables. But thank you for the answer

  $0.30

  • Past Payouts $0.30
  • - Author $0.15
  • - Curators $0.15

   1 0
• dernan (47)in Excel For All • 5 years ago

  RE: 6 DAX tips for Excel and Power BI users

  It's been some time since you did a DAX article Paula. I have missed these. All the tips provided are great and it is hard to pick a favorite. If people could stick to these…

  $0.18

  • Past Payouts $0.18
  • - Author $0.09
  • - Curators $0.09

   1 0
• dernan (47)in #excel • 5 years ago

  RE: Excel Superstars you need to be following

  There are a few names on the list I do not recognize Paula, thank you for this resource. I will have to check them out. Are any of them going to join you and offer the learn…

  $0.24

  • Past Payouts $0.24
  • - Author $0.12
  • - Curators & beneficiaries $0.12
  • > steempress: $0.00

   3 1
• dernan (47)in #advancedfiltercontextindax • 5 years ago

  RE: DAX - FILTER inside CALCULATE

  Right! I think I got this one now. We need a column name on the left and a value on the right. If these criteria are not filled you must put FILTER inside of CALCULATE.

  $0.24

  • Past Payouts $0.24
  • - Author $0.12
  • - Curators & beneficiaries $0.12
  • > steempress: $0.00

   5 0
• dernan (47)in #excel • 5 years ago

  RE: 5 Reasons Spreadsheet Users should be using Excel 365

  hi Paula, thanks for sharing the link for the free month of Excel 365. It does not seem to be an affiliate link, how come? you do so much for Microsoft you should at least get…

  $0.24

  • Past Payouts $0.24
  • - Author $0.12
  • - Curators & beneficiaries $0.12
  • > steempress: $0.00

   3 1
• dernan (47)in #excel • 5 years ago

  RE: XLOOKUP V's VLOOKUP - 8 Limitations Removed

  Paula I was wondering when you were going to inform us about this. I have seen some articles on XLOOKUP on LinkedIn and I am eagerly awaiting the roll out to all Excel 365…

  $0.25

  • Past Payouts $0.25
  • - Author $0.12
  • - Curators & beneficiaries $0.12
  • > steempress: $0.00

   4 1
• dernan (47)in #excel • 5 years ago

  RE: Calculate 50 & 100-Day Moving Average with DAX

  Hello Paula. I have made my dashboard and I am really pleased with it. I followed this tutorial and the previous tutorial. I worked on them both during the week. But there is…

  $0.19

  • Past Payouts $0.19
  • - Author $0.14
  • - Curators & beneficiaries $0.05
  • > steempress: $0.00

   3 0
• dernan (47)in #excel • 5 years ago

  RE: Excel and Coinmarketcap - live cryptocurrency dashboard

  Paula, there is no way to upload the screen shots in the comments?

  $0.06

  • Past Payouts $0.06
  • - Author $0.04
  • - Curators & beneficiaries $0.01
  • > steempress: $0.00

   3 0
• dernan (47)in #excel • 5 years ago

  RE: Learn and Earn Activities

  This is really fantastic Paula, I hope to spend much to today catching up with loads of these learn and earn activities. Do you have like an index list of them? I know you send…

  $0.28

  • Past Payouts $0.28
  • - Author $0.21
  • - Curators & beneficiaries $0.07
  • > steempress: $0.00

   3 0
• dernan (47)in #excel • 5 years ago

  RE: How to Parse Custom JSON Data using Excel

  I have just come back to try this now and I am also getting the same error

  $0.00

   0 0
• dernan (47)in #excel • 5 years ago

  RE: Excel 101 – Getting Started with Excel 365

  Learn and earn activity 3 - I like the new natural language search, but if you want to get to a quick video tutorial, F1 I think is better.

  $0.28

  • Past Payouts $0.28
  • - Author $0.21
  • - Curators & beneficiaries $0.07
  • > steempress: $0.00

   3 0
• dernan (47)in #excel • 5 years ago

  RE: Excel 101 – Getting Started with Excel 365

  Learn and earn activity 2 - page setup is on the Page layout ribbon. Clipboard commands are found on the home ribbon

  $0.27

  • Past Payouts $0.27
  • - Author $0.20
  • - Curators & beneficiaries $0.07
  • > steempress: $0.00

   3 0
• dernan (47)in #excel • 5 years ago

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

  As always Paula this is a great resource, when I started out on powerpivot I always got that 'Relationships may be needed' warning and could never figure it out because it would…

  $0.65

  • Past Payouts $0.65
  • - Author $0.49
  • - Curators $0.16

   19 1
• dernan (47)in #excel • 5 years ago

  RE: Finding Your Way around Power Pivot - An Orientation

  I started using Powerpivot when it was introduced as an ad in way back in 2010. I am surprised that not more people have been using it. One thing I struggle with, and you will…

  $0.51

  • Past Payouts $0.51
  • - Author $0.38
  • - Curators $0.13

   13 1
• dernan (47)in #excel • 5 years ago

  RE: Excel 101 – Getting Started with Excel 365

  @theexcelclub you have blown me away with the detail in this post. This is a must-have #execl resource for all new excel user. You have pulled the hat out of the bag with this…

  $0.35

  • Past Payouts $0.35
  • - Author $0.27
  • - Curators $0.09

   6 1
• dernan (47)in #excel • 5 years ago

  RE: How to Resolve Errors in Excel Formula

  I never ran error checking on a full spreadsheet before, thanks for that. I did however resolve errors that were auto detected as they came up. its not something I would…

  $0.39

  • Past Payouts $0.39
  • - Author $0.29
  • - Curators $0.09

   9 0
• dernan (47)in #excel • 5 years ago

  RE: Step by Step - Named Ranges in Excel

  @theexcelclub you made this nice and easy indeed to earn steem rewards. I have a number of spreadsheets set up using named ranges, but most often I would use Table format and…

  $0.27

  • Past Payouts $0.27
  • - Author $0.22
  • - Curators $0.05

   5 1
• dernan (47)in #excel • 6 years ago

  RE: How to Reconcile Accounts using Power Query

  Paula this is exactly what I was looking for. I thought I would have to use Power Pivot and set up relationships. I haven't worked through the activity yet, but I will do and I…

  $0.34

  • Past Payouts $0.34
  • - Author $0.27
  • - Curators $0.07

   10 1
• dernan (47)in #excel • 6 years ago

  RE: The Secret Power of SUMPRODUCT in Excel

  Well Paula that was a very challenging activity I must say. I would really encourage others to try it out as working out the formula really made the penny drop on how sumproduct…

  $0.29

  • Past Payouts $0.29
  • - Author $0.23
  • - Curators $0.06

   6 1
• dernan (47)in #excel • 6 years ago

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

  @theexcelclub thank you for these tutorials. I started using Excel Power tools after reading a few of your articles and it's the best thing ever. although I must say, learning…

  $0.25

  • Past Payouts $0.25
  • - Author $0.20
  • - Curators $0.05

   3 1