Excel - 3 videos and a blog you cant miss
hive-102332·@theexcelclub·
0.000 HBDExcel - 3 videos and a blog you cant miss
<html> <p> We have 3 videos and a blog for you this week covering different aspects and skill levels of Excel, Power Query, and DAX. You will also find our first DAX learn and earn activity I hope you enjoy reading or watching this week's content and taking part in the learn and earn activity</p> <p><strong>VIDEO - Excel</strong></p> <p><a href="https://youtu.be/sELHaEwLiW8"><strong>Advanced filter in Excel - How to Extract data from a table with 1 criterion</strong></ins></a><br> </p> <p>Learn how to Extract data from a table based on 1 criterion using Excels Advanced filter feature. This is an awesome trick when working with large tables of data and you need to only really work with a subset of the table. This is the old school way of extracting data from a table in Excel as in pre-Excel 365. Excel 365 offers different solutions for this, however many have not yet moved to Excel 365 and this trick remains as important as ever</p> <p><strong>VIDEO - Power Query </strong></p> <p><a href="https://youtu.be/DgSHv4Vz260">Find your way around Excels Power Query with this orientation lesson</ins></a> </p> <p>Powerquery is an amazing tool in Excel that will allow you to connect to data and transform that data into a useable format. however, when you are new to power query, the new ribbons and interface might be a little daunting. But fear not, because, in this video, we are going to take a guided tour around Powerquery</p> <p><strong> Article & Video </strong></p> <p> <a href="https://theexcelclub.com/dax-and-or-in-or-syntax-which-one/"><strong>DAX AND OR IN or syntax(&& ||) – Which one?</strong></ins></a> </p> <p>Learn how to create a conditional statement in DAX using AND, OR, IN and the syntax && and || then put it into practice by downloading the workbook and you have the option to carry out a learn and earn activity <br> </p> <p><strong>Learn and Earn Activities</strong></p> <p>Here at The Excel Club we offer something truly unique. A chance to earn tokens while you learn. This week is the first week we have published a DAX learn and earn activity to add to our library. <a href="https://theexcelclub.com/learn-and-earn-steem-activities/">You can find out more about our learn and earn activities here</ins></a>. </p> </html>
👍 stmdev, scholaris, haxxdump, mindtrap-leo, babytarazkp, tonimontana.leo, toni.pal, limka, exe8422, laissez-faire, abh12345, circa, jayna, maxer27, gidlark, kibela, sharker, dalz, edkarnie, paulag, oakshieldholding, csy, princessamber, ghostdylan, roguewriter, block-power, znnuksfe, helpie, fragmentarion, stemisaria, niallon11, luisferchav, mountainjewel, spawnband, javicuesta, bembelmaniac, bflanagin, eonwarp, isaria, guchtere, redrica, jlsplatts, meno, angelro, socent, eonwarped, pechichemena, soulturtle, hazem91, zipporah, doomsdaychassis, big-m, veckinon, musicvoter, kbr, free-reign, shookriya, frejafri, kantos, ashikstd, blewitt, lillywilton, zainenn, winifredhiggs, isiahwalt, n32mente, bilpcoinrecords, wolfnworbeikood, musicvoter2, markaustin, alinalazareva, abh12345.pal, abh12345.stem, amico, cd-stem, onealfa.pal, cn-leo, church-of-god, weinweibgesang, macchiata, celinavisaez, soccermom, bluefinstudios, lamico, lightcaptured, techken, dernan, enjar, lion200, trevorpetrie, mammasitta, mytechtrail, anarcho-andrei, raise-me-up, seanlloyd, spectrumecons, esthersanchez, quarantine, freetosteemdream, enforcer48, bluerobo, grider123, steempope, darrenfj, hedge-x, rafaelg, diazkongming, amico.pal,