Below video illustrates dashboard from Project II

Dashboard_for_individual_or_team.mov

Project I: Automate data entry

Details:

1. VBA CODES:
   code_note_p1.bas
   
2. Explanatory Documents:
   Type 1: scope of work
    - Purpose
    - Scope / Major Project Activities
    - This project does not include
    - Deliverables

   Type 2: report
    - Motivation
    - Process Design
    - Building Schema
    - Final Delivables

Project II: Visualize summary data

Details:

1. VBA CODES:
   code_note_p2.bas

2. Explanatory Documents:
   Type: report
    - Motivation
    - Process Design
    - Building Schema
    - Final Delivables

Study Note:

Details:

1. List of study notes and keywords
    - note001_MacroHowTo.bas:                    AutoFilter, Call
    - note002_VbaConcepts.bas:                   Worksheet_Activate(), ByVal, Dim, MsgBox, InputBox
    - note003_Variables.bas:                     Set ws = Worksheet("ABC")
    - note004_InputBox_MsgBox.bas:               Applicaiton.InputBox, vbYesNo, WorksheetFunction
    - note005_If_IIf.bas:                        If, ElseIf, IIF, Mod
    - note006_AbsolueVSRelative.bas:             rng.FillDown, rng.FormulaR1C1
    - note007_SelectCase_For.bas:                Select Case, For Next
    - note008_For_Next(Loop).bas:                For Next, End(xlDown).Row
    - note009_Nested_For(Loop).bas:              Nested For
    - note010_Do_While(Loop).bas:                Do While Loop, Do Until
    - note011_For_Each(Loop).bas:                For Each In Next
    - note012_With.bas:                          With Selection
    - note013_String_Functions.bas:              Instr, InStrRev, Lcase/Ucase, Ltrim/Rtrim/Trim, 
                                                 Left/Right, Len, Str, Strcomp, keyword search
    - note014_Numeric&Date_Functions.bas:        Int, Round, Abs, Isnumeric, Val, Rnd, Time, 
                                                 Hour/Minute, Date, Year/Month/Day, Weekday, IsDate, 
                                                 DateAdd, DateDiff, DatePart, DateSerial, IsEmpty
    - note015_Array.bas:                         Option Base 1, a(n), Dim arr As Variant, Resize, Redim
    - note016_Custom_Functions.bas:              Public Function(a As ~, b As ~)
    - note017_Object_&_Property.bas:             Range, Cell, Value, ActiveCell, CurrentRegion, Formula, 
                                                 Borders, Font
    - note018_Object_&_Method.bas:               Clear, Copy, PasteSpecial, Row/Column, Rows/Columns, 
                                                 EntireRow, Count, Val, EntryForm
    - note019_Worksheets_Property_&_Method.bas:  ActiveSheet, Worksheet, Add, Move, Visible, Static i, 
                                                 On Error GoTo
    - note020_Application_Property_&_Method.bas: Application, defaultFilePath, DisplayAlerts, close, 
                                                 SheetInNewWorkbook, StandardFont, Quit, WorksheetFunction, 
                                                 SendKeys, Call Shell, CutCopyMode, Applicaiton.InputBox
    
2. Credit:
    - YouTube "Excel Macro Visual Basic Application" by IB 96