Database & Advanced Excel Concepts

Databases and data analysis are pervasive in today's work environments. Students study advanced Excel topics, including pivot tables, filters, tables, what-if analysis tools, data validation, error checking, and preparing Excel data for use in databases. Students also learn how to design and use a database using Microsoft Access, and import data from Excel. Emphasis is on extracting information from Access databases by creating and using queries. A combination of lectures, practical demonstrations, in-class and out-of-class assignments, and review simulations contribute to the students' learning experience. Mac students, please note that Microsoft Access will not run on a Mac without additional software.    

Note: Check with the institution regarding start/end dates, prices, and delivery method. These may vary according to program, section, and/or semester.