Introduction
  • Introduction
  • Course Resources & Important Notes for New Students
  • Compatibility & Macros Security
The Basics of Macros
  • What are macros and how we can use them?
  • Ways of Recording a Macro
  • Ways of Running a Macro
  • Assign a Macro to Ribbon Icons and Create your Ribbon
  • Relative OR Absolute Method?
  • Rules regarding Naming Macros
  • Quiz 1: The Basics of Macros
  • EXERCISE: Record a Macro
  • Summary
Visual Basic Editor: What You Need to Know
  • Macro Recorder vs VBA
  • Enter the world of Excel VBA
  • The VBA Environment
  • VBA Editor Basics
  • VBA Modules and Editor Tab Tips
  • Excel VBA Object Model
  • Dealing with VBA Errors
  • Using VBA's Help System
  • Quiz 2: Enter the world of VBA
  • Summary
Get in-depth with Macros
  • The Anatomy of Macros
  • Make a macro available all the time
  • Organizing your Personal Macro Workbook
  • Watch An Excel Macro Write Your VBA Code
  • Project #1: Use navigation buttons to change Chart Type
  • Quiz 3: Get in-depth with Macros
  • Summary
VBA Procedures
  • How to Create your First Piece of Code
  • How VBA "speaks"
  • Workbook, Worksheet and Range
  • Object Properties and Methods
  • Sub Procedures
  • Sub Procedure Examples
  • Functions Procedures
  • Function Procedure Examples
  • Quiz 4: How to create your First Piece of Code
  • Summary
VBA Language Elements
  • Variables
  • Constants
  • Strings and Dates
  • Range and Cells properties
  • Assignment Statements
  • Arrays
  • Range Property
  • Cells Property
  • Offset Property
  • Useful Range Object Properties
  • Useful Range Object Methods
  • Summary
Make Decisions with VBA
  • With …End With Constructs
  • EXAMPLE: How to read from a cell
  • Dim and Set statements
  • Using IF..ELSE Statements with Macros
  • Using Relative or Absolute Reference
  • Using FOR…NEXT Statements with Macros
  • Using DO…UNTIL Statements with Macros
  • Project #2: Add a confirmation dialog box with VBA IF statements
  • Project #3: Prompting a user to select a worksheet and run a macro
  • Combining Macro Recording and VBA Statements
  • How to join 2 different Macros
  • Tips for running your Macros fast
  • Project #4: Transfer Data From one Excel Worksheet to another
  • Quiz 5: Supercharge Macros and VBA with Loops
  • Summary
Ready-to-use Excel Macros & VBA Projects
  • Project #5: How to Create Notifications-Reminders using VBA Code
  • How to create an Excel Animated Chart using VBA Code
  • Saving a Workbook before Closing
  • Closing All Workbooks at Once
BONUS SECTION
  • Excel 2019 Tutorial for Beginners
  • Amazing discount for my other courses!