Technology Topics

 

When preparing information for clients, REALTORS® can benefit from utilizing Microsoft Excel to calculate a number of estimates for Buyers and Sellers alike can use to make more informed decisions. This two-hour course will cover the basic features of Excel and how to use them to assist the creation of competitive market analysis presentations, assistance with good faith estimate reports, and calculation of fees/budgets for a transaction. This course will review how to sort and filter data, format a worksheet, develop a workbook, customize a layout, import and export data, saving work, using formulas, and creating charts/graphs.

 

Outline:

·        Introduction, review of course – 10 minutes

·        Creating a new worksheet, description of toolbars, description of rows/columns/cells – 15 minutes

·        Entering data, Formatting fonts, colors, cells – 15 minutes

·        Sort, Filter, Subtotal, using formulas – 30 minutes

·        Break - 5 minutes

·        Charts and Graphs – 20 minutes

·        Linking sheets – 10 minutes

·        Printing and saving work – 15 minutes

 

 

 

Learn to use Microsoft Word to create and save word processing documents. Learn to enter and edit text, control line spacing, format a document, and use non-printing characters. Discover the ease of making changes by moving, copying, and pasting text. Understand the difference between Save and Save As and how to set up documents for printing. Learn how to apply paragraph formatting in your documents, including properly setting paragraph indents and tabs and centering text. Other topics include changing the type style, inserting the date, and using the Find and Replace commands to make global changes.

 

Formatting, tables, and mail merge will also be covered. Discover how to create tables to format data and text on your page. Table topics include inserting and deleting rows and columns, editing tables, creating borders, and other formatting techniques. Understand how to insert section breaks in a document in order to format specific areas or customize page numbering. Learn to create personalized form letters and perform queries using Mail Merge. If time allows, other topics include headers and footers; text flow options, such as columns; and the Paste Special feature.

 

 

Outline:

·        Introduction, review of course – 5 minutes

·        Creating a new document, review of document types, description of toolbars – 10 minutes

·        Entering text, formatting fonts, colors, indentation, copy/paste – 10 minutes

·        Bullets, columns, find/replace, document breaks – 30 minutes

·        Break - 10 minutes

·        Tables – 15 minutes

·        Linking to other file types, inserting pictures/layout – 15 minutes

·        Mail Merge – 15 minutes

·        Printing and saving work – 10 minutes