Sign up to save your podcasts
Or
Share Super-Power your Data with Google Sheets (and STOP using MS Excel!)
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
Super-Power your Data with Google Sheets (and STOP using MS Excel!)
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
View all episodes
By Nick BaldoIn 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