Create a Probability Impact Table & Matrix

https://youtu.be/cbiuV-UWvPc

The video covers how to create a probability impact table or Risk Assessment table. If you're doing project management or risk management, you'd be creating this table or matrix chart for your program or projects. You'd need to list out the different risk criteria and then figure out the likelihood of the risk happening (the probability part) and then the impact it would have (high, medium or low). This combination of probability and impact then helps determine the risk (again high, medium or low) that specific risk has to the project. There's bonuses to this; in addition to how to create the table and risk matrix I show how to create a drop down list, use conditional formatting for the color coding and show how to count up the different combinations of probability-impact in the matrix.

Format Excel Sheet to Print a More Readable Table

Printing out excel ranges should be a simple process. It's just text or values in little boxes, but if there's little or no formatting your audience might find it hard to read. Unlike text in a book there may not be enough space to help make it easier to read. With some simple steps you can help make a table easier for your audience to read when you actually give them a hard copy printout to read. I'll give you two example of how this can be done.

Interest Only Loan Amortization Schedule in Excel

https://youtu.be/Gbv-urHtW5o

Interest only loans may have been one of the contributing factors to the mortgage crisis in the late 2000s, but that was because lenders were not doing their job in vetted out people that were applying for the loans. As a tool to help people afford their dream house an interest only loan is a reasonable option to use. The key is to have the right expectations and that comes with knowing what you are getting into. That's why building out the year by year or amortization schedule will help you model your payments.

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.

Are You Presenting Excel Data Wrong? See Why...

If you're looking for a way to make your data more meaningful, then you need to understand how to use charts in Excel. Whether you're trying to show your data in a more visually appealing way, or simply trying to spot trends that are hidden in numbers, charts can help. For mid size or large tables, data visuals should be a given, but even when you have a small table it's often a good idea to chart the data to see patterns. Charting data is not only an effective way to visualize the data but it can also help you spot patterns and trends that you may not have otherwise noticed. You'll find the saying that a picture says a thousand words will ring true once you finished viewing this video.