The emphasis in this second level class is on charts, databases, and advanced calculating capabilities of Excel. Learn to create and modify charts, format chart objects, and use graphic objects to enhance charts. Learn to sort and filter data on both single and multiple levels. Filtering, or asking questions of the database (querying), is the fundamental way to extract information from a database. Advanced formulas, calculating between worksheets, and pivot tables will be covered. If you make graphs or work with simple lists and databases, this class is for you. 07/17/2014 – 07/24/2014, Course # CIS-901-VE07, Syn # 83189.