Today I took another stab at automating my blog posts.
Today I learned how to clean up my Mac with Hazel
Converting Aperture photo libraries to Lightroom
TIL how to concatenate columns and convert time in Excel and some more SQL functions.
TIL how to sum in Excel with filters and a trick for bringing myself back in perspective.
TIL about easier syntax highlighting and how to download WordPress.com email subscribers in a CSV.
TIL how to keep track of files and requests in Slack.
TIL how to make code snippets pretty, which VPN client to use, and common misconceptions about privacy.
TIL two ways to tile patterns in Photoshop. One is manual and time consuming, the other is fast, easy, and less prone to error. I also re-learned some stuff about Homestead and Composer.
TIL about what to consider when architecting and planning out a software development project, how to automate the tedious parts of my TIL posts, how to tackle the lack of parent selectors in CSS, and project-wide find and replace in Coda.