FacebookDeliciousTwitterFeed
Home Participate In Webinars How to Effectively Use MS-Excel as a Database

How to Effectively Use MS-Excel as a Database

PDF Print E-mail
Business 21 Audio Conferences  

Upcoming audio/web event for HR leaders ...
Only 24 hours left to Register

When:
Excel 2010 - Tuesday, October 16, 2012 at 1:00 pm Eastern - 90 mins

Snapshot: Some people hear the word “database” and assume that you must use MS-Access or some other complex program most non-technical people wouldn’t be comfortable learning. But Excel can perform database functions as well, and it’s relatively easy to use. Excel isn’t designed to handle relational file structures and has some size limitations, but it has the power and capability to handle large "flat file" type data collections. Most people are already using excel as a database and may not even realize it.
This session explores all critical techniques needed to manage a database in MS-Excel.

Click here to register for Excel Version 2010 on October 16

Or Call Customer Service toll-free at 1-888-479-2777

====================================================

More Program Details...

YOU'RE INVITED: Please join us for the 90-minute audio/web conferences How to Effectively Use MS-Excel as a Database on Tuesday October 16th (Version 2010) at 1:00 pm Eastern time.

Note: It is recommended that you participate in the web portion of the event to receive the most benefit, as our speaker will be working within Excel.

Click here to register for Excel Version 2010 on Oct 16

COURSE DESCRIPTION: Some people hear the word “database” and assume that you must use MS-Access or some other complex program most non-technical people wouldn’t be comfortable learning. But Excel can perform database functions as well, and it’s relatively easy to use. Excel isn’t designed to handle relational file structures and has some size limitations, but it has the power and capability to handle large "flat file" type data collections. Most people are already using excel as a database and may not even realize it.

This session explores all critical techniques needed to manage a database in MS-Excel. Learn all about validating data, creating data entry forms, sorting, adding subtotals, filtering, and when to use Excel’s advanced filter. You’ll also learn about Excel’s powerful new Tables feature as well as how to avoid poor database design and to correct improperly stored data.

Our speaker will focus on the many powerful and easy-to-use database commands and methods critical to anyone who maintains an Excel database.

  • Get rid of extra spaces that prevent matching and sorting
  • Use multi-key sorts from the toolbar
  • Sort by re-arranging the left-right order of columns
  • Use grouping to better analyze your data
  • Insert multi-level automatic subtotals for quick displays of summary totals
  • Filtering techniques: view just the data you need to see – and quickly
  • Validation - how to keep out bad data – before it even gets into your database
  • Restrict cell content by value, formula or date
  • Provide pick lists for even faster entry and greatly enhanced accuracy
  • Eliminate duplicate records from your database in no time at all
  • Split improperly grouped data into multiple columns – i.e. City, State, Zip

Click here to register for Excel Version 2010 on Oct 16

ABOUT THE SPEAKER: Dennis Taylor is an author and highly respected computer trainer and facilitator, specializing in Excel. His focus is on those spreadsheet and database techniques that improve business efficiency and productivity. Dennis has over 20 years of training and consulting experience. A former employee of Amoco Oil, Levi Strauss, StorageTek, the Federal Government, and the University of Colorado, he has taught nearly 4,000 seminars and classes for over 100 companies, organizations, and government agencies.

Dennis is the author of “Teach Yourself Microsoft Excel 2000” and co-author of four other books on spreadsheet software. He has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to many clients over the past 20 years. In addition, Mr. Taylor has authored and presented over 50 different training courses on Excel topics (available on DVD/CD/VHS formats) and has presented numerous webinars to thousands of attendees.

PRICE: $249 to attend the live conference. However, the event is available in multiple media. Here is your full menu of options:

  • Event only: $249
  • Event Value Pack (Event, CD-ROM, Transcript PDF, audio CD): $429
  • Recorded Value Pack (CD-ROM, Transcript PDF, audio CD): $349
  • Full webinar on CD-ROM: $247
  • Audio Recording only: $229

Audioconference formats explained

The conference fee is for a single phone line, but most companies have several people listening at once via speakerphone in a conference room. Attendees with multiple locations must register each location. If you have any questions or would like to register another site, please contact customer service at 888-479-2777. Discounts are available for multiple lines.

Click here to register for Excel Version 2010 on Oct 16

Call 1-888-479-2777 to register by phone
or speak to a customer service representative

Conference FAQ

Other Upcoming HR Events:

October 17
On-Boarding: A Four-Step Process to Ensure that New Hires Succeed in their First 90 Days

October 30
Workplace Violence: What You Need to Know about Bullies, Harassers and Violent Workers

October 31
Disciplining Workers for Inappropriate Social Media Posts: Policy Dos and Don’ts

Conference benefits?

- No travel expenses

- No time away from the office

- The most economical training available

- Multiple employees can listen in on a single phone line.

Business 21 ~ 453A Baltimore Pike, Springfield, PA 19064 ~ 888-761-7294