The Office Ninja

@UCY-6DstZI7EDeIP2rgKhTAQ - 448 subscribers

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 are relatively simple ... others more complex. The goal of the channel is to give you the skills you need to stand out from your peers in the office, to make you more efficient and so you can automate those boring tasks! I will be uploading new videos every Friday and I'm open to suggestions :) You can find more tutorials on my blog The Art of Quant Finance: www.theartofquantfinance.com and I'm also creating some Udemy courses which will be going public soon. Thanks for watching and enjoy! Paul.

Home Videos Live Playlists

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

815 views - 6 years ago

Understanding VBA Code: Enumerations Part 5 (Select Case)

Understanding VBA Code: Enumerations Part 5 (Select Case) The Office Ninja

278 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

218 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

239 views - 6 years ago

Understanding VBA Code: Enumerations Part 2

Understanding VBA Code: Enumerations Part 2 The Office Ninja

660 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

15K 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

351 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

279 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

832 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

478 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

810 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.5K 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