Income Digs

Super-Power your Data with Google Sheets (and STOP using MS Excel!)


Listen Later

In this episode, Nick Baldo explores the functionality of Google Sheets for real estate investors. He guides listeners on how to extract data from QuickBooks Online, create dynamic dashboards using pivot tables and slicers, and incorporate charts for visual data representation. Discussing the benefits of these dashboards and how to manage projects effectively, Nick wraps up by highlighting some valuable resources at incomedigs.com.

Enroll to Real Estate Accounting Bootcamp: http://bit.ly/reabcourse (Enter Code YOUTUBE50 for $50 off!)

End to End Podio Training: https://www.incomedigs.com/pcc
Check out our Podio Templates: https://bit.ly/3pE4DBt
Download our guide: https://www.incomedigs.com/qbosetupguide

Google Sheets continues to impress me! When I first discovered Google Sheets ~10 years ago, I thought "Really convenient...but it can't do much". Ever since then, Google has continuously improved its product to create a powerful analytics engine.

In this video, I demonstrate the immense power of "Slicer" to visualize and filter your data set!

(0:00) Introduction to Google Sheets and its uses
(1:06) Data dump from QuickBooks online
(1:51) Building a dynamic dashboard with pivot table and slicer
(5:44) Incorporating charts into the dashboard
(6:47) Adding and managing projects with slicer
(8:08) Advantages of dynamic dashboards
(8:41) Sponsor: Google Sheets endorsement
(8:59) Closing remarks and promotion of incomedigs.com resources
...more
View all episodesView all episodes
Download on the App Store

Income DigsBy Nick Baldo