An in-depth, hands-on course that presents advanced features of Excel to design and create accurate, professional worksheets for use in business and industry. Includes financial, logical, statistical, lookup, and database functions; pivot tables; "what-if" analysis with data tables; importing data; complex graphs; macros; and solver features. Focus on ways to ensure accuracy including proofreading techniques and critical thinking to determine what data to present and how to present it. Prerequisite: CAS 170 or instructor permission.