Office 2016 Integrated Solution Development

Course Curriculum

Chapter 1: Start Here

Lecture 1: Introduction

Chapter 2: Creating macros

Lecture 1: Enabling the Developer Toolbar

Lecture 2: Creating Macros in Microsoft Word

Lecture 3: Macro Security in Office

Lecture 4: Assigning keyboard shortcuts to Word macros

Lecture 5: Enabling the Developer Tab in Excel

Lecture 6: Creating macros in Excel

Lecture 7: Relative vs absolute reference in Excel macros

Lecture 8: Assigning Excel macros to button and shapes

Lecture 9: Creating Ribbon Tabs, Groups, and Buttons

Chapter 3: Navigational macros

Lecture 1: Navigational Macros in Microsoft Word

Lecture 2: Bookmarks and Navigational Macros in Word

Lecture 3: Navigational Macros in Excel

Lecture 4: Internal navigation in Excel

Chapter 4: Text and data input macros

Lecture 1: Word Text Input Macros

Lecture 2: Word Formatting macro

Lecture 3: Word Find and Replace Text macro

Lecture 4: Word Image Insert Macros

Lecture 5: Word Insert Table macro

Lecture 6: Word Multi-Action macro

Lecture 7: Data Input Macros in Excel

Lecture 8: Creating Macros to Insert Formulas in Excel

Lecture 9: Assigning Formula Macros to Shapes

Lecture 10: Declaring String Variables in VBA

Chapter 5: Calling macros internally

Lecture 1: Creating Compound Macros in Word

Lecture 2: Create a Madlib using a partially completed document

Lecture 3: How to Call Macros Within Other Macros

Lecture 4: Compound macros in Excel

Lecture 5: Customize an Excel navigational macro for user input

Lecture 6: Create a compound macro

Lecture 7: Assign the compound macro to a shape

Chapter 6: VBA Userforms

Lecture 1: VBA UserForms and Form Properties

Lecture 2: UserForm Layout Controls and Control Properties

Lecture 3: UserForm Data and Selection Controls

Lecture 4: Form Command Buttons

Lecture 5: Programming a Userform Clear Button

Lecture 6: Adding a button to a worksheet to open a form

Lecture 7: Creating a responsive userform

Lecture 8: Programming a responsive ComboBox

Lecture 9: Create and use navigational macros

Lecture 10: Program the userform OK button

Lecture 11: Programming the Clear and Cancel button

Chapter 7: Declaring and Using Public Variables

Lecture 1: Introduction to Public Variables

Lecture 2: Intro to Public Variables

Lecture 3: Public Variables in Word

Lecture 4: Create a macro to call up the userform

Chapter 8: Macros With Arguments

Lecture 1: Intro to Arguments and Parameters

Lecture 2: Methods for passing parameters

Lecture 3: Word macros with parameters

Lecture 4: Using Parameters with Word Macros

Chapter 9: Macro-enabled Templates

Lecture 1: Saving a file as a template

Lecture 2: Saving a macro-enabled template

Lecture 3: Excel Cell Locking and Sheet Protection

Lecture 4: Editing a Macro-enabled Template

Lecture 5: Word macro-enabled template

Chapter 10: Introduction to Document Events

Lecture 1: Document events in Word

Lecture 2: Workbook events in Excel

Chapter 11: If – Then – Else Loops

Lecture 1: Using If… Then… Else Logic

Lecture 2: Using VLOOKUP instead of IF… THEN… Rules

Lecture 3: If…Then for Data Validation

Chapter 12: "Do" Loops

Lecture 1: Intro to For Next and Do Loops

Lecture 2: Do while loops

Lecture 3: Do While Action Loop

Lecture 4: Do Until … Loop

Chapter 13: Handling Paths and File Names in VBA

Lecture 1: Creating a Save As… macro

Lecture 2: Saving Excel as a PDF using a macro

Lecture 3: Constructing file paths and names

Lecture 4: Using VLOOKUP results as file name components

Chapter 14: File Handling Macros

Lecture 1: Create a macro to open another file

Lecture 2: Create a macro to open a file and navigate to a specific location

Lecture 3: Multi-action file handling macro

Lecture 4: Complex file-handling macros in the time card solution

Chapter 15: Calling macros in other files

Lecture 1: Create a macro that runs a macro in another file

Lecture 2: Create a macro that interacts between two files

Lecture 3: Intro to section 3 – Projects Solution

Lecture 4: Create a macro in the secondary file

Lecture 5: Create a macro in the primary file that calls the first macro

Lecture 6: Create a macro to list the new project info

Lecture 7: Assign two compound macros to a single button

Chapter 16: External Program Activation

Lecture 1: Open a Word document with an Excel macro

Lecture 2: Open an Excel file with a Word macro

Lecture 3: Open a changing Excel file from a Word macro

Lecture 4: Create a macro to create a file based on another program template

Lecture 5: Open a dynamically changing Word document with an Excel macro