MARCH 2020 PCWorld 121E
xcel macros are like mini-
programs that perform repetitive
tasks, saving you a lot of time and
typing. For example, it takes
Excel less than one-tenth of a second to
calculate an entire, massive spreadsheet.
It’s the manual operations that slow you
down. That’s why you need macros to
combine all of these chores into a single
one-second transaction.
EXCEL MACROS: TIPS FOR
GETTING STARTED
We’re going to show you how to write your
first macro. Once you see how easy it is to
automate tasks using macros, you’ll never
go back. First, some tips on how to prepare
your data for macros:- Always begin your macro at the Home
position (use the key combination Ctrl+
Home to get there quickly).
How to create Excel macros
and automate your spreadsheets
Use macros to combine multiple tasks into a single transaction. BY JD SARTAIN
IMAGE: ROB SCHULZ