Excel Modeling Course - SDSU Fall 2016

The Excel Modeling Course takes place on Saturdays, October 1 & 8 from 8:30am to 4pm at SDSU's Extended Studies Center. Join our SDSU faculty Mark Goldman, CCIM, Dana Kuhn, and George Easton, Ph.D. who will explore basic excel modeling training.

Major topics explored in this training are listed below:

• An Introduction to Spreadsheets
• Excel Data Types
• Relative and Absolute Cell Addressing
• Excel Functions and Formulas
• Statistical Functions
• Financial Functions
• Date & Time Functions
• Data Validation, Conditional Formatting, Comments
• Using Multiple Worksheets in ProForma
• Data Analysis
• “Whatif” Analysis and Goal Seek
• Creating Charts
• Defined Names
• Importing/Exporting Data from/to External Sources
• Macros

Excel Modeling Course:
Things to Know and Be Able to Do Before Attending the Course

The limited time available for SDSU’s Excel Modeling Course requires that students arrive with some fundamental spreadsheet knowledge, or prerequisites.

Prior to attending the first session, students should have a working understanding of the following terms:

• worksheet, workbook and file
• formulas and functions
• cell addressing, i.e., columns, rows, and cells
• absolute and relative cell reference

Prior to attending the first session, students should know how to:

• navigate using the Ribbon menu and the Shortcut menu
• use the mouse to execute these tasks
  • copy and paste
  • move
  • fill with fill handle
  • point to cells to add addresses to a formula
• insert, delete, hide, and resize rows and columns
• use keyboard shortcuts to cut, copy and paste
  • Ctrl +, X, C, V (Mac users: Command + X, C, V)
  • use print preview

Review these terms and skills now. If you know them all, you are ready! If not, research them and practice!

If you show up without this basic background knowledge, you will not get the full value of the class, and that would make us sad. But by independently attaining a minimum skill level, you can ensure that the class progresses with the greatest possible efficiency and efficacy for all.

Thank you, and we look forward to seeing you!

George Easton, PhD, Professor, Management Information Systems

Mark Goldman, CCIM, Real Estate Lecturer

Dana Kuhn, Real Estate Lecturer