General Real Estate Investing
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback
Updated about 4 years ago, 09/17/2020
Microsoft Excel: How Can I Help? Automation, Dashboards, etc.
I'm willing to bet that many of you, myself included, leverage MS Excel for a wide range of tasks such as managing rental properties, deal analysis, workflow, etc. I'm also willing to bet that most of you probably hate it because it's manual, repetitive, and time-consuming.
My background is in technology - specifically Business Intelligence and Data Engineering but throughout my personal and professional work experience, I've created and automated some pretty powerful and robust workbooks and dashboards (Metrics/KPI reporting) using Excel. Microsoft Excel has a pretty neat feature on the backend that very few people leverage, VBA. Visual Basic for Applications (VBA) is a programming language within Excel that you allows you to automate your workbooks to remove the repetitive human input that may be involved in a lot of what you're doing.
With that said, if you're struggling with anything MS Excel related, let me know! I'm happy to provide some input and hopefully automate some of the manual and repetitive work that you're currently doing.
Thanks!