Like others have said, understand the concepts, then analyze the properties with today's prices and numbers. 

Let's assume this new investor understands how to analyze a property to include maintenance, capex and vacancy expenses. 

Hello, just wondering if anybody would be willing to share their preferred websites to analyze markets for things such as yearly appreciation rates, rent appreciation, days on market, etc.

A real estate agent with knowledge of investments, analyzing deals, knowing construction, and having crucial contacts will drastically improve your odds of success.

Investor relations and Asset management similar - all starts with data - we can take investor relations data and input it into a model to analyze some of the data we have that can point to KPI's like average time after a booked call to invest etc.For AM, it can take average foreclosure time to foreclose in X state with Y attorney, what the cost is etc. 

BiggerPockets also has a calculator to analyze deals, and I highly recommend you start this as soon as possible, even if you are not ready to buy.

I've been "analyzing" some properties on Zillow for practice and to see if this would even be feasible for me to accomplish, I haven't found any properties under 4 beds that would cash flow, however there are properties that have more rooms within my pre-approval price range that look a lot better on paper.

Quote from @Nithin Thampi: It's important to understand how to analyze a property to determine what will provide a good return on your investment.

I'm a new investor in Seattle and have been analyzing flips, short-term, and long-term rentals using Dealcheck and some proformas that local agents and investors have sent me.

As far as more technical financial analysis you mentioned above, I have found it is easiest to track these items in excel - I just update the workbook each time I analyze.