用excel的vba进行马氏距离运算，简单易行，但是对数据量有限制，即excel中对行列的限制

Microsoft Excel 2019 VBA and Macros (Business Skills) By 作者: Bill Jelen – Tracy Syrstad ISBN-10 书号: 1509306110 ISBN-13 书号: 9781509306114 Edition 版本: 1 出版日期: 2019-01-07 pages 页数: (1580) Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly About This Book For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

Excel_VBA_编程教程(完整版)，详细讲解VBA基础知识和Excel中的VBA应用，可以很大程度提高工作效率

本书深入浅出，详细地介绍了VBA在金融中的运用，十分适合于初学者，我自己学后，深有体会

Excel 2013 VBA编程与实践 源代码

《Excel专业开发(Microsoft Excel及VBA应用开发权威指南)》配套光盘，本书书号：ISBN 978-7-121-03817-4，配套光盘中包含了示例应用程序，代码中包含了非常详细的注释，以及作者用于Excel开发的各种工具，是提升你Excel开发的好帮手！

这个已经是旧版本了，有很多文字都无法转换，推荐最新版本 https://blog.csdn.net/lxf2580/article/details/54409636 ，但是这个最新版本好像也只适用于2019以前的Excel，office2019据反馈说用不了。

EXCEL 2010 VBA帮助文档，属性、方法· 2010目录下转制

本书分为三大部分，第一部分讲解一些VBA的基础指示；第二部分更深入地讲解图表、高级筛选、数据透视表、Web查询、XML语言等待；第三部分讲解一些高级的技术问题。书中安排了大量的示例，每一章中至少有一个案例研究，这都是真实世界中的一些常见问题的解决方案。 此文件是此书样例文件

Excel_VBA_编程教程(完整版)、excel高级教程