paulag rebloggedtheexcelclub (66)in #excel • 3 days agoHow to use XMATCH in ExcelIf you are familiar with the MATCH function in Excel then you are going to love XMATCH. Just like the MATCH function…paulag rebloggedtheexcelclub (66)in #excel • 8 days agoExcel Data Validation - Control and Restrict user inputsIn Excel Data Validation will allow you to add an element of control to your spreadsheets by restricting when the user…paulag rebloggedtheexcelclub (66)in #excel • 15 days agoDAX LOOKUPVALUE – Power BI and Excel Power PivotDAX LOOKUPVALUE will allow you search for a specified value or string and return a corresponding value from a…paulag rebloggedtheexcelclub (66)in #excel • 22 days agoAvoid Transformation steps in DAX (Excel and PowerBI)When you are analysing data, it is important to both understand the data that you have and make sure you prep your…paulag rebloggedtheexcelclub (66)in Excel For All • last monthThe Sort Functions in Excel (SORT, and SORTBY)In this article we are going to explore the SORT functions in Excel. Included in the new Dynamic Arrays functions…paulag (73)in OCD • last monthGender Equality, Sexual Harassment, or a load of S**T?Bit of an odd topic for me to be discussing, but this comes from a conversation I recently had with a friend. As many…paulag (73)in OCD • last monthCelebrating - Follow your passion and things will happenIf you have a passion, don't be afraid to follow it. Be consistent, work hard, don't give up and great things can…paulag (73)in LeoFinance • 2 months agoTutorial - Using Excels new STOCKHISTORY function to get historic Cryptocurrency pricing into ExcelTwo weeks back I announced an upcoming function in Excel that will allow you to get historic cryptocurrency pricing…paulag rebloggedtheexcelclub (66)in Excel For All • 2 months agoData Profiling views in Power Query (Excel and Power BI)Data profiling views in Power query were first introduced in Power BI and has since been rolled out to the Power query…paulag (73)in LeoFinance • 2 months agoSTOCKHISTORY in Excel - Get Historic Cryptocurrency pricing into Excel with this new functionThere is a new #Excel function - STOCKHISTORY that will allow you dynamically pull in historic pricing for a…paulag (73)in OCD • 2 months agoMay Hive Post Payouts (V's steem May '18)Hay Hivers. Its been a while. Too long. Since the Hive began, I have struggled to find the time to be active. With…paulag rebloggedtheexcelclub (66)in Excel For All • 2 months agoQuickly gather statistics for your data using Excels Descriptive StatisticsExcels Descriptive Statistics will quickly allow you calculate a number of statistics from multiple columns of data at…paulag rebloggedtheexcelclub (66)in Excel For All • 2 months agoHow to create Stock Charts in ExcelStock charts are a specific chart used to track the changes in price of traded assets. Assets such commodities…paulag rebloggedtheexcelclub (66)in Excel For All • 3 months agoUp and Running with Excel Form ControlsExcel form controls are a kind of user interface that can be added to a worksheet. You can add a single form control…paulag rebloggedtheexcelclub (66)in Excel For All • 3 months agoHow to create a Household budget in ExcelThere are many reasons you would want to keep a household budget. Setting a budget allows you to control spending and…paulag (73)in OCD • 3 months agoSo I did it - Its Live :-) How is everyone? I have been so so busy I have not had the time to either post or curate. I have no idea what's…paulag (73)in #excel • 3 months agoBig AnnouncementA few weeks back I mentioned I was working on a charity course for Covid-19 relief. When I started working on this…paulag rebloggedtheexcelclub (66)in Excel For All • 4 months agoLearn how to Group Data in Excel and use SubtotalsGrouping Data Last week we looked at the Outline feature in Excel. While the automatic outlining capabilities in…paulag rebloggedtheexcelclub (66)in Excel For All • 4 months agoIts rather simple to use the Outline feature in ExcelThe Outline Feature in Excel Excel’s automatic outlining feature makes outlining a worksheet easy. Automatic…paulag (73)in GEMS • 4 months agoYou have been challenged - C19 Hive entertainment schemeBeing in lockdown is not much fun unless you make it fun. And so has been born, the C19 Hive entertainment scheme - A…
