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 you can assign colors to values. You can choose More Rules… to … Continue reading Heat map in Excel
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. Let’s begin. I will use Excel 2013 but this method should work in other editions as well. First, create … Continue reading Executing SQL query inside Excel spreadsheet