For ages 18 and up.

This course provides understanding beyond the basics using strong tools easily. Learn how to turn your spreadsheet into a database by sorting information quickly to manage large amounts of data. Understand strong database management tools with the Filter Tool, Advance Filter, sort, create PivotTables, and use database formulas. Learn how to link cells to other formulas, worksheets and workbooks. Learn to consolidate your work by hiding and grouping columns/rows, copy/move worksheets, and lock cells. Learn the steps to use Microsoft Word Mail Merge and your spreadsheet as the database. Previous Windows and Microsoft Excel experience is requested. Instructor: Karl Maaser.