Managing Data with Excel
Managing Data with Excel
Module One: Getting Started
Workshop Objectives
How to Use this Manual
Module One: Overview/Perspectives
What is a database?
Examples of Excel Databases
Limitations of Using Excel as a database
Types of Data
Text Data
Numeric Data
Formulas
How Excel Stores Dates and Times
Module Two: Importing and Exporting Data
Getting Data Into your workbook
Getting data out of your workbook
Working with an External Database
Module Three: Setting up your data in Excel
Surround The Data List with a Blank Row and a Blank Column
Create a Table
Overview of Excel Tables
Expanding the Database
Module Four: Excel Lookup Functions
Working with Lookup Functions
Using a VLOOKUP Function
Using the HLOOKUP Function
Dynamic searching using MATCH and INDEX
Module Five: Excel Database Functions
DGET Function Overview
Module Six: Using Time Saving Tools
Using AutoFill
Using AutoComplete
Filtering Data
Sorting Data
Module Seven: Managing Your Data
Transposing Data from Rows to Columns
Using the Text to Columns Feature
Checking for Duplicates
Creating Data Validation Rules
Consolidating Data
Module Eight: Grouping and Outlining Data
Grouping Data
Outlining Data
Adding Subtotals
Viewing Grouped and Outlined Data
Module Nine: Working with Forms
About Excel Forms, Form Controls, and Active X Controls
Using a Data Form
Using a Combo Box Control
Using a List Box Control
Using a Spin Button Control
Using a Scroll Bar Control
Module Ten: Wrapping Up
Module Eight: Review Questions
Words from the Wise
Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations
Managing your data in Excel (Case Study)
Powered by
GitBook
Examples of Excel Databases
Examples of Excel Databases
Schedule or Calendar
Meeting Agenda
Mailing list
Contact list or Address book
Employee list
Travel Planner
Issue Tracker
results matching "
"
No results matching "
"