CAS171 Intermediate Excel

Introduces 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. Focuses 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. Audit available.
(For detailed information, see the Course Content and Outcome Guide ).