Microsoft Quarterly Report was publicly released on April 25, 2024. It has tabulated data on year over year percent change in revenues by Microsoft fiscal quarter (Q1 is from July 1 through September 30). I tabulated the data from fiscal year 2023 Q1 through Q4, and from fiscal year 2024 Q1 through Q3 (Q4 data […]
Blog
Dumbbell Chart (Excel)
Dumbbell chart, aka Connected Dot plot is a type of chart that’s suitable for visually comparing values especially between two periods or showcase change. In this post, I demonstrate its usefulness as well some key steps on how to create one in Microsoft Excel (Office 365). Let’s start with the data. I have some data […]
Butterfly Chart (Excel)
Butterfly chart (aka Tornado or Divergent chart) is a type of bar chart used to compare two data sets side by side.It plots the data as two horizontal bars with the same X-axis in the center, resembling the butterfly wings.It gives a quick glance at the difference between two groups with the same parameters. It’s […]
An interactive musical keyboard player (Python)
In this post, I am sharing my Python code for creating a simple musical keyboard player that can be played using a standard computer keyboard. The app will generate specific musical notes as you press keys A-Z on your keyboard. You can increase a note by half-step or full-step by each press. So, increasing by […]
Find Superscripts, Subscripts, and Unicode in a text file (Python)
Occasionally, it becomes necessary to search for special characters like superscripts, subscripts, symbols, emojis, or any Unicode characters within a text document. This is crucial when working with data files that should not contain any such characters, unless they are explicitly required and managed. Most editors, including Word, lack a ‘Find’ feature that reveals all […]
How to make a perfect birthday cake in Excel
I’ve been exploring whether it’s possible to create a birthday cake-style chart in Excel. After some adjustments, I’ve reached a point where I can confidently say it’s achievable! You may ask, why not simply download an image from the internet? Well, that’s less engaging, potentially unlawful, and above all, it lacks the customization and scalability […]
Useful apps with PowerApps
With Microsoft PowerApps development platform, it’s convenient and relatively quick to create mobile and PC friendly apps by writing and designing the code just once. The apps are fully responsive on all devices (any manufacturer, any operating system) and supports both mouse and touch on any resolution of the device or computer. They can be […]
Excel…aww…I love you too!
Is it possible to use Excel for romantic or sentimental purposes? Absolutely! While Excel is commonly associated with routine tasks in accounting, finance, and data analysis, its capabilities extend far beyond these uses. In this post, I will showcase another unusual application of Excel that taps into its potential for more heartfelt endeavors. I experimented […]
Creating A Game Timeline Chart in Excel
Recently, while following the thrilling Premier League soccer (European football) matches, I came across an eye-catching visual representation of the day’s game scores and timelines on BBC Sports. The post appeared as follows (on my mobile app): It’s both beautiful, elegant and conveys the key events of the game without overwhelming the viewer with too […]
Windows 11 Boot MicroAnimation and Wise Monkey using just text
Recently, an ex-colleague of mine brought to our attention the Microsoft font possibly used in creating the spinning dots in Windows 11 boot screen. The font is called “Segoe Boot Semilight” and is a true type font. So, I had to verify that this is true, and I wanted to try to create the animation […]