CAS 171 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.
Addendum: A major goal is to develop better computation skills. Improved critical thinking, decision-making, and problem-solving skills will also be emphasized.