Data

Index Match

Index-Match is a powerful spreadsheet lookup formula that is dynamic in nature and can handle searches regardless of a ranges directional data structure
Data

Linking Data Between Google Sheets

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

What Are Good Foundational Google Analytics View Filters?

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

Sync Google Analytics Data To A Google Sheet

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 Updating Cell Ranges On Various Worksheet Tabs At Once

Bulk update cell ranges across multiple worksheet tabs in Microsoft Excel
Film

A Quiet Weekend in Downtown New York City (During Quarantine)

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!...
Business

Guide to Stock Options

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

Pictures of New York (circa 2019 - January 2020)

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 🙏...
Technology

The Online Web Development Course Fallacy

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...
Thoughts

Pick a Theme, Rather than a Goal for the New Year

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...