lithia-motors-oss / excel-guru-training

excel-guru-training

Overview

Lithia Motors has grown exponentially! Many departments rely on Excel macros to function efficiently

---

Topics

Version Control

Git (Client VC)

Lithia GitHub (public)

• workflow
  • Excel Import / Export
  • Init / Clone
• branching
  • Git Flow
• merging

Team Foundation / Github (server VC)

• push / pull
• pull request
• code review
• linking commits to work items

---

Task Management

• Kanban workflow

---

Developer Tools

General Software Development

• GitKraken
• Visual Studio Code
• Markdown Cheatsheet

VBA specific

• VBA-Import-Export-Tool
• VBA-Tools Collection
• MZ-Tools
• Rubber Duck VBA

---

Software Craftsmanship

• Documentation
• SOLID Principles
• Programmer's Oath
• Legacy Code Modification
• Clean Architecture
• Programming Paradigms
  • Object Oriented
  • Functional
  • Imperative
  • Declarative
• Test Driven Development (TDD)
  • Red Green Refactor
• Behavior Driven Development (BDD)

---

Code Style Guide

• spaces per tab (4)
• Naming Conventions
• Descriptive Names > code words
• When to comment. When not to comment
• Comment Tags
  • {DEV}, {TODO}, {BUG}, {TECHDEBT}
• linters

---

VBA Software Architecture & Best Practices

• VBA Files
  • UserForm (.frx,.frm)
  • Module (.bas)
  • Class (.cls)
• Data Types
  • Variant
  • Boolean
  • Long
  • Double
  • Date
  • String
  • Object
• Code Structures
  • Methods (verb)
    • Sub
    • Function
  • Properties (noun)
    • variable
    • Property
  • Objects
    • Type
    • Class
  • Enumerators
  • Events
• private/public methods
• Iteration
  • for
  • for each
  • do
• Data storage an recall
  • range / table
  • array
  • collection
  • dictionary
  • recordset
• Fully Qualified Referencing
• Abstraction
• GoTo
  • line identification
  • GoTo 0
  • Resume Next
• Error Handling
• VBA package management
  • code accessable repositories (CDN)

---

VBA Knowledge Resources

• MSDN Excel VBA
• Chip Pearson Software Consulting
• Stack Overflow