In this two-minute guide, I’ll show you a quick and easy method to create a Gmail desktop app. Unfortunately, Gmail does not have a downloadable desktop app of their own, so we’ll have to do a quick workaround. This guide requires you to use Google Chrome as your main internet browser. We use a Mac in the examples, but Read More
Excel VBA – How to Turn Automatic Calculations Off (or On)
Whenever you update a cell, Excel goes through a process to recalculate the workbook. When working directly within Excel you want this to happen 99.9% of the time (the exception being if you are working with an extremely large workbook). However, this can really slow down your VBA code. It’s a good practice to set Read More
How to Prevent Excel From Auto Calculating and Updating Data in Your Workbook?
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