Excel Marcos Course

To open the e-course, enter your username and password and click on the “Logi sisse / Login” button.
If you have forgotten your username / password or cannot log in, please take a contact with us asko@kasulikkoolitus.ee.

Table of content of a Excel Macros Course

GETTING STARTED

  • Introducing macros and giving samples of macros
  • Attention! Can’t use the Undo command
  • Macro Training versus VBA Programming Training

CREATING AND SAVING A MACRO

  • Macro recording options
  • Naming, choose location and describing a macro
  • Saving the workbook with a macro
  • Absolute and relative references
  • Record and save a macro as a part of a workbook
  • Record and save a macro as a part of my Excel (1)
  • Record and save a macro as a part of my Excel (2)

USING MACROS

  • Distinguishing a workbook with a macro from a usual Excel workbook
  • Available macros in a open workbook
  • Options to open a window with a list of macros
  • Changing or deleting a macro in the macros list window
  • Running a macro with a keyboard shortcuts
  • The keyboard shortcut for pasting values only
  • Running a macro on the quick access toolbar
  • Running a macro with the toolbar from a menu
  • Running a macro with a button, a shape or an image
  • Editing security settings of using files with a macro

VISUAL BASIC EDITOR

  • Visual Basic Editor (VBE)
  • The layout and elements of the VBE
  • Arranging macros in the VBE

GETTING TO KNOW MACROS CODE

  • Getting to know Macros code
  • Testing parts of a macro
  • Testing changes in a macro code
  • Cleaning a code
  • Supplementing the VBE toolbars ribbon
  • Following how the code is created during recording a macro
  • Relative reference in a macro code

WORKING WITH THE MACROS CODE

  • Creating a macro in VBE
  • Referencing cells by a size of a table
  • Referencing ranges by a size of a table
  • Referencing in a table with a empty cells
  • Using a shorter code
  • Samples about replacing references in a macro code
  • Repeating a part of a macro by Do Loop and For Loop
  • Using IF statement in a macros code
  • Blocking and adding a pop-up window
  • Adding a pop-up window as a input box
  • Searching a code from the web and adding a new function

MORE

  • Fixing macros code of a Pivot Table