Setup Menus in Admin Panel

Course Curriculum

Introduction
Welcome_Excel 00:00:00
Using the exercise files_Excel 00:00:00
Getting Started with Macros
Identifying applicable situations for using macros_Excel 00:00:00
Recognizing the need for single-action macros_Excel 00:00:00
Understanding security_Excel 00:00:00
Short examples of the recording method_Excel 00:00:00
Overview of other techniques_Excel 00:00:00
Running a Macro
Running a macro from the Developer tab or the View tab_Excel 00:00:00
Running a macro from the Quick Access Toolbar button_Excel 00:00:00
Running a macro from a keystroke shortcut_Excel 00:00:00
Running a macro from an object or clip art_Excel 00:00:00
Using Virtual Basic for Applications (VBA)
The VBA environment and VBA components_Excel 00:00:00
Creating the Personal Macro Workbook_Excel 00:00:00
Closing and updating the Personal Macro Workbook_Excel 00:00:00
Recording a Macro in Stages
Recording a simple macro_Excel 00:00:00
Expanding a macro with the if statement_Excel 00:00:00
Creating Nonrecordable VBA Code
Understanding when to use absolute or 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
Conclusion
Next Steps_Excel 00:00:00

Course Reviews

N.A

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

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 week, 3 days
0 STUDENTS ENROLLED
    Copyright @2019