2018 in review and a look forward to 2019

Best wishes to you all for 2019!

My sons
My sons are 1 and 3 years old and growing up quickly!

This is one of my favorite posts of the year to write, because it’s my chance to reflect and look back at the whole year, and celebrate the wins and learn from my mistakes. It’s a chance to assess growth (both for the business and personally) and think about where I want to go in 2019.

2018 was extremely rewarding, but also extremely challenging at times.

Life and business are both moving forwards again and I go into 2019 full of optimism.

Starting with the highlights:

2018 highlights

Online courses

Continue reading 2018 in review and a look forward to 2019

Introducing Apps Script Blastoff: a free Google Apps Script course

I’m super excited to share this latest free course with you: Apps Script Blastoff!

Go from zero coding knowledge to just enough code to automate your Google Sheets!

Apps Script Blastoff course launch

πŸš€ 100% online video training course

πŸ“š 5 modules | 25 videos

πŸ’» Includes all the templates and source code

πŸ”₯ It’s free!

This course will set you up to:

  • Understand what Google Apps Script is and why you should use it
  • Know the building blocks of Apps Script
  • Have the confidence to write your own programs
  • Build some cool automated tools you can use right away
  • Know your way around the Apps Script developer environment
  • …and much, much more!

Each lesson is taught through bite-sized, action-oriented 5 – 15 minute-long videos, covering practical techniques you can apply to your own business.

This course will teach you the basic foundational techniques in Apps Script, even if you’re brand new to coding.

Best of all, it’s free! That’s right, this one’s on the house. πŸ˜€

Start today, and learn just enough code to automate your Google Sheets.

Check out Apps Script Blastoff! >>

The complete guide to simple automation in Google Sheets, using Macros

Macros are small programs you create inside of Google Sheets without needing to write any code. They allow you to automate repetitive tasks. They work by recording your actions as you do something and saving these actions as a “recipe” that you can re-use again with a single click.

Sound good?

They sure are! Read on to learn how to use them, see some examples, discover their limitations and also see how they’re a great way into the wonderful world of Apps Script coding πŸ˜€

This video is the third lesson from my free Apps Script Blastoff! course: an online course teaching Google Apps Script from scratch.


  1. What are macros?
  2. Why should you use macros?
  3. How to create your first macro
  4. Other options
  5. A peek under the hood
  6. More macro examples!
  7. Resources

Continue reading The complete guide to simple automation in Google Sheets, using Macros

Six reasons to start learning SQL

This is a guest post from Tomi Mester of Data36.

Back in 2011, during my college years, I got my first-ever job (an internship) at a cool IT startup. I got to do all kinds of interesting tasks but mostly it was data analysis.

The process was simple:

  • I received data from the developers in .csv format
  • I imported it into Excel
  • I crunched the data there
  • I sent the beautiful charts to my manager

We learned a lot about user behaviour, trends, and how we reached (or didn’t reach) our goals. I loved it – except for one thing: I always had to wait days (sometimes weeks) for the developers to export the data for me from the company’s SQL database.

That was my #1 reason to learn SQL!

I did so. And ever since then I’ve been a huge fan of this simple and elegant data language.


Because knowing SQL allowed me to do better, more detailed data analyses – more easily and faster. And I strongly believe that it can be extremely useful for everyone else who works in data analytics and who uses different spreadsheet tools in their day-to-day job.

In this article, I’ll give you 6 reasons why you should learn SQL too!
Continue reading Six reasons to start learning SQL

How we manage our family finances with Google Sheets

“If you can’t measure it, you can’t improve it.” – Peter Drucker

Disclosure: Some of the links in this post are affiliate links, meaning I’ll get a small commission (at no extra cost to you) if you signup.

Trying to have conversations about saving, spending and planning for retirement is infinitely more difficult and more stressful without accurate numbers in front of you.

You fall back on anecdotes and feelings because you have nothing else to go on.

Conversations start with phrases like: “it feels like we haven’t spent much on eating out this month” and they don’t get any better from there.

My wife and I have two beautiful boys, aged 1 and 3, and we’re both ambitious with our careers and work full-time. Life is crazy, crazy busy for us right now.

We’ve found it challenging to find time to manage our family finances, so we’ve been in this position of flying blind without a financial tracking plan in place. We’ve had those frustrating conversations, knowing that if we had better insights into our financial habits we could do a much better job at financial planning.

I want to show you how we changed that.

How we created a system in Google Sheets for tracking our spending habits.

It now only takes us about 10 or 15 minutes each week, so we can focus on understanding our financial situation better, and maximize our saving.

Enter Tiller

Tiller is an amazing tool that connects our bank accounts and credit cards securely to Google Sheets (or Excel), and automatically updates them on a daily basis.

It means we can see all of our financial transactions in one place and do our own custom analysis in Google Sheets.

Tiller Google Sheets

It’s been transformative for our family’s sanity and helped us get on top of our spending and hit our saving goals.

Tiller has a suite of Google Sheet templates available too, covering spending, saving, budgeting and net worth tracking, so that you can visualize your financial data immediately.

Of course, you can also build your own solutions to answer whatever questions you have.

It costs $59/year, which is tremendous value since you’re getting a fully customizable, automated personal finance tool.

How to setup Tiller with Google Sheets

Tiller is a third-party tool so you have to create an account with them, which is done securely through your Google account credentials.
Continue reading How we manage our family finances with Google Sheets