The Application of Case Teaching in Excel Lookup and Reference Functions

Abstract

This article embarks from the production of student card which combines the vlookup and index functions, and discusses the application of case teaching in Excel lookup and reference functions. Teachers guide students to analyze, discuss and practice the case in the process of teaching. And students take the initiative to explore and collaborate, so as to achieve the teaching goal and realize the teaching that benefits teachers as well as students.