Update 04/21/2023: Windy.GoogleTranslate is now a paid package and requires a license to use. Click here to visit the package purchase and info page. Introduction You might know that Google Sheets has a GOOGLETRANSLATE function that you can use for translating texts between languages. Microsoft Excel, on the other hand, doesn't natively have such a function. In...

SQL Query function in Excel If you're reading this article you probably know that Google Sheets has a QUERY function that allows you to run SQL-like queries against data in the sheet. This function lets you do all sorts of gymnastics with the data in your sheet, be it filtering, aggregating, or pivoting data. Being a...

SQL support inside Excel Have you ever worked with data in Excel and thought to yourself: "This would be so much easier to do with SQL"? With the tool I'm about to show you, you can actually use SQL in Excel. It's convenient, powerful and it even comes with intellisense. First glance The tool I'm referring to...