MENU mobile menu

Advanced Microsoft Excel: Database Features

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; how to use advanced filters to create more advanced conditions to filter a data list; how to create pivot tables to vary one or two values in a formula and display all possible results in a table or chart format; how to use auditing tools to find and correct errors; how to perform forecasts and projections using Goal Seek and Scenarios; and how to use 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.

• This class is 7 hours.
• Class hours are 8:30 a.m. to 4:30 p.m.
• It is recommended that students have a working knowledge of Microsoft Windows, Microsoft Excel, and possess intermediate to advanced computer navigation skills.
• Enrollment will be restricted to a maximum of 20 participants.


May 23, 2017
Criminal Justice Institute

     Click to Register