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…
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…
Posts
- .NET Internals Cookbook Part 1 — Exceptions, filters and corrupted processes February 16, 2019
- .NET Internals Cookbook Part 0 — Table of contents February 16, 2019
- Turing Machine Part 5 — Twice as many ones as zeroes February 9, 2019