Inland Empire Crime &

  Intelligence Analysts Association

  • Home
  • VCAN - Formula, Functions and Macros, Oh My

VCAN - Formula, Functions and Macros, Oh My

  • Fri, April 16, 2021
  • 10:00 - 12:00
  • Online
This training is presented by VCAN and you can register here

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.

Copyright IECIAA 2021

Powered by Wild Apricot Membership Software