BEGIN:VCALENDAR
PRODID:NingEventWidget-v1
VERSION:2.0
METHOD:PUBLISH
BEGIN:VTIMEZONE
TZID:America/New_York
X-LIC-LOCATION:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:19700308T020000
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:19701101T020000
RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:1987892:Event:945876
DTSTAMP:20100909T084917Z
SUMMARY:REFM Excel Bootcamp Interactive Webinar (Virtual Attendance)
DESCRIPTION:<b><u><a href=\"http://realestatefinancialmodeling.com/ind
 ex.php?main_page=product_info&amp;cPath=2&amp;products_id=45\" target=
 \"_blank\">In this 3-hour, interactive, online-only session</a></u></b
 > from Real Estate Financial Modeling, you will learn the basics of op
 erating in Excel as well as advanced techniques. You will follow along
  in Excel in real-time and perform exercises to ensure you are graspin
 g the lesson and are mastering the technical skills being taught. You 
 will be able to ask your questions in real-time to have them answered 
 by the Instructor on a rolling basis.\n\n<b>Who Should Attend\n</b>\nP
 rofessionals and students who want to grasp and master basic and advan
 ced Excel operation and techniques.\n\n<b>Attendees Include</b>\n\nPro
 perty owners and developers, real estate company employees, property m
 anagers, architects, landscape architects, land use and transaction at
 torneys, construction executives and project managers, consultants, pl
 anning and zoning agency officials, government and economic developmen
 t officials, non-profit organization employees, engineers, residential
  realtors and marketers, university faculty and undergraduate and grad
 uate students.\n\n<b>Topics Covered Include *</b>\n\nArithmetic and Ro
 unding\nStatistics\nRelative vs. Absolute Cell References\nInserting a
 nd Deleting Rows and Columns\nDates and Timelines\nConditional Stateme
 nts\nFunction Wizard\nCreating Summary Tables\nFormatting Numbers\nCon
 ditional Cell Formatting\nData Table Lookup Functions\nCustom Formatti
 ng\nFormat Painting\nPaste Special\nTranspose\nAvoiding Error Messages
 \nFinancial Functions for Compounding and Discounting\nInternal Rate o
 f Return (IRR)\nMortgage Payment Calculation\nFormula Auditing\nData T
 ables for Sensitivity Analysis\nCircular References\nKeyboard Shortcut
 s\nBest Practices\n\n* All Topics Include Exercises\n\n<b>Excel Formul
 as Taught Include</b>\n\nSUM\nROUND, ROUNDUP, ROUNDDOWN\nMAX, MIN, AVE
 RAGE, MEDIAN\nCell Anchoring using Dollar Signs\nEOMONTH, EDATE, DATEV
 ALUE\nIF, AND, OR, and combinations thereof\nSUMIF, SUMIFS\nCOUNTIF, C
 OUNTIFS\nVLOOKUP, HLOOKUP\nIFERROR\nRATE\nPV, FV\nNPV and XNPV\nIRR an
 d XIRR\nPMT, PPMT, IPMT\n\n<b>Instructor: Kirsch</b>\n\nFor more infor
 mation visit http://www.finance30.com/events/refm-excel-bootcamp
DTSTART;TZID=America/New_York:20100220T133000
DTEND;TZID=America/New_York:20100220T163000
CATEGORIES:training, education, continuing, professional, development
LOCATION:*** Event Time is Eastern Time ***
WEBSITE:http://realestatefinancialmodeling.com/index.php?main_page=pro
 duct_info&cPath=2&products_id=45
URL:http://realestatefinancialmodeling.com/index.php?main_page=product
 _info&cPath=2&products_id=45
CONTACT:703-577-4110
ORGANIZER:Bruce Kirsch
ATTACH;FMTTYPE="image/jpeg":http://api.ning.com/files/uaMORLeEEUwt2166
 ZNOasTriCNFHDpvy2Ha6-uKcmyLq6pVVjZUBbM6vvqjOLNfwSdv1YwdZHR3Jmycx-dJ1Wd
 MhBwPJ9jHL/REFM.jpg
ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=ACCEPTED;RSVP=TRUE;CN=BruceK:ht
 tp://www.finance30.com/profile/BruceK
END:VEVENT
END:VCALENDAR