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 […]
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 […]
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 […]
How to Connect Google Drive to Power BI (Detail Steps)
The following steps can be followed to connect Google Drive to Power BI: Start by specifying your connection in an OCBC DSN. All Google APIs can be integrated on behalf of either an individual or an organization, as per your requirement. Once the DSN has been created, you can proceed with connecting the Google Drive […]
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 […]
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: