Database Management in Excel

A database is a collection of related information stored in one or more computer files. Often the data is organized into tables in such a way that it can easily be updated, sorted, corrected, and filtered. A simple database, such as Excel, holds all information about one subject in a single table.

All Prices Are in Candian Dollars

Price :

Choose the date and press 'Add To Cart'

No class dates currently scheduled. Click here to request a date

course is guaranteed to run

Description

Topics:
• sort data
• filter data in a range or table
• group and outline data
• insert subtotals in a worksheet
• display different levels of data using outlines
• outline data
• filter and sort data
• apply subtotals to data
• organize worksheet data to facilitate data analysis
• specify the data that is allowed in a particular range
• recognize which error alert to use in given examples
• locate and correct formula errors
• use the Watch Window to audit formulas
• locate and correct formula errors
• add data validation to prevent the errors from recurring DATA VALIDATION
• Restrict cell content by forcing users to pick entries from a pick list 7
• Restrict cell content by value, text, or data/time
• Restrict cell content by formula
• Use auditing tools to check the validity of existing data DATA FORM
• Build and maintain a database with the Form feature SORTING
• Use multiple-key sorts from the menu or from button commands
• Sort based on rearranging rows or rearranging columns
• Sort based on cell color, font color, or icon; sort in random order
• Sort text data based on customized lists—override alphabetical order
• How to get rid of extra spaces that prevent matching and sorting CREATING

AUTOMATIC SUBTOTALS WITH THE SUBTOTALS COMMAND
• Set up single and multiple-level subtotals
• Expand and collapse displays quickly with grouping and outlining symbols

USING POWERFUL FILTERING TOOLS TO VIEW JUST THE DATA YOU WANT TO SEE
• Set up filtering to see and print a subset of data
• Create compound selection criteria for filtering data
• Use Excel’s greatly expanded special filtering tools for Text, Number, and Date fields
• Use the Advanced Filter to overcome limitations of standard filtering; use complex criteria OTHER DATA TOOLS
• Use the Text to Columns command to split data into multiple columns
• Use the Remove Duplicates command to eliminate redundant records

DATABASE ANALYSIS TOOLS
• Using SUMIF and COUNTIF and related functions for quick data analysis