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
Module Two: Importing and Exporting Data
Module Two: Importing and Exporting Data
results matching "
"
No results matching "
"