In this article, we describe an attempt to prepare teaching materials to efficiently process NDB open data. The teaching materials consist of explanations of NDB open data and instructions of data processing using Visual Basic for Applications (VBA), a programming language that can be used with the spreadsheet software Excel. In addition, the teaching materials allow students to understand the advantages of using VBA by comparing it to working with Excel worksheets. Finally, we asked them to solve VBA-related problems and confirmed their understanding of the teaching materials.