Advanced Analytical Methods for Microsoft Office

This 12-week online course offers an advanced study of Access, Excel, PowerPoint, Word, and general statistics for crime analysts who want to get more out of the Microsoft Office tools they already use.

Students will learn to build clean Access databases, create charts, maps, and timelines in Excel, record videos in PowerPoint, create stronger bulletins in Word, and simplify statistics commonly used in analysis.

This class is designed to help analysts use the tools they already have more effectively rather than relying on additional software purchases.

Instructor: Jennifer Zawitz

At a Glance

Upcoming Sessions

Select the session that works best for your schedule. Once a session has passed or is already in progress, registration is disabled.

Note: availability labels are updated manually as seats fill. For the most accurate information, refer to the registration form. If a class does not appear on the form, it should be treated as sold out.

Class Format

This is an intermediate course. Students should already have a working knowledge of Excel, including PivotTables and basic formulas, along with familiarity with PowerPoint and Word.

Some Access and statistical knowledge is a plus. The course is designed for analysts who want to build stronger technical skills across Microsoft Office and apply those tools more effectively in their day-to-day analytical work.

Students should expect a time commitment of 3-5 hours per week to gain a passing grade. The course is graded pass/fail and follows a weekly-structured online format, meaning the class advances through each topic together week by week.

Students can log in whenever it fits their schedule, and there are no live sessions. Participation throughout the course is required for a passing grade. As a rule, bulk submissions during the last week of class are not accepted unless prior authorization has been granted by the instructor.

Invitations to the learning platform are sent the week before class begins.

Course Outline

This course is organized into 12 weeks of advanced Microsoft Office instruction focused on database design, Excel analysis, presentation tools, reporting, statistics, and a final project.

Ready to Enroll?

Choose an upcoming session and complete your registration. If a session fills, students may contact [email protected] to ask about availability, the waitlist, or future offerings.