By Sumit Bansal There is no inbuilt function in Excel to extract the numbers from a string in a cell (or vice versa – remove the numeric part and extract the text part from an alphanumeric string). However, this can be done using a cocktail of Excel functions or some simple VBA code. Let me first show you what Read More
Month: April 2021
How to Find the Earliest and Latest Date in Excel
We have a range of dates and we want to look up the earliest and the latest date based on certain criteria like the earliest date for a showing movie, we can use MIN and MAX functions with IF function or INDEX function together to find the matched date based on some criteria. Except using formula, we can also use Read More
How to Connect Google Drive to Power BI (Detail Steps)
Solution 1: Change the google share link Google share must be allowed everyone. At the end of the link, change from /edit?usp=sharing to /export?format=xlsx or /export?format=csv depends on the file extentions. Ruth from Curbal posted a youtube demo and an invoked function to make it even easier. Solution 2: Use the CData ODBC Driver (NOT Read More
How to Export Power BI Data to Excel (Step-by-Step)
Written by: Kasper Langmann, Microsoft Office Specialist. Exporting data from Power BI to Excel only takes 1 to 2 clicks! Though normally, it’s the other way around — importing data from Excel to Power BI. Nevertheless, it’s super easy and intuitive to do. In this article, we’ll show you the step-by-step process in exporting Power BI data Read More
How to Apply WHERE Clause in Power Query in EXCEL or Power BI
Go to Query Editor, find the year column, then click drop down to select Number Filters: The corresponding Power Query will be generated via above action:
Google Chrome DevTools (F12) Tips and Tricks
By Martin WilliamsUpdated Google Chrome is currently one of the most popular web browsers used by developers today. According to StatCounter, as of September 2019, Google Chrome holds 63.72% browser market share across the globe. The Chrome DevTools can greatly improve your workflow by helping you develop, test, and debug your websites right within your browser. Read More