New: powerpivotAll contenthive-129948hive-196917krsteemzzanhive-166405hive-183959hive-185836hive-180932photographyhive-183397uncommonlabhive-150122hive-144064hive-101145krsuccessbitcoinhive-145157hive-188619hive-184714hive-193637hive-139150hive-180301lifehive-103599TrendingNewHotLikerspaulag (73)in excel • 4 years agoMy top Excel Blog Posts of 20202020 is coming close to an end and it has probably been a year most of us are happy to say goodbye to. However, even with all the ongoings, I still feel like I have a lot to celebrate. The Excel…paulag (73)in excel • 5 years agoFREE course for DAX usersNew Course for DAX users Hot off the Press and FREE for a limited time only Top Tips for DAX users - PowerBI and PowerPivot #excel #powerpivot #powerbi #dax #exceltipstheexcelclub (66)in excel • 5 years agoDate tables for DAX users – Power BI and Power PivotAre you using Date tables in your DAX models? If not, why not? If you are using Power BI or Power Pivot then you should be using a date table in your model. Some people would argue that it is not…theexcelclub (66)in excel • 5 years ago[VIDEO] PowerPivot - Working with Pivot tables created with Powerpivot dataIn this video, you will learn how to work with pivot tables created from Power Pivot data . This is video is the second video contained within an article PowerPivot - Inserting and working with…theexcelclub (66)in excel • 5 years ago[VIDEO] How to Insert Pivot Tables from Excels PowerPivotIn this video, you will learn how to insert a pivot table from data stored in Excels Power Pivot. This is video is the first from 2 contained within an article PowerPivot - Inserting and working…theexcelclub (66)in powerpivot • 6 years ago[VIDEO] Find your way around Excels Power Pivot ( orientation video)Read the full article and take part in a Learn and Earn activity based on this video If you are new to Power Pivot in Excel then this video is for you. In this video, you will get an orientation…theexcelclub (66)in excel • 6 years agoHow to Resolve Errors in Excel FormulaIt is not uncommon to encounter errors in spreadsheets. But thankfully Microsoft has equipped Excel with tools to help resolve errors in Excel formula. This includes the ability to evaluate…theexcelclub (66)in excel • 6 years agoStep by Step - Named Ranges in ExcelBefore we really get stuck into this article please go ahead and download the workbooks so that you can practice along step by step. There is no email or sign up to download the files. This…theexcelclub (66)in excel • 6 years agowith Learn and Earn ActivityAre #Excel Power Tools the Future of Excel? Learn how data analysis and business intelligence is now in the hands of #Excel users #powerpivot #powerview #powerquery #dataanalysis…theexcelclub (66)in powerpivot • 6 years agotheexcelclub's twitter Feed : 2019/05/09 12:23:08Learn to use the DAX expression SWITCH. Take part in the learn and earn activity and be rewarded. There is value in learning with @theexcelclub #Powerpivot #DAX #PowerBI #Excel #share2steem…theexcelclub (66)in excel • 6 years agoThe Secret Power of SUMPRODUCT in ExcelSUMPRODUCT in Excel works by multiplying value pairs together and then adding the results together. However, SUMPRODUCT is a function that accepts arrays, making it a very powerful function…myotherstuff (48)in steem • 6 years agomyotherstuff's twitter Feed : 2019/05/03 11:04:33I love steem because you can Earn #steem while you learn #Excel and #powerbi Learn how to use RELATED and RELATEDTABLE expressions in DAX for #Excel #PowerPivot and #powerbi with video and Learn…theexcelclub (66)in excel • 6 years agoRelated and RelatedTable - DAX for Power Pivot, Power BI and SSASWhen we looked at the SUM and SUMX expressions in an earlier article and video we introduced the use of RELATED. You will remember this expression; =[Qty] * RELATED(products[Sales Price])…theexcelclub (66)in powerbi • 6 years agotheexcelclub's twitter Feed : 2019/05/02 12:22:02Don't miss the latest #powerbi tutorial from Avi Singh of @powerbipro Great tutorial Avi, thanks :-) #powerbi #dataanalysis #powerpivot #excel #share2steem Power BI Tutorial From…theexcelclub (66)in excel • 6 years agoPower BI Custom Visuals - Dial GaugePower BI is equipped with many different visualization that you can use to tell the story of your data. In addition to the standard visuals, Power BI also allows you to import custom visuals. If…theexcelclub (66)in excel • 6 years agotheexcelclub's twitter Feed : 2019/04/28 21:27:58Most people that move from #excel #powerpivot to #powerbi need no more than an orientation of #powerbi as the skills are transferable. Get a FREE orientation of #powerbi today #excel #powerbi…theexcelclub (66)in dax • 6 years agotheexcelclub's twitter Feed : 2019/04/18 12:50:05Learn to use SWITCH in #DAX for #powerpivot and #powerbi with learn and earn activity for you to complete and video solution #share2steem #powerpivot #dax #PowerBI External Link : SWITCH…theexcelclub (66)in dax • 6 years agotheexcelclub's twitter Feed : 2019/04/15 17:28:37New to #DAX for #powerbi or #excel #powerpivot? Learn how to use #DAX SUM and SUMX expressions #share2steem External Link : DAX SUM and SUMX Functions for Power BI, Power Pivot &…theexcelclub (66)in excel • 6 years agoWonderfully Weird function in ExcelExcel is full of wonderful and weird features and functions. With so many functions available, a lot of the time there is more than one way you can solve a problem in Excel. Sometimes I look at…theexcelclub (66)in excel • 6 years agoStandardize in Excel - Let's compare apples with orangesCan you compare apples with oranges? Generally speaking, the answer is no. However, if we use standard deviation as a measure, then we can. Using standard deviation to compare data with different…