paulag in #hive-167922 • 3 months 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…paulag in #hive-167922 • 3 months agoConnect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chartGet historical cryptocurrency pricing into Excel using CoinGecko API and learn to create a quick stock chart. The…paulag rebloggedtheexcelclub in #excel • 4 months agoFind the corresponding value from Multiple column match in ExcelDo you fancy a bit of an Excel Data Challenge? Something to get you thinking creatively with your Excel Skills…paulag rebloggedtheexcelclub in #excel • 5 months agoLearn How to Fix Totals and Subtotals in DAXLearn how to fix totals and subtotals in DAX for PowerBI and Power Pivot The problem of incorrect totals and…paulag rebloggedtheexcelclub in #excel • 5 months ago3 Ways to Set Screen Scroll Lock Area in ExcelOften there are times when a spreadsheet developer has the need to set the screen scroll lock area in Excel…paulag rebloggedtheexcelclub in #excel • 5 months agoDocument Entire Excel Workbook with the Click of a ButtonWhy Document an Entire Excel Workbook You already know the story.... or do you…..? So the internal accountant…paulag rebloggedtheexcelclub in #excel • 5 months agoFind Hard-coded values in Excel FormulasFinding hard-coded values within Excel Formulas is something Excel users have struggled with for a long time. While I…paulag rebloggedtheexcelclub in #excel • 5 months agoExcel Hidden and Very Hidden Sheets - What's the difference?Hidden and Very Hidden Sheets in Excel - Skip to Video As most of us know, Excel, being such an amazing tool, gives…paulag rebloggedtheexcelclub in #excel • 6 months agoEasy Excel Lessons - Transposing Data and Converting Text to ColumnsTransposing Data and Converting Text to Columns can be done quickly in Excel. Having the ability to do so, will save…paulag rebloggedtheexcelclub in #excel • 6 months agoHow to connect Excel to Coinmarketcap APIUsing the Coinmarketcap API, you can quickly get live ticker information into your Excel spreadsheet for your favorite…paulag rebloggedtheexcelclub in #excel • 6 months agoEasy steps to Convert Snowflake to a Star- DAX ModelingIf there is one piece of advice, I could give to DAX users, it would be to keep the structure of the model simple.…paulag rebloggedtheexcelclub in #excel • 7 months agoUltimate Guide - Compare two lists or datasets in ExcelHay Paula, can you compare lists in Excel? or What is the best way to compare two sets of data in Excel? Very…paulag rebloggedtheexcelclub in #excel • 7 months 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 in #excel • 7 months 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 in #excel • 7 months 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 in #excel • 7 months 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 in #hive-102332 • 8 months agoThe 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 rebloggedtheexcelclub in #hive-102332 • 8 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 rebloggedtheexcelclub in #hive-102332 • 9 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 in #hive-102332 • 9 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…