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.
DATES AND LOCATIONS:
May 23, 2017