Sometimes you will see the information that asks you whether you want to save the changes or not. But actually you make no change to the file. Why does this information still appear? If you make some modifications to an Excel file and then close it without saving, it will ask you whether you want Read More
Extract Numbers From a String in Excel (Using Formulas or VBA)
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
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: