2017 in review and a look forward to 2018

Happy New Year to you all!

spacex launch

Max Q‘ is a term used in rocketry to denote the moment during a rocket flight when aerodynamic stress on the rocket’s airframe is at it’s maximum. It’s one of the early milestones of any flight, and one of the most dangerous to boot. Astronauts and engineers both breathe a sigh of relief when the rocket passes this point. Engines, which have been throttled back to 60 – 70% of capacity during this phase, are once again opened up and the great fire-breathing, bone-rattling tin can accelerates rapidly upwards again, on its way to space.

Well, the summer of 2017 felt like ‘max Q’ for our family. We had a second baby boy in late May (he’s brilliant!), relocated from DC to Florida in early July, sold a house and bought a house, prepared for our first hurricane in August (that was stressful!) and had a to-do list longer than our arm, in fact, all our arms combined.

Through this, I did what I could, when I could, to keep the ball rolling with my business. I launched my second course, Data Cleaning and Pivot Tables in Google Sheets, in June, although almost all of the work was completed prior to my son’s arrival in May.

Since October, the throttle has been fully open again on the business and things are moving along nicely. I launched my third course, Advanced Formulas 30 Day Challenge, in mid December, and had over 1k students sign up in the first week.

2017 highlights

Continue reading 2017 in review and a look forward to 2018

Google Sheets, Apps Script and Data Studio Resources: The Ultimate List for 2017

Want tons of great Google Sheets, Apps Script and Data Studio resources in one place?

Then you’ll love this list.

These are my go-to resources when I’m building spreadsheet applications for clients or developing content for this blog. I have hundreds of bookmarks on the subject but here I’ve whittled it down to just the very best.

Feel free to suggest any other resources in the comments below!

Google Sheet Resources

Google Help Resources

Starting this list off is the official Google Sheets documentation. This guide covers everything about sheets, including all 346 formulas.

Google spreadsheets function list – all 346 of them! A good place to start when you want to find out the syntax details or how formula X works.

The Google Docs blog – the official source for product announcements, updates and tips from Google.

Forums and G+ communities

Aka, good places to ask questions!

Google Sheets Help Forum. The place to go to get your Google Sheet questions answered. Read this getting started guide if you’re new to it. There are also forums for the other Google Docs.

Google Spreadsheets Tips & Tricks. Another great community for asking and answering questions on Google Sheets. It’s full of experts willing to give their time to answer questions.


Continue reading Google Sheets, Apps Script and Data Studio Resources: The Ultimate List for 2017

2016 in review and a look forward to 2017

Happy New Year to you all!

DC fireworks
Photo credit: Architect of the Capitol

If 2015 was a year of huge change, then 2016 was more incremental, building on the foundations of 2015. I still tried lots of different things – different gigs, different projects, different tools – but I’ve found creating apps and solving data problems on the Google platform is my sweet spot of skills, experience and enjoyment.

2016 highlights:

On this site

Investing so much time and effort into this site really started to pay off over the course of 2016.

Web traffic chart

Over 2,500 of you have subscribed to my email list and enjoyed a free copy of my ebook: Spice Up Your Sheet Life.

Midway through the year, I passed 100k pageviews, then 150k pageviews and am now close to 200k.

Several posts have garnered some really great commentary from readers, adding tons of value to the original post. This one in particular has 112 comments and counting!

Continue reading 2016 in review and a look forward to 2017