Advanced Analytical Methods Using Microsoft Office – October 2022

October 02nd - December 24th, 2022

Course Language: English


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!


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. 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.


  • Access (3 weeks)
    • Building Your Access Database
      • Includes Table Creation, Relational Data, Joining Tables, and Creating Forms
    • Fixing Issues with the Database, Adding Items, and Querying Your Data
      • Includes Fixing Corrupted Data, Querying, and Aggregating
    • Database Communication and Linking Information
      • Includes Report Writing, Exporting/Importing/Linking Data, and Automating Reports
  • Excel (3 weeks)
    • Excel Analysis
      • Includes Importing Access Data, Power Query, Pivot Tables (Charts), and Slicers
    • Formulas in Excel
      • Includes If Statements, Timelines, and Formulas (not statistics – see below)
    • Simplifying Your Analysis – VLOOKUP, Conditional Formatting, and Macros
  • PowerPoint (1 week)
    • Advanced PowerPoint
      • Includes Animation, Master Slide List, Embedding/Linking Data, and Recording Video
  • Word (1 week)
    • Word
      • Better Bulletins and Reports with Columns, Text Boxes, Tables, and Embedding/Linking Data
  • Data/Stats (1 week)
      • Includes discussion of types of data, data collection, statistics by hand, and statistics in Excel
  • Microsoft Extras (1 week)
      • Includes Outlook, Excel Power Maps, and Creating Bulletins in Publisher
  • Final Project (2 weeks)


Course Information:
What: Advanced Analytical Methods Using Microsoft Office – October 2022
When: October 02nd - December 24th, 2022
How Much?
  • IACA Members: $395
  • Non-Members: $445
Course Type: Online
Course Times: No specific times; students may complete work at any point during the week
Instructor: Jennifer Zawitz
For more info contact:
Angela Backer-Hines
Phone: (651) 675-5833

Refer a Colleague

Let your colleagues know about the benefits of the IACA!