Excel - Macros, Excel programming for Dummies

This workshop is aimed at anyone who wants to use programming to improve his or her Excel skills. It is tailored specifically with nonspecialist in mind. You do not need to have any programming knowledge or experience to start with this workshop. Perhaps you only want to write simple programs for your own use, or may be you need to create Excel programs for use by your coworkers. In either situation, this workshop is aimed at you.

  • Learn VBA using macro to record operation steps;
  • create and edit macros;
  • breakpoints, step thru, debug;
  • Import, export macros;
  • macro not limited to single workbook;
  • execute macros within macros;
  • assign hotkey, add description;
  • ways to create worksheets;
  • ways to change worksheets name using array;
  • copy range from one workbook to another, keeping original formats;


Workshop