PostsCommentsPayoutstansm11 (44)in dPoll • 5 years agoRE: [dpoll] Are you staying on STEEM, moving to new HIVE or trying to do both?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.tansm11 (44)in Excel For All • 5 years agoRE: Dynamic Positioning of Totals using Dynamic ArraysThis 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…tansm11 (44)in Excel For All • 5 years agoRE: Dynamic Positioning of Totals using Dynamic ArraysOkay, I will use Excel online.tansm11 (44)in Excel For All • 5 years agoRE: Dynamic Positioning of Totals using Dynamic ArraysI 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…tansm11 (44)in Excel For All • 5 years agoRE: Dynamic Positioning of Totals using Dynamic ArraysFor 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…tansm11 (44)in Excel For All • 5 years agoRE: Dynamic Positioning of Totals using Dynamic ArraysI got it. Thank you, Paula.tansm11 (44)in Excel For All • 5 years agoRE: Dynamic Positioning of Totals using Dynamic Arrays@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…tansm11 (44)in #excel • 5 years agoRE: Learn and Earn Activitiesare 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…tansm11 (44)in #excel • 5 years agoRE: How Use Excel T.TEST - Was a Marketing Campaign Successful?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…tansm11 (44)in #excel • 5 years agoRE: Excel Dynamic Arrays – A new way to model your Excel SpreadsheetsLearn 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…tansm11 (44)in #excel • 5 years agoRE: How to carry out a VLOOKUP within Text in ExcelExcel 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)tansm11 (44)in #curation • 5 years agoRE: HOW TO Always EARN STEEM with @JacobTS Curation on STEEMAUTO@jacobts Is this still on? I have followed all your steps above.tansm11 (44)in #excel • 5 years agoRE: Learn Excel Pivot Tables in less than 20 MinutesYes, they are.tansm11 (44)in #excel • 5 years agoRE: Learn Excel Pivot Tables in less than 20 MinutesLearn 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…tansm11 (44)in #excel • 5 years agoRE: The CHOOSE function in ExcelEarn 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…tansm11 (44)in #steemit • 5 years agoRE: Presenting UpvoteBank - NEW UPVOTE SERVICEDone.tansm11 (44)in #excel • 5 years agoRE: Excel Power Tools - The Future of ExcelEarn 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…tansm11 (44)in #steemit • 5 years agoRE: Presenting UpvoteBank - NEW UPVOTE SERVICEregistertansm11 (44)in #excel • 5 years agoRE: Funnel Charts In ExcelLearn 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 &…tansm11 (44)in #partiko • 5 years agoRE: Free Upvotes everyday for everyone@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.…