The Excel Club Newsletter

in Excel For All2 years ago


We have 3 videos for you this week covering different aspects and skill levels of Excel, Power Query, and DAX.  One of which is the solution to last week's learn and earn activity.  I hope you enjoy reading or watching this week's content and taking part in the learn and earn activity.DAX AND OR IN or syntax(&& ||) – Which one?
Article & Video
Last week you learned how to create a conditional statement in DAX using AND, OR, IN and the syntax && and ||.  At the end of the article, you were given a problem to solve.  How did you get on?  We have now updated the article by adding the solution video. You will find it at the end of the article. If you missed last week's article and activity, now is a great time to catch up.
VIDEO - Power Query

How to Append tables in Power Query for Excel and Power BI
 When you are working with data, less is often more. One way of reducing the number of tables you have is to append the tables or sit one on top of the other. In this video, you will learn how to append tables using Power Query. #powerquery can be found in both #excel and #powerbi and this method works in both.
VIDEO - Excel

How to create and understand Logical tests and IF statement in Excel
 Excel is a great tool for carrying out logical tests and IF statement type calculations. A logical test will test to see if an expression or a formula returns a true or false result. for example does A=B. An IF statement will allow you to replace the true or false results with a result of your choice. IF statement is a must-have Excel skill
Learn and Earn Activities

Here at The Excel Club we offer something truly unique.  A chance to earn tokens while you learn. Last week we published a DAX learn and earn activity to add to our library.
  You can find out more about our learn and earn activities here



Sort:  

Love the challenges! I didn’t see that yet but I know to look periodically for them now! I’ll see if I have time to give it a try!

awesome - I would love to see you take part :-)

Congratulations @theexcelclub! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :

You distributed more than 23000 upvotes. Your next target is to reach 24000 upvotes.

You can view your badges on your Steem Board and compare to others on the Steem Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Do not miss the last post from @steemitboard:

Valentine's day challenge - Give a badge to your beloved!
Vote for @Steemitboard as a witness to get one more award and increased upvotes!

Coin Marketplace

STEEM 0.49
TRX 0.09
JST 0.066
BTC 50175.98
ETH 4296.57
BNB 567.72
SBD 6.31