If you spend much time in Excel, you have probably found yourself doing some repetitive tasks to clean up a column of data. Or maybe instead of doing it manually, you might craft some formulas to do it for you. If you’re just doing a one-off cleanup, make sure you consider the Flash Fill feature in Excel. I recently used this in a demo to my team at work and many people in the room were surprised by it so I figured there were probably a few of you reading this who could benefit from it as well.
The basic idea is that you have one or more input columns and an output column. You provide an example or two of what the output should be and then you click the Flash Fill button. A magical wizard in your computer figures out the pattern and repeats it for the rest of the column. It really does feel like magic the first couple times you use it. Sometimes the algorithm gets it wrong for a few cells so you can just make a correction and it will update it’s algorithm and redo any cells that need it.
This video has a bunch of great examples:
If that’s not enough for you, check out prose-playground.cloudapp.net. The tech behind Flash Fill is open sourced out of Microsoft Research and this is one of the sample sites they have created. If you want to use the SDK, you can get it from GitHub.



I’m working on a new decorative sign for our house. After I had drawn it at full size in Photoshop Elements, I needed to print it full-size, tiled across multiple sheets of paper. It seems like there are a lot of ways to do this, but it took me long enough to figure out that I figured I should write it down.



Canon Speedlite 430EX III-RT
Tyla and I usually go for some bigger family gift at Christmas instead of exchanging gifts with each other. Our first gifts like this was the camera and that has gotten a lot of good use. This year we decided to add a nice flash to the camera.
I chose the Speedlite 430 EX III-RT. As the name implies, this is the third version of this model. It has way more features than we’ll ever need but it also means that I probably won’t ever feel the need to buy a different one.
It’s a fully automatic flash so it gets all the info it needs from the settings on the camera. The RT means it supports radio triggering. My camera doesn’t have a built in radio trigger but I could add one on and have the flash fire even if it’s not attached to the camera.
I really enjoy the ability to rotate the flash in two directions to bounce the flash off a nearby wall, etc. It gives a much more natural looking photo instead of the traditional on-camera flash look. I have a LOT to learn about how to use a flash but here’s one of my first tests.
Here’s the baseline. This is the built-in flash on the camera.

This is the new flash with the diffuser attached (it comes in the box with the flash.) It’s a little better but it’s still obviously a picture with a flash.

And finally here’s what it looks like with the new flash bouncing off the side wall. This one looks a lot more natural.

I’m excited to do some reading and really learn how to make good use of this gadget!