How to use IMPORTRANGE, the function that allows you to import data from a separate Google Sheet.

Prevent dirty data with view filters for ip address exclusion, path preference and hostname specification

Yes, there is a Google Sheets plugin that will allow you to run Google Analytics reports in a Google Sheet via the API call. In the supporting article I will show you how to use this tool.

Bulk update cell ranges across multiple worksheet tabs in Microsoft Excel

A video I shot and edited over the weekend of 4/3/20 - 4/5/20 capturing how quiet the streets are in downtown Manhattan during the COVID-19 quarantine. Enjoy!...

A simple guide to the commonly offered form of compensation by businesses, stock options. Learn about the various types, rules and tax implications.

All pictures were taken by me over the course of 2019 to January 2020. I hope you enjoy them. If you download or use, please provide credit 🙏...

I lack a formal education in programming. Outside of taking an introductory development course in college, I learned how to program by reading various books and developing side projects. When I began my journey there wasn't an abundance of interactive online courses, but now this material is the preferred method of learning and has accelerated the education of novice developers faster than ever. While this development is incredible to see, the downside to modern courses are that many create fall...

New Year's resolutions are well-intended, but rarely accomplished. Every year we go through the process of picking a goal that we want to accomplish and tell ourselves that starting January 1st, we will become a new person. I wish life worked like that, but studies tell us that 80% of resolutions fail, and most by the middle of February. So this year, try something different and choose a theme, rather than a goal. Goals require a strict start date, end date, and a specific outcome. It requires...

I was a “B” student in school. I listened in class and put in enough effort to get the grades I needed, but I never put in the work outside of class to master the material and rise to the perfection of an “A” student. For a long time I felt the resentment to put in the effort was the result of the subject matter, but I recently experienced these feelings again and convinced me that there was a different reason all along. After closing out Synotate and feeling a bit burnt out from working on te...