Split Text between Upper and Lower Case in Excel

https://youtu.be/POIV3wCyHLE

Separating text that should have been in two columns instead of one is easy to do if there is some kind of delimiter (i.e., comma or colon). But if it was two words like first name and last name that was combined; and the only way to make out the beginning vs. end is the case (Upper case vs. Lower case; like Bob Smith). There's actually a really easy way to do this and then there's the super nerdy formula combination way. I'll show both ways but show the formula way first.

Rent Split Calculator in Excel

Splitting the rent between roommates is not an easy task, especially if you all have got different preferences about what's important. In this video, we'll take a hard facts approach to apartment rent splitting by using square footage. One model will use the square footage of the whole unit but give specific consideration to the bedrooms and other model will pay attention only to the bedroom. There's not right approach, just the approach you all agree on. The beauty of this model is that it's done in Excel and when you look at different room sizes or the number of room mates sharing, you can adjust the numbers and the cost per person will recalculate.

Basic Stock Forecasting in Excel Warren Buffet Would Love

Investing in the stock market means trying to forecast or do some prediction on where the market will go. One way to do predictions is with regression, more specifically basic linear regression or simple linear regression. Applying simple linear regression to an individual stock may not work out, but for an index of stocks, that might work. This video will use the S&P500 index as an example of how we can use regression to forecast the index value in the future. As a bonus we can see what the Compounded Annual Growth Rate (CAGR) of the return is to get an idea of what an "annual" return could be based on almost a decade of holding the investment.