Excel Macros 简明教程

Excel Macros Tutorial

Excel 宏是一项或多项操作,你可以记录、命名、保存和按需多次运行这些操作。宏能够帮助你节省重复数据操作和数据报表所需的时间,而这些操作和报表是需要频繁完成的。

Audience

This guide targets novice developers and those new to Excel Macros. After completing this tutorial, your firm foundation in creating macros will allow you to use macros efficiently.

Prerequisites

When you record a macro, Excel stores it as a VBA code. You can view this code in the VBA editor. You can understand the code and modify it if you have substantial knowledge of Excel VBA. However, if you do not have sufficient knowledge, then we will suggest you to go through our short tutorials on VBA.