Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.
Please Note: I’m not taking on new clients at the moment. I’m focussing on creating new online courses. However, I’m happy to introduce you to an associate of mine who runs a Google Workspace consulting firm. Please complete this form as the first step. Data Analysis, Visualizations, Dashboard and Application Development using Google Sheets, Apps … Continue reading Collins Analytics LLC Consulting
This time last year I worked with The Write Life during their three-day sale of The Writer’s Bundle, a collection of digital products for writers. I built a dynamic dashboard using Google spreadsheets so the team could visually monitor progress throughout the sale. This year The Writer’s Bundle 2015 was bigger and better than ever, … Continue reading Building a dynamic dashboard for a 3-day digital flash sale
Continuing my recent infatuation with dashboards in Google spreadsheets, I’ve been playing around with the Google Analytics Add-on to build a custom web analytics dashboard in a Google spreadsheet. The idea originated from discussions with my wife about the tedium of preparing month-end website performance reports for her content management clients. This dashboard was a … Continue reading Creating a custom Google Analytics report in a Google spreadsheet
This article covers how to build a dynamic dashboard in Google Sheets, using formulas and data validation methods so that charts change dynamically based on user input. Check out my course: Build Dashboards with Google Sheets and Data Studio This post is based on work I did in 2014 with The Write Life team to … Continue reading Creating a dynamic dashboard in Google Spreadsheets to track sales for a digital product launch