$35 – $75

Excel Modeling Course - SDSU Fall 2017

Event Information

Share this event

Date and Time

Location

Location

San Diego State University

5500 Campanile Drive

Extended Studies Center - Room 207

San Diego, CA 92182

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Friends Who Are Going
Event description

Description

Please note registering for one event will register you for all 3 sessions.

The Excel Modeling Course takes place on Saturdays, October 7 & 14 and Saturday, November 4th 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

Share with friends

Date and Time

Location

San Diego State University

5500 Campanile Drive

Extended Studies Center - Room 207

San Diego, CA 92182

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved