Using Excel as a Database: Analyzing Data and Creating Reports
This webinar is designed to teach you how to use Excel to create a
database for managing information. Learn the difference between “flat”
and “relational” databases. Develop an understanding of when it may be
important to use a relational database. Learn how to retrieve specific
information, including: sorting, filtering and advanced filters. Find
out how to add, delete and modify database fields. Learn how to use an
Excel worksheet as the data source for a Word mail merge. Explore how
to use Excel database features to create various types of reports,
including: group and outline, subtotal reports, pivot tables, and more.
- Basic database terminology
- Flat vs. relational databases
- Rules for creating databases in Excel
- Sorting, filtering and advanced filter
- Using an Excel database to print letters and
envelopes through Word
- Creating reports using group and outline
- Creating subtotal reports
- Understanding pivot tables
- Using Excel with Access and other database programs
To get the most out of this webinar, you should have some prior
experience with Excel. Excel 2010 will be used for demonstration
but the basic information covered in this webinar applies to all
versions of Excel.
Special Features: Attendees will receive a detailed handout
and an Excel workbook with more than 20 worksheets, including all of the
examples demonstrated in the Webinar. After the session, they will
receive the PowerPoint presentation file used in the webinar and a link
to the on-demand recording of the webinar.
Who Should Attend: Anyone already familiar with Excel who
would like to learn to use it as a database.
Attend As A Team: This webinar can be viewed by several
individuals from the same organization using one computer making your
investment even more cost effective.
Presenter: Susan Biro
Date: To be announced
Time: To be announced
Price: To be announced
Susan Biro, Creative Information Systems
Susan has more than twenty-five years of work experience in
the information technology field. She founded Creative Information
Systems in 1980 and works with a wide variety of organizations. As an
emerging technology consultant, Susan has created custom databases, helped
to design multimedia presentation facilities, and developed numerous
applications requiring a broad understanding of state-of-the-art information
Susan has worked with a wide range of computer and video
equipment, as well as numerous software packages including: Word, Excel, Access,
PowerPoint, Publisher, Outlook, FrontPage, and Photoshop. She is currently
designing and facilitating
Create the Future Webinars.
Susan has a BA and MS from the University of Wisconsin and a
Web Master Certificate from Marquette University.