​Excel 2013: Advanced


How powerful is Excel? Building on the skills and concepts taught in the intermediate course, students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, learn about data validation and database functions such as DSUM. Learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
 
To see if this course is for you, click here to complete the checklist to gauge your current skill level.
 
The instructor suggests (but not required) students purchase:
 
Excel 2013: Advanced, ISBN-10: 1-4260-3610-8, which can be purchased from http://www.axzopress.com/ for approx. $18.75 (not including tax and shipping). You may find it cheaper on Amazon or another online store.
 
This is a not-for-credit course.
As such, you will not earn units and the class will not be reflected on your banner schedule or on transcripts. As a not-for-credit course, Financial Aid cannot be used to pay for or offset the costs of this course.
 
Dates & Times: Saturday, November 16, 2013
8:00 AM - 5:00 PM
 
Location: BICS Training Center, Classroom 1
Click here for a map to the BICS Training Center
 
Cost: $99
 
Instructor: Doug Arnold (doug@arnoldwebdev.com)
 
Registration: Click here to register for this course.
 
Cancellation & Refund Policy:
Click here for the Business, Industry & Community Education student cancellation and refund policy.
Last Updated: 9/18/2013 3:01 PM