Numbers on the Mac……The Mac’s Spreadsheet Program
Numbers on the Mac is the equivalent of Excel……pretty much. I never anticipate doing great, detailed spreadsheets anymore therefore decided that whatever i learn about spreadsheets i will learn it on the Mac using Numbers. It is part of iLife Works.
First, A Note on Excel……. I read a few books on Excel however had a difficult time learning it; i did develop a bit of skill in putting information into various columns and add them up, perhaps include a few basic type of formulas and was able to print them out in tables which looked pretty good, but i was no expert and could not go and do what the average mid level excel worker is supposed to know how to do that works for a company…..however, i believe could catch it up quite quickly if shown by the right person.
I was fortunate in 2010 to meet a young man who was proficient in making Excel spreadsheets. This was during a time i had designed an important spreadsheet……and he took the many 30 or so hours in various meetings to teach me and make sure i did learn what i was doing “at that time”…….especially in formula creation, checking whether the formula worked prfoperly etcetera. He did a good job and i was a good learner. Having said that, if presented with having to do a similar project, i would definitely have to review the directions again and again…..to feel confident to go ahead and actually create another spreadsheet.
Distinction with the Numbers Program (at least for me!~)) -Designed and Created an 11 page Spreadsheet on Purchasing a Commercial Property. Designed for Investors such that once appropriate number data was input the spreadsheet could act as a presentation tool to the interested investor giving the investor an accurate and detailed snapshot with the numbers that are vital and important to him to make clear the decision whether he considered the deal a good deal for him to be involved in.
Also, the same spreadsheet could be emailed as a PDF to keep an investor aware and updated with the property the investor had invested in as to his status and profits as well as projected profits.
For me, I added to this spreadsheet “Comments” that included every detailed aspect on the process of purchasing a commercial property……equivalent to some 300 pages of information. I did it this way so it provided a checklist at each stage of the purchasing process to eliminate any or every mistake. I would really have to work at it again, probably for some weeks to become proficient with it to use it as a tool. The primary use of it, i understand it to be a collective place where i can go and review everything about How To Purchase Commercial Property.
Also Designed and Made a 5 page Spreadsheet on Purchasing a Single Dwelling Unit/House. This is also a good spreadsheet with pretty well most every detail involved in keeping track of amounts invested, ROI, rent amount, taxes, insurance and all other expenses etcetera. Would i use this spreadsheet…….yes at least for my own purposes as it is more inclusive than other spreadsheets i have seen available on the internet……..but, i like to give credit to other real estate people who have created very appropriate, very simple real estate assessment and profit calculation tools built in and as presentation tools for an investor…..i would use one or two of their tools available for purchase on the internet because they are so excellent!