Tag Archives

Archive of posts published in the tag: Excel

Executing SQL query inside Excel spreadsheet

Did you know that you can execute almost any SQL query directly in your Excel spreadsheet? This can be very useful for executing queries with GROUP BY and aggregates since they cannot be generated that easily in Excel. Let’s begin. I will use…