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
- Machine Learning Part 7 — Forward propagation in neural net in SQL July 20, 2019
- Windowing functions in recursive CTE July 13, 2019
- Running On Screen Keyboard in Windows 10 in C# July 6, 2019