Microsoft Excel as a Database


Home About Jeanina References On Site Classes Adult Education Classes Technology Training Center	Microsoft Excel as a Database Jeanina Sargent (717) 586-1878 jeanina@sargentsoftware.com Students will learn how to create a Database in Excel where records can be sorted and filtered. Learn how simple queries can generate powerful result. Database Manager Creating a Database Sorting Data Filtering Data Using a Data Form Consolidating Data Linking Files Updating Links Organizing Your Worksheets Working with Multiple Sheets Inserting a New Worksheet Naming Worksheets Moving Worksheets Hiding/Unhiding Groups Formatting Options Custom Formatting Excel Functions Formulas Excel Charts Creating Charts Selecting Chart Objects Sizing The Chart Applying Text Attributes to Chart Objects

Database Manager