Advanced Analytical Methods for Microsoft Office

Course Language: English
 

Schedule

Description
 

Microsoft Office Suite has remained the go to set of tools for most police agencies. Most in the analyst community are familiar with the tools in some form or fashion. This 12-week course offers an advanced study of Access, Excel, PowerPoint, Word, and general statistics. Learn to build your own clean Access databases, create charts, maps, and timelines in Excel, record videos in PowerPoint, and create bolder bulletins in Word. Statistics used daily by analysts will be simplified and enhanced with formulas in Excel. Use the tools you already have at your disposal before begging for more budget!

Impress your bosses and wow your coworkers with your Microsoft magic!

Format

This is an advanced course. Students must already have a working knowledge of Excel (PivotTables and basic formula knowledge are a must), PowerPoint, and Word. Some Access and statistical knowledge is a plus.

The instructor will be using Microsoft Office 365, but students are recommended to have Office 2016 or later, though some variations are to be expected. Students are welcome to join regardless of their Office version as long as they are able to make the minor adjustments that come with older versions.

Students should expect a time commitment of 3-5 hours per week to gain a passing grade. The course will be graded as a pass/fail. This is not a self-paced course; we will advance to each new topic week as a group. Students can login anytime to work as needed, there are no live sessions. Participation throughout the course is required for a passing grade. As a rule, bulk submissions of your work during the last week of class will not be accepted unless you have received prior authorization from the instructor. 

Invitations to the learning platform will be sent the weekend before class starts.

Return to Training