Creating CMAs
• Importing CSV files from the MLS into Excel
• Using Excel’s auto format feature
• Working with columns and rows
• Using toolbars to quickly modify formatting
• Using menus for more control over formatting
• Sorting by columns to find unwanted comps
• Deleting unwanted comps
• Creating formulas to calculate cost per sq. ft.
• Using functions to calculate median values
• Adding titles, borders, and “white space”
• Using color to draw attention
• Setting alignment and print area
• Printing and saving files