BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Virginia Crime Analysis Network (VCAN)
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Virginia Crime Analysis Network (VCAN)
X-ORIGINAL-URL:https://virginiacrimeanalysisnetwork.org/event/formulas-functions-and-macros-oh-my/
X-WR-CALDESC:Formulas, Functions, and Macros, Oh My
BEGIN:VEVENT
DTSTART:
DTEND:
SUMMARY:Formulas, Functions, and Macros, Oh My
DESCRIPTION:**Formulas, Functions, and Macros, Oh My**

**Presenter:** Leonard Leedy, Retired LE

**Presentation Abstract: **This presentation will cover how to enter formulas. The formula will cover several LE specific formulae that are critical in the analysis of data. Did you know there are two types of time in Excel, Clock Time and Elapsed Time? You have to use the correct one to total Investigative Time.

My mantra is "If I use a formula more than three times or it's complex and takes me several minutes to figure out, Create A Macro." I'll show how to automate your formulae.Functions can be thought of as automated formula. There are over 500 Functions in Excel. We commonly use about 20 or so another 30-40 are good to know are there. and the rest we will hardly ever use.

**Registration closes at COB on Tuesday, April 13, 2021. Login details will be sent by COB on Wednesday, April14, 2021.**
LOCATION:
END:VEVENT
END:VCALENDAR