- September 2023
- August 2023
- July 2023
- June 2023
- May 2023
- April 2023
- March 2023
- February 2023
- December 2022
- November 2022
- October 2022
- September 2022
- August 2022
- July 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- July 2021
- June 2021
- April 2021
- March 2021
- February 2021
- January 2021
- December 2020
- November 2020
- October 2020
- September 2020
- July 2020
| ID | Title 1 | Title 2 |
|---|---|---|
| Sample #1 | Row 1, Content 1 | Row 1, Content 2 |
| Sample #2 | Row 2, Content 1 | Row 2, Content 2 |
| Sample #3 | Row 3, Content 1 | Row 3, Content 2 |
If only there were a keyboard shortcut for that…
Excel has a vast range of keyboard shortcuts, and there have been a few added to the list over the years. New ones introduced include: However, I’m sure there’s a commonly-used feature you wish had a shortcut. Of course, you…
Excel’s border problem
Excel’s border styles help us enhance the structure and readability of our worksheets. Thick, thin, dotted and dashed — there are 13 variations to choose from in the Format Cells window. However, ever noticed how border lines on the edge…
Why has the price of a Microsoft 365 subscription not budged?
Two weeks ago, the bombshell news about Python integration coming to Excel was greeted with rip-roaring excitement. The secret had been well-kept by tight-lipped Microsoft MVPs, who were finally able to bombard us with their pre-recorded demos to whet our…
Unpivot data in Excel using Power Query
Sometimes data is perfectly shaped and structured — other times, it’s not. If you’ve used pivot tables, you’ll be familiar with the cross-tabular format, which summarises data based on two or more categorical variables. While this layout is great for…
Pods are ruining LinkedIn’s credibility
I’ve long been aware of the practice, but up until a few weeks ago, I didn’t have a scoobies what LinkedIn pods are. You might not either, so here’s a quick definition: A LinkedIn pod is a group of people…
How many Excel worksheet rows and columns fit on my screen?
It’s fair to say the monitor market has been pretty stagnant for a while, but I did snap up a 40″ ultrawide monitor a week or so ago (LG 40WP95CP-W.AEK). It has a resolution of 5120 × 2160, giving me…
Excel has a vast range of keyboard shortcuts, and there have been a few added to the list over the years. New ones introduced include: However, I’m sure there’s a commonly-used feature you wish had a shortcut. Of course, you…
Excel’s border styles help us enhance the structure and readability of our worksheets. Thick, thin, dotted and dashed — there are 13 variations to choose from in the Format Cells window. However, ever noticed how border lines on the edge…
Two weeks ago, the bombshell news about Python integration coming to Excel was greeted with rip-roaring excitement. The secret had been well-kept by tight-lipped Microsoft MVPs, who were finally able to bombard us with their pre-recorded demos to whet our…
Sometimes data is perfectly shaped and structured — other times, it’s not. If you’ve used pivot tables, you’ll be familiar with the cross-tabular format, which summarises data based on two or more categorical variables. While this layout is great for…
I’ve long been aware of the practice, but up until a few weeks ago, I didn’t have a scoobies what LinkedIn pods are. You might not either, so here’s a quick definition: A LinkedIn pod is a group of people…
It’s fair to say the monitor market has been pretty stagnant for a while, but I did snap up a 40″ ultrawide monitor a week or so ago (LG 40WP95CP-W.AEK). It has a resolution of 5120 × 2160, giving me…