Tag Archives

Archive of posts published in the tag: Excel

Heat map in Excel

If you ever wondered how to create heat maps in excel, here are two simple solutions. Data preparation Create two columns with data, as presented below. Next, select values in column C and choose conditional formatting in Home ribbon (see screenshot). This way…

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. Let’s begin. I will use Excel 2013…