Excel Macros Mastery & Excel VBA for Non-Programmers

Andreas Exadaktylos, Teacher | Expert Computer Scientist | Entrepreneur

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
37 Videos (1h 36m)
    • Introduction

      2:22
    • Let’s get started by answering the most common questions

      1:39
    • Running a Macro using Buttons or Graphics

      2:45
    • Macros and Security

      3:18
    • Why macros are huge time savers See examples

      2:09
    • Running a Macro using the Quick Access Toolbar

      2:20
    • What are macros and how we can use them

      1:54
    • Running a Macro using the Ribbon

      1:00
    • Ways of Recording a Macro

      2:58
    • Enter the world of Excel VBA

      4:05
    • Dealing with VBA Errors

      1:04
    • Macro Recorder vs VBA

      1:33
    • The VBA Environment

      4:16
    • VBA Editor Tips

      2:17
    • Make a macro available all the time

      2:55
    • The Anatomy of Macros

      1:44
    • Case Study Use navigation buttons to change Chart Type

      3:16
    • Organizing your Personal Macro Workbook

      1:36
    • Recording your first Macro

      3:33
    • Hello World!

      3:40
    • How to read from a cell

      1:20
    • WithEnd how this statement can save you time

      2:19
    • Range and Cells properties

      1:42
    • The core of VBA Workbook Worksheet and Range

      2:36
    • Dim and Set statements

      2:32
    • Variables

      2:13
    • Using IF..ELSE Statements with Macros

      5:19
    • Combining Macro Recording and VBA Statements

      5:44
    • Case Study Prompting a user to select a worksheet and run a macro

      2:21
    • Using DO UNTIL Statements with Macros

      2:09
    • How to join 2 different Macros

      1:40
    • Tips for running your Macros fast

      2:01
    • Using Relative or Absolute Reference

      3:12
    • Using FOR…NEXT Statements with Macros

      5:48
    • Saving a Workbook before Closing

      2:32
    • Closing All Workbooks at Once

      1:13
    • My Final Thoughts Thank you

      0:50