Paul's Geek Dad Blog

I'm a Dad and a Geek. My blog is about teaching my kids to be producers, not just consumers of technology. My tinkering exists somewhere at the intersection between home automation, the internet of things, the maker movement and fitness. It's a nice place to be!

Friday, 4 February 2022

Cheating at Wordle with Python, NLTK and a Raspberry Pi

›
At the time of writing, the game Wordle is taking the world by storm.  Quite rightly, it's genius and so is the guy who invented it.   H...
Saturday, 3 April 2021

Excel Basics - Autofill

›
Ever noticed the tiny little square on the bottom right of the rectangle that goes around the cell you have selected?   This is called Autof...
Friday, 2 April 2021

Excel Hack - Getting a Newline in an Excel Cell When Entering Text

›
Excel is best for numbers but sometimes you find yourself entering lots of text in a cell.  To format the text it's helpful to be able t...
Tuesday, 30 March 2021

Excel Hack - Using a "Magic" Apostrophe to Force a Cell to be Text

›
In Excel you can prefix values in cells with an apostrophe to force Excel to interpret them as text.  Why do this you may ask? To explain, l...
Sunday, 28 March 2021

Excel Hack - Concatenating (Adding Together) Text in Different Cells

›
Sometimes in Excel you have values (generally text) in different cells that you want to piece together into a single cell.  In the example b...

Excel Basics - Paste Special + Transpose to Turn a Column of Values into A Row

›
Sometimes in Excel you have values lined up in a single column and you want to get all the values in a single row.  Maybe you want to create...

Excel Hack - Error Checking

›
A wise person once said "To err is human".  Well Excel sometimes creates errors as well.  Luckily there's a built-in way to ch...
1 comment:
›
Home
View web version

About Me

Geek Dad
View my complete profile
Powered by Blogger.