With the advancement in technology, criminals are becoming more organized and more efficient. This is why law enforcement professionals must also step up their practices to control crime effectively.
Law enforcement can find an incredible ally in data. How? Data can provide many enhanced crime reduction opportunities, like identifying crime patterns, implementing intelligence-led policing, and more. So, it is a wise decision to incorporate data in the fight against crime.
The next question that arises here is how one can use data to proactively enforce the law. The answer is simple - learn Excel and Google sheets. They have the potential to unleash the underlying opportunities provided by data analysis so you can proactively address the crime problem in your jurisdiction. So, let’s discuss the multiple uses of Google and Excel spreadsheets that can benefit law enforcement.
Different Uses Of Excel And Google Sheets In Law Enforcement
1. Data Analysis
2. Budgeting And Financial Management
3. Case Management
4. Scheduling And Resource Management
6. Evidence Tracking
8. Statistical Analysis
6 Basic Excel Formulas To Make Work Easier And Efficient
Formulas are the key element that transforms Excel into a productivity tool. These formulas are mathematical commands that simplify and automate mathematical and logical operations in the Excel sheet. It helps in solving problems and analyzing data in detail. Let's discuss the six basic Excel formulas to make your work easier, more productive, and hassle-free.
The SUM function in Excel adds values and provides the total sum in the cell. This formula accepts numerical values, cell references, cell ranges, and a mix of all three options.
Formula Syntax: SUM(number1, [number2], [number3]...)
It is important to note here that the arguments are separated with commas. You may use a space as well, but it is not compulsory.
Average is another basic arithmetic calculation made easier with Excel. It makes your work easier because you do not have to use a calculator to find the answer. Moreover, you may make a mistake when calculating a huge set of data manually. So, Excel is a much better alternative.
Formula Syntax: AVERAGE(number1, [number2], ….)
Just like SUM, you can also enter a cell range as arguments in this formula.
The IF function is used in Excel for logical functions to test whether a statement is true or false. In addition, the IF function can be designed to perform one action is the statement is true and another separate action if it is false. The statement under scrutiny can be of a lot of types, like seeing if a value is equal, greater, or less than another value.
Formula Syntax: IF(logical-test, [value-if-true], [value-if-false])
- Logical-test is the statement you want to test.
- Value-if-true is the value or expression you want Excel to return if the cell has a true statement.
- Value-if-false is the value or expression you want Excel to return if the cell has a false statement.
- In the IF function, you can omit the value_if_true if the value_if_false is stated, and vice versa, but it is not possible to omit both.
The SUMIFS Excel function combines the SUM mathematical operation and an IF logical test. It is designed to add only the cells that meet multiple user-defined conditions (criteria). The fascinating part of this formula is that you can apply up to 127 criteria at a single time. And the formula will identify the cells that meet all the defined.
Formula Syntax: SUMIFS(sum-range, criteria-range1, criteria1, [criteria-range2], [criteria2],...)
- Sum-range is the range of cells you want to sum.
- Criteria-range1 is the range of cells you want to be evaluated.
- Criteria1 is the first condition, and the cells in criteria-range1 must satisfy it.
- Criteria-range2 is the second range of cells you want to be evaluated.
- Criteria2 is the second criterion, and the cells in criteria_range2 must satisfy it.
- Moreover, all the arguments after criteria 1 are optional, and you may not enter them if you want only one condition to be applied.
The COUNTIFS Excel function is designed to count only cells that satisfy all the stated conditions (criteria). COUNTIFS allows multiple conditions, up to 127 needs, if you want to be specific, to be evaluated simultaneously. This feature makes it superior to the COUNTIF function as it evaluates only one condition.
Formula Syntax: COUNTIFS(criteria-range1, criteria1, [criteria-range2, criteria2]…)
- Criteria_range1 defines the first range you want to evaluate.
- Criteria1 defines the first criterion, and the cells in criteria_range1 must satisfy it.
- Criteria_range2 is the second range you want to consider.
- Criteria2 defines the second criterion, and the cells in criteria_range2 must fulfill it.
- After bar 1, all the pairs are optional because the formula can operate with only one applicable condition.
The VLOOKUP function of Excel is a game changer as it is the perfect tool to find something you are looking for in a table or an array. This function is the best tool for many search-related situations, like finding a suspect's name based on their ID.
Formula Syntax: VLOOKUP(lookup-value, table-array, col-index-num, [range-lookup])
- Lookup_value is what you want to find in the file.
- Table_array is the place where you want to look for it.
- Col_index_num is the column number in the range that contains the value you wish the cell to return.
- In Range_lookup, you can type TRUE for an approximate match and FALSE for an exact match.
BlueForce Learning Academy | Learn How To Use Data Sheets To Fight Crime Better
BlueForce Learning Academy is an online learning platform for law enforcement. We provide authentic online data-based law enforcement certifications and training. We aim to provide the best data skills to law enforcement professionals so they can fight crime proactively and make this world a better place for everyone to live in.
We provide high-quality learning, hands-on experience, and ongoing access to training materials. In this way, you can learn and start using data skills quickly to reduce crime.