The Office Ninja

448 subscribers

29 videos

View on YouTube

The Office Ninja aims to provide short, punchy videos with tips and tricks for Microsoft Excel, Access and Visual Basic for Applications (VBA). Some of these...

Latest Videos

Understanding VBA Code Static and Dynamic Arrays with Dim

Understanding VBA Code Static and Dynamic Arrays with Dim

The Office Ninja

2.8K views·6 years ago

User Defined Types (Structs) in VBA

User Defined Types (Structs) in VBA

The Office Ninja

2.9K views·6 years ago

Clean up VBA Arrays using Erase

Clean up VBA Arrays using Erase

The Office Ninja

825 views·6 years ago

Understanding VBA Code Enumerations Part 5 (Select Case)

Understanding VBA Code Enumerations Part 5 (Select Case)

The Office Ninja

280 views·6 years ago

Function Wrapper in VBA #1 Forward Price function

Function Wrapper in VBA #1 Forward Price function

The Office Ninja

442 views·6 years ago

Understanding VBA Code Enumerations Part 4 (checking membership)

Understanding VBA Code Enumerations Part 4 (checking membership)

The Office Ninja

220 views·6 years ago

Remove unwanted Excel Worksheet Page Breaks with VBA

Remove unwanted Excel Worksheet Page Breaks with VBA

The Office Ninja

1.3K views·6 years ago

Understanding VBA Code Enumerations Part 3

Understanding VBA Code Enumerations Part 3

The Office Ninja

241 views·6 years ago

Understanding VBA Code Enumerations Part 2

Understanding VBA Code Enumerations Part 2

The Office Ninja

662 views·6 years ago

Understanding VBA Code Enumerations Part 1

Understanding VBA Code Enumerations Part 1

The Office Ninja

1.5K views·6 years ago

Understanding VBA Code Declaring Variables with Dim

Understanding VBA Code Declaring Variables with Dim

The Office Ninja

15.0K views·9 years ago

Understanding VBA Code What if we Don't Declare Variables

Understanding VBA Code What if we Don't Declare Variables

The Office Ninja

199 views·9 years ago

Speeding up VBA Code Calculation Mode

Speeding up VBA Code Calculation Mode

The Office Ninja

897 views·9 years ago

Understanding VBA Code Finding your way around with the Project Tree

Understanding VBA Code Finding your way around with the Project Tree

The Office Ninja

355 views·9 years ago

Understanding VBA Code How to Record a Simple Excel Macro

Understanding VBA Code How to Record a Simple Excel Macro

The Office Ninja

367 views·9 years ago

Understanding VBA Code Uber Lock down of an Excel Worksheet

Understanding VBA Code Uber Lock down of an Excel Worksheet

The Office Ninja

281 views·9 years ago

Microsoft Excel 2016 Lock Down or Protect Cells with Formulas

Microsoft Excel 2016 Lock Down or Protect Cells with Formulas

The Office Ninja

980 views·9 years ago

Microsoft Access Database Parameter Queries Building forms (part 2 of 3)

Microsoft Access Database Parameter Queries Building forms (part 2 of 3)

The Office Ninja

833 views·9 years ago

Understanding VBA Code Excel VBA Programming with File System Objects (Part 4 of 4)

Understanding VBA Code Excel VBA Programming with File System Objects (Part 4 of 4)

The Office Ninja

480 views·9 years ago

Understanding VBA Code Excel VBA Programming with File System Objects (Part 3 of 4)

Understanding VBA Code Excel VBA Programming with File System Objects (Part 3 of 4)

The Office Ninja

562 views·9 years ago

Understanding VBA Code Excel VBA Programming with File System Objects (Part 2 of 4)

Understanding VBA Code Excel VBA Programming with File System Objects (Part 2 of 4)

The Office Ninja

811 views·9 years ago

Understanding VBA Code Excel VBA Programming with File System Objects (Part 1 of 4)

Understanding VBA Code Excel VBA Programming with File System Objects (Part 1 of 4)

The Office Ninja

2.8K views·9 years ago

How to Build a Simple Parameter Query in Access

How to Build a Simple Parameter Query in Access

The Office Ninja

4.7K views·9 years ago

How to make your code robust with worksheet codenames

How to make your code robust with worksheet codenames

The Office Ninja

1.4K views·9 years ago

Dynamic Named Ranges in Excel

Dynamic Named Ranges in Excel

The Office Ninja

456 views·9 years ago

Goal Seek in Excel

Goal Seek in Excel

The Office Ninja

259 views·9 years ago

Use VBA Conditional Compile to Create Multiple Versions of Your Code

Use VBA Conditional Compile to Create Multiple Versions of Your Code

The Office Ninja

1.2K views·9 years ago

Understanding VBA Code How to Open the Visual Basic Editor in Excel

Understanding VBA Code How to Open the Visual Basic Editor in Excel

The Office Ninja

3.6K views·9 years ago

How to Create a Custom Visual Basic Editor Toolbar

How to Create a Custom Visual Basic Editor Toolbar

The Office Ninja

3.6K views·9 years ago

The Office Ninja - NatokHD | NatokHD