Techniques

Doug Bates

Apr 2, 20225 min read

What, more LAMBDA/LET?

Doug Bates

Feb 14, 20227 min read

New LAMBDA Function

Doug Bates

Oct 6, 202110 min read

Visual Basic for Applications (Alt+F11)

Doug Bates

Sep 29, 20213 min read

Error Checking (Alt-M,K,K) and Formula Auditing

Doug Bates

Sep 22, 20212 min read

Protect Sheet (Alt-H,O,P)

Doug Bates

Sep 15, 20214 min read

Data Validation (Alt-A,V,V)

Doug Bates

Sep 8, 20219 min read

Controls (Alt-L,I)

Doug Bates

Sep 1, 202111 min read

Name Manager (Ctrl+F3)

Doug Bates

Aug 25, 202112 min read

Tables (Alt-H,T)

Doug Bates

Aug 18, 20217 min read

Functions (Shift+F3) and Formulas

Doug Bates

Aug 11, 20215 min read

Templates (Alt-F,N)

Doug Bates

Jul 27, 20219 min read

Conditional Formatting (Alt-H,L)

Doug Bates

Jul 27, 202112 min read

Formatting (Ctrl+1)

Doug Bates

Jul 27, 20217 min read

What, more LAMBDA/LET?

New LAMBDA Function

Visual Basic for Applications (Alt+F11)

Error Checking (Alt-M,K,K) and Formula Auditing

Protect Sheet (Alt-H,O,P)

Data Validation (Alt-A,V,V)

Controls (Alt-L,I)

Name Manager (Ctrl+F3)

Tables (Alt-H,T)

Functions (Shift+F3) and Formulas

Templates (Alt-F,N)

Conditional Formatting (Alt-H,L)

Formatting (Ctrl+1)

Navigation