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.
• THIS CLASS IS FREE - NO CHARGE
REGISTRATION INFORMATION: Registrants must fax a signed and dated verification letter on agency letterhead within five days of submission of the registration request form to 501-570-1465 which includes the following statement: This letter will verify that I, (name of registrant), am an employee of (agency name) and hold the position of (sworn/non-sworn) (position title), located at (address) and have registered for (name of class) on (date).
DATES AND LOCATIONS:
May 23, 2017