Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel 2016: Macros in Depth

via LinkedIn Learning

Overview

Save time by automating repetitive tasks with Excel macros. Learn how to record, edit, and run simple macros, and program more complex macros with VBA.

Macros can help you save enormous amounts of time, but they are uncharted territory for many Excel users. Learn how to create your own simple macros to automate repetitive tasks in Excel 2016, in this course with Excel expert Dennis Taylor. Find out how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be easily recorded. Discover how to expand macros with Do loops and If statements, and test macros step-by-step. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
1. Getting Started
  • Identifying applicable situations for using macros
  • Recognizing the need for single-action and multi-action macros
  • Understanding security
  • Short examples of the recording method
  • Overview of other techniques
2. Running a Macro
  • Running a macro from the Developer or View tab
  • Running a macro from the Quick Access Toolbar
  • Running a macro from a keystroke shortcut
  • Running a macro from an object or picture
3. Using VBA
  • The VBA window and VBA components
  • Creating the Personal Macro Workbook
  • Closing and updating the Personal Macro Workbook
4. Recording a Macro in Stages
  • Recording a simple macro
  • Expanding a macro with the If statement
5. Creating Nonrecordable VBA Code
  • Absolute or relative references
  • For…Next statements to repeat actions
  • Do While and Do Until statements to repeat actions
  • Creating interactive macros
6. Macro Project: Converting a Mailing List into a Database List
  • Planning a macro
  • Recording partial code
  • Using loop structures in context
  • Testing a macro in Step mode with a split screen
  • Pulling the data together
  • Joining two macros
  • Streamlining macros
Conclusion
  • Goodbye

Taught by

Dennis Taylor

Related Courses

Reviews

Start your review of Excel 2016: Macros in Depth

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free