The Power of Excel for Agents - Level 1 (Microsoft Excel 2007) 

Course Description:  

Excel 2007 has a brand new look from 2003.  This course will introduce you to the new version and teach you everything from basic to intermediate.  Students will learn how and why you use a spreadsheet, how to create and modify worksheets, and how to work with advanced formatting techniques in this powerful application.  Ready made templates will be available on CD along with additional tutorials, reference material and exercise files.  

A Partial List of Templates:

Offer Comparison Worksheet, Moving Worksheet, Rent vs Buy Spreadsheet, How Much Home Can You Afford Worksheet, Closing Cost Calculator,  Extra Payment Calculator, Personal Budget Spreadsheet, Mortgage Qualification Worksheet, and more

Module A: In the first part of this course students will learn the basic functions of Microsoft 2007 Excel.  They will learn how to format and edit cells and how to create a worksheet with built-in functions that will help them enter data and set up computations.  Students will also learn how to enter formulas into the cells of a worksheet and how to identify different data types used in the application.

Module B: In the second part of this course students will learn how to manipulate various templates (real estate-related) so that they can better manage their business life.

Prior to the class, registered students will be given exercise files and templates that will be used in the class.

Partial Course Outline:

Part I - Getting Started

• Spreadsheet Uses
• Toolbars and Menus
• Moving Around
• Password Protection
• Excel for Real Estate Pros

Part II - Creating Workbooks

• Opening New Workbooks
• Types of Data
• Rows, Columns, and Cells
• Paste Special
• Commenting and Saving

Part III - Modifying Worksheets

• Setting Column Width
• Setting Row Height
• Text Alignment
• Worksheet Navigation
• Naming a Worksheet

Part IV - Formatting Worksheets

• Moving or Copying a Worksheet
• Add Border and Color
• Hide and Unhide

 Part V - Manipulating RE Templates

• Spreadsheets You Can Use Immediately
  • Offer Comparison Worksheet
  • My Business Budget
  • Payment Options for Your Listing

Wrap Up

• Q&A
• Resources - free Real Estate Worksheets

 Course fee ($49) includes Step-by-Step Instruction Guide, Exercise Files and Additional Tutorials

Please note you may take PowerPoint and Excel on the same day for only $69.