I voted for: I will stay on BOTH chains for the time being - and I will wait with my decision *Actually, I'm not sure yet.

This is what I did using Microsoft Excel online. For pull in the Amount of the invoice into column H: In cell H5, as I typed in =SUM, a drop-down list appeared, and I double-click on SUMIFS and =SUMIFS(

Okay, I will use Excel online.

I have went through the video above and I couldn't get the understanding on how to apply the dynamic arrays onto the Learn and Earn Activity above without entering a formula to each cell. I'm using my

For pull in the Amount of the invoice into column H: In cell H5, I typed in =SUMIFS(C1:C11,A1:A11,A2). In cell H6, I typed in =SUMIFS(C1:C11,A1:A11,A3). In cell H7, I typed in =SUMIFS(C1:C11,A1:A11,A4).

I got it. Thank you, Paula.

@paulag Paula, is the video above on how to create Dynamic Positioning of Totals using Dynamic arrays using Excels SEQUENCE function, has anything to do with the above Learn and Earn Activity? Are the

are you excited about the opportunity to earn while you learn Excel? Yes, I'm very excited. I can learn Excel and earn at the same time. where did you hear about The Excel Club and our Learn and Earn

Learn and Earn Activity 8: Copy the table of data below and work out if you could call the marketing campaign a success or not by carrying out a T.TEST By using the T.TEST, the marketing campaign turned

Learn and Earn Activity 7: Are you excited about this change and the introduction of Excel Dynamic Arrays? Leave a comment below telling us what you think of these changes and how you can see your self

Excel Learn and Earn Activity 6: What text function is needed in this case? MID What is the full formula that you used? =VLOOKUP(MID(A2,4,2)+0,$E$1:$F$7,2,FALSE)

@jacobts Is this still on? I have followed all your steps above.

Yes, they are.

Learn and Earn Activity 5: How often do you use pivot tables and what feature of a pivot table is your favorite and why? I haven't use pivot tables before but from this blog I like the feature where it

Earn and Learn Activity 4: Tell me what formula did you use to return the selling price? =CHOOSE(B11,B2,B3,B4) What is the formula used to return the Units sold? =CHOOSE(B11,B7,B8,B9) Which formula did

Done.

Earn and Learn 3: Thank you for sharing this knowledge, Paula. Did you share this post? I shared it in Twitter. Which Excel Power Tool do you use the most? I have never use any of the tools before but

register

Learn and Earn Activity: In your organization where could you apply funnel charts instead of a table of data? In my organization, funnel charts are very suitable for Sales & Marketing department. It

@sharingiscaring1 Hi. I have left you a message in your Discord group ( Get daily free upvotes is still available? I've followed all the steps in #start-cutation-trail channel. What happen to your Telegram