Kasper Langmann / March 20, In a spreadsheet tool like Excel, macros can be especially powerful. Learning how to automate Excel is one of the easiest ways to speed up your work–especially because Excel is used in so many. A Macro is a piece of programming code that runs in Excel environment and helps automate routine tasks. Learn step by step example of. Excel macro tutorials for beginners | Excel Macro tutorials for intermediate users. Bulk email Sending through VBA, Download FREE Excel E-Book | Enjoy. You already know your way around Excel, and are familiar with its grid of cells where you enter your text and functions. You can use a macro to record the steps of Importing the data Formatting it to meet your business reporting requirements. If you want to go the extra mile for purposes of speeding up your learning process about Excel macrosI provide some final tips. In Excel, most of the useful commands when working with Excel macros and Visual Basic for Applications are in the Developer tab. With a macro, it. The macro would then remove any bold formatting from the selection instead of making it bold.