Accelerator: Building Custom Macros & Templates


Register Now

Learn how to build custom automation with templates and macros in Microsoft Excel.

Learn how to build custom automation with templates and macros in Microsoft Excel.

Are you interested in:

  • Trying or getting a basic understanding of Excel (such as from the Accelerator: Intro to Excel)?
  • Enhancing your knowledge of Excel?
  • Motivated to learn something new?
  • Then this is the right program for you!
  • There will be some homework so you can recreate or build custom templates seen firsthand between course offerings to deepen your understanding.

Learning macros and templates will speed up your production and reduce the time you spend on your Excel sheets.

A macro is a recording of formatting changes and other routine tasks performed in Excel to be replayed quickly.

A template is a pre-formatted workbook or worksheet with built-in headers or formulas.

Learn the basics of both and when to apply one or the other for your data sets or collection inputs. Introduction and possible utilization of VBA (Visual Basic for Applications).


Thursdays: 9/15/22 – 9/22/22 (6PM – 8PM ET)


via Zoom



NOTE: By participating and attending all of the classes, you will earn a credential that signifies the time and effort you put into this program. You can include this credential on your resume and post it to your LinkedIn profile.


Amanda Swanson is a statistician and (Otterbein) MBA graduate with 15 years of product development experience, concentrated on leveraging data-focused innovation and problem-solving techniques. Identifying consumer problems and optimizing possible solutions (products) is her career passion. She has had the opportunity to share her skills with companies like Nestle, E&J Gallo Winery, and Disney and also enjoys watching baseball and practicing yoga in her free time.

*This program is FREE for students attending Bluffton, Capital, Denison, Heidelberg, Kenyon, Marietta, Ohio Wesleyan, Otterbein, Wittenberg, and Wooster. Ask your advisor for the promotional code.*