Setup Menus in Admin Panel

Course Curriculum

Welcome_Excel 00:00:00
Using the exercise files_Excel 00:00:00
Getting Started
Understanding what a macro does_Excel 00:00:00
Reviewing macro examples_Excel 00:00:00
Understanding security_Excel 00:00:00
Reviewing the recording method_Excel 00:00:00
Understanding other techniques for macros_Excel 00:00:00
Running a Macro (Execute, Playback, Etc.)
Running macros from the View tab_Excel 00:00:00
Running macros from a keyboard shortcut_Excel 00:00:00
Running macros from the Quick Access toolbar button_Excel 00:00:00
Running macros from an object or clip art_Excel 00:00:00
Using Virtual Basic Applications (VBA)
Introducing the VBA environment_Excel 00:00:00
Viewing the VBA components_Excel 00:00:00
Recording a Macro in Stages
Recording a simple macro_Excel 00:00:00
Adding functionality to a macro_Excel 00:00:00
Creating Non-Recordable VBA Code
Understanding absolute and relative references_Excel 00:00:00
Using For and For…Next statements_Excel 00:00:00
Using Do…While and Do…Until statements_Excel 00:00:00
Creating interactive macros_Excel 00:00:00
Macro Project: Converting a Mailing List into a Database List
Planning a macro_Excel 00:00:00
Recording partial code_Excel 00:00:00
Using loop structures in context_Excel 00:00:00
Testing a macro in Step mode_Excel 00:00:00
Pulling the data together_Excel 00:00:00
Joining two macros_Excel 00:00:00
Streamlining macros_Excel 00:00:00
The Personal Macro Workbook
Creating a personal macro workbook for macros with wide applicability_Excel 00:00:00
Closing and updating the personal macro workbook_Excel 00:00:00
Final thoughts_Excel 00:00:00

Course Reviews


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

  • 1 week, 3 days
    Copyright @2019