What's New? | Contact Us

About Us | Site Map     

Home
Back

 

2015 Weekly Picks

Cool Websites
Publications
Key Trends
Useful Resources
Tech Tips
 
Picks Archives
 
 

Bookmark and Share

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. 

Topics include:

  • 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

Presenter Bio: 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 tools. 

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.

 

"There is nothing so useless as doing efficiently that which should not be done at all." Peter F. Drucker  View Past Quotes

frank@createthefuture.com susan@createthefuture.com

© 2016 Creative Information Systems 

 In Association with Amazon.com

Revised: June 20, 2016