Formulas, Functions, and Macros, Oh My

Start:
End:

$10/non members, FREE for VCAN Members

Not a member? Join VCAN Today



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.

RSVP to this Webinar:

    I understand that the deadline for cancellations is Tuesday, April 13th, 2021. If I fail to email the VCAN board directly at info@virginiacrimeanalysisnetwork.org with my cancellation after this time, or fail to attend without notice, I will be responsible for a $15 cancellation fee. I understand that I will not be permitted to register for additional VCAN-sponsored training until this cancellation fee is paid.

    I understand that if I violate policy on 2 occasions during the same calendar year. I will not be permitted to register for additional VCAN-sponsored training during the same calendar year.

    There are NO EXCEPTIONS to this policy. INITIAL BELOW.

    Payment Details

    Total:

    $10.00 USD