Google sheet that contains list of all WCD lessons and links to all content:
In Lesson 030 I will be explaining how to navigate and utilize the Google Sheet I have built for White Collar Dad Lessons.
As I discussed in my introductory post, I will create an Excel worksheet and YouTube video for each lesson that I post on Substack.
Here is the link to White Collar Dad Lessons in Google Sheets which has a worksheet dedicated to every lesson.
Originally I was thinking about creating a separate Google Sheet for each lesson, but I have found it much easier to create one “master” file that contains all lessons. This way I only have to share one link and update one file. One downside to this is that it’s a large file with a lot of information. The purpose of this post is to help users navigate the file and quickly find the reference information they are looking for.
Link to Google Sheet
https://docs.google.com/spreadsheets/d/1aq0Hhce9uUjElgOpY3GVK5MBoVc1HebUmoBl6HiHe_Q/edit?usp=sharing
I have changed the permissions of the sheet such that anyone with the link is a “Viewer” and will be able to look at the sheet (but not edit). Additionally, you will be able to download the Google Sheet to your computer if you want to open and edit the workbook in the Excel app.
Download Google Sheet to Excel App
If you prefer working in the Excel application (like I do), then you can download the google sheet to your computer by doing the following:
File >> Download >> Microsoft Excel (.xlsx)
This is my recommendation because the links to the worksheets get broken in Google Sheets, but they are functional if you download the workbook to your computer and open in the excel app.
Google Sheet Overview
Whether you use Google Sheets or the Excel application to view the information, the content is the same.
See screenshot below for the “Index” worksheet which is the master worksheet that contains links to all lesson content.
Lesson Number
Link to lesson worksheet in Excel application (does not work in Google Sheets)
Hyperlink to lesson on Substack
Categorization of the lesson topics (1 = Yes, Applicable / 0 = Not Applicable)
Yes / No Flag for if the lesson is complete (1 = Yes / 0 = No)
See screen shot below for the worksheet navigation tool bar.
Google Sheet worksheet drop down (not available in Excel application)
Index worksheet (the master worksheet with links)
Lesson worksheets (worksheet name is the lesson number)
Lesson Worksheets
The lesson worksheets will contain all of the Excel calculations, tables, and charts that I have posted in the Substack lesson.
Quick excel tip, if you want to highlight the cells involved in a formula, click on the cell with the formula and then click “F2”. It will show you the other cells used in the formula.
Alternatively, you can click Formulas >> Trace Precedents to see all the cells used in the formula.
Google Sheet Navigation
As I mentioned, the links that take you directly to a worksheet do not work in Google Sheets (they do if you download Google Sheet and open in Excel app).
Google Sheets actually has a rather handy button on the bottom navigation tool bar that gives you a drop down menu for all worksheets. I recommend using this for navigating between the worksheets.
Excel App Navigation
The “master” worksheet is “Index”. This contains a list of all my lessons with links to the Substack URL as well as to the respective worksheet inside of excel.
To making navigating easy, I have placed a link back to the index on all worksheets. I typically place this link somewhere towards the top left of the worksheet….
…but sometimes I have moved it to a different location.
You an absolutely still use the scroll bar at the bottom of the excel application, but I find this to be slow and clunky.
Reference Material & Social Media
In Lesson 030 I cover how to navigate and utilize the Google Sheet I have built for all WCD lessons. This Google Sheet contains a worksheet for each WCD lesson. Each sheet has all of the Excel calculations, tables, graphs, and charts that I have posted in the respective WCD lesson. Additionally, the Google Sheet has a master “Index” worksheet that has links to all of the content associated with each lesson.
If you found this post helpful, please like, share, and follow me on my social media channels!