14 Hours
Microsoft Excel has built-in database management capabilities, allowing users to treat a worksheet or portions of a worksheet as a database. Using Microsoft Excel as a database allows users to enter, edit, locate, sort, filter, and analyze information. Officers will learn importing and exporting data skills; using advanced filters to create more advanced conditions to filter a data list; creating pivot tables to vary one or two values in a formula and display all possible results in a table or chart format; using auditing tools to find and correct errors; performing forecasts and projections using Goal Seek and Scenarios; and using the Solver to solve problems by working backwards. Major topics to be covered include: Working with Databases; Managing Data; Importing and Exporting Data; Using Dynamic Data; Working with the Data Form; Using Advanced AutoFilter; Creating Pivot Tables; Conditional Formatting; Grouping and Outlining Data; Forecasting and Problem Solving; and Sharing, Locking and Protecting Workbooks. The prerequisite for this course is Using Microsoft Excel.
March 2–3, 2011
Criminal Justice Institute