Search this site
Skip to main content
Skip to navigation
Beyond Excel
Home
About
Most Recent Posts
'Appify' Excel Models
Add Forms to Edit Tables
Adding Records to Closed CSVs with VBA, ADO, and SQL
Advanced Excel Modeling
Advanced Excel Modeling - Data Model
Advanced Excel Modeling - Data Synchronization
Advanced Excel Modeling - Data Validation
Advanced Excel Modeling - Getting Dynamic
Advanced Excel Modeling - Integrity Checks
Advanced Excel Modeling - Model Structure
Advanced Excel Modeling - Pivot Charts
Advanced Excel Modeling - Power Pivot
Advanced Excel Modeling - Project Planning
Advanced Excel Modeling - Self Documenting Formulas
Advanced Excel Modeling - Slicers
Advanced Excel Modeling - Styles and Protection
Advanced Excel Modeling - Table Types
Advanced Excel Modeling - Transparency
An Excel Christmas Card and Game
Analyzing Excel Projects
Application Prototyping in Excel - 1095-C
Assigned Responsibility – A Parable
Best Practices: Integrity Checks
Budget Dashboard
BXL Format Add-in
BXL Modeling Helper
BXL Modeling Methods
BXL Quiz Helper Add-in
BXL Scenarios
BXL's AMP Management Console
Calculating Level of Effort (LOE) in Excel
Cisco Call Reporting in Excel
Combining Worksheets
ComboBox Data Validation Add-in
Connection Server Function
Copy Table From Excel to Word
Create Databases With Excel
Create MS Access Database with Excel and VBA
Cursor Control Add-In offers Better Protection
Data Dictionary in VBA - Complete Syntax Documentation
Deleting Headers from Exports to Excel
Documenting Excel Projects
Drag And Drop
Drilldown into Embedded PivotCharts
Drilldown into PivotCharts
Dynamic Forms
Dynamic Properties Form
Dynamic Toolbar
Estimating Projects
Excel Model Transparency Definition and Measure
Excel Timers
Excel, LDAP and Active Directory
Executive Dashboard Must Have Add-In
Exposing System Secrets with VBA and WMI API OLD
Feet and Inches in Excel
Formula Catalog
Free Org Chart Add In
Happy New Year!
How to Determine Object Methods and Properties
Illegal Excel Name Characters
Import/Export XL Tables from/to Databases
Installing and Running Add-Ins
Intro to ADO
Is Excel a Database?
July 4th Trivia Game
Keeping Compatible with Excel 2003
Late vs Early Binding OLD
List Worksheets/Named Ranges in Closed Excel Workbooks w/ADO
Looking into Excel Modeling's Future
MAKE!
Making Excel Crash - ComboBox Updating RowSource ListObject
Making Excel Crash - Validation Gotcha
March Madness
MLOOKUP() - the Easy Mult-Key INDEX()/MATCH()
Modeling Best Practices
MS Access vs Excel
Multi-Cell Array Modelling
Names are Good
Need for Speed
One Timeline to Rule Them All
PapaGantt - The Big Daddy of XL Gantt Charts
Parameterized Power Query
Play Videos in Excel with VBA
Quiz for November
RANKIF
RegEx UDF
Ribbon Recipes
RIP Paper Thinking
Save Sorts, Filters, Column Settings aka Custom Views For Tables
SelRows()
SQL Results to Array: GetRows
SQL: Getting Worksheet Names
SQL: Insert Into Excel
SQL:Read Closed Workbook by Cell Address
Super Bowl LI Trivia Game
Ten Commandments of Excel VBA Programming
Trumping Taxes
UDF: Formula()
UnPivot or Cross Tab Transform Add-In
Using ADO with ListObject's QueryTable
Valentine's Day
Want a Free Gantt Chart App?
Web Scraper
xlDialogAlignment
XLOOKUP() - the Easy Multi-Key VLOOKUP()
What is Beyond Excel?
PowerQuerySnippets
fncGetNameValue
fncCrtTblRows
Parameterized Power Query
fncLookup
fncLarge
fncCombineSheets
Add Values to Column
Add-ins
BXL Integrity Checks
BXL Merge
BXL Format
BXL Org Chart
BXL Views
BXL Tiny Database
BXL PQ Helper
BXL TOC Helper
BXL DAN
BXL Scenarios
5G Modeling
5G Explained
5G: Component Libraries
5G: Amortizeλ
5G: Corkscrewλ
5G: CountDOWλ
5G: CountDOWInMonthλ
5G: Depreciateλ
5G: IntOnIntλ
5G: IsBetweenλ
5G: IsOccurrenceDateλ
5G: OverLapDaysλ()
5G: Periodsλ()
5G: PeriodLabelλ
5G: ScheduleRatesλ()
5G: ScheduleRatesByItemsλ()
5G: ScheduleValuesλ()
5G: ScheduleValuesByItemλ()
5G: Timelineλ()
5G Course
5g: Standards
5G: Source Structure
5G: Self Contained
5G: Documentation
5G: Inline Help
5G: Testing Components
5g: Self Certification
5g: Distribution
VBA Coding
VBA Editor
VBA's 10 Commandments
What can VBA do?
Variables and Naming
Parameters
Template
Error Handling
Workbooks
Range Object
Range Structure
Range Properties
Tables
Arrays
Collections and Dictionaries
User Forms
Classes
AMP Management Console
Late vs Early Binding
Naming Convention
WMI
ADO
Connection Object
GetSchema: List Worksheets and Names
Read Workbook by Cell Address
SQL Insert: Add Records to Closed CSVs
Add Records to Excel
ListObject's QueryTable
Create MS Access Database
Make UDFs Dynamic Array-able
Evaluates Many Forms
Excel Library
10 Rational Risk Measures
Illegal Excel Name Characters
Estimating Projects
Dynamic Arrays, AND(), OR()
Modules (Gists)
GIST: Reshape Arrays
LAMBDA: Advanced Formula Environment
LAMBDA: CreateStartDatesλ
LAMBDA: CreateEndDatesλ
LAMBDA:IsOccuranceDateλ
LAMBDA: ScheduleValuesλ
LAMBDA: SumColumnsλ
LAMBDA: SumRowsλ
LAMBDA: SumPeriodsλ
n-Fold Cartesian Formula
Module: Dynamic Ranges
LAMBDA: CBSE Template
VBA Library
Procedures
ArrayDimensions()
Collection2CSV()
Color()
CrtPQt()
DspErrMsg()
Exists()
OLEDBs()
Tables()
Amt2Wrd()
UserForms
ShowDataForm
frmProgress
frmSel
Class Modules
clsForm()
clsSettings()
clsCht()
TBM Modeling
Terms
Business Guide
Products and Services
Partner Acquisition
Customer Acquisition
Professional vs Amateur
Project Planning
SDLC
Project Initiation
Research
Analysis
Design
Development
Testing
Implementation
Maintenance
TBM Examples
Financial Modeling Context
MDM
MDM: TBM
MDM: DM
MDM: PQ
MDM: DA
MDM: LAMBDA
Amortization Schedule
TBM & DAs+
TBM Course
Tables
Tables:Introduction
Model Structure
Sample Financial Model
Inputs Section: Constants Worksheet
Inputs Section: Import Worksheet
Inputs Section: End User Entries
Budget
Budget: Design
Budget: Inputs
Budget: Calculations
Budget: Transformation
Budget: Hierarchies
Budget: Measures
Budget: Aggregations
Budget: Analytics
Process Section: Page 1
Interactive Outputs
Data Model
PowerPivot
Pivot Charts
Slicers
Eliminating Day Sync Errors
Model Transparency
Entry Validation
Self-Documenting Formulas
Dynamic Modeling
Table Types
Model Integrity Checks
Dynamic Modeling w/Power Query
Dynamic Modeling w/VBA
Model Metrics
Appendix
General Principals
Styles and Protection
Cell References and Naming
Frequently Used Formulas
Process Section: Page 2
Proverbs
5G: Validating Function Arguments
LET and Functional Decomposition
Beyond Excel
Home
About
Most Recent Posts
'Appify' Excel Models
Add Forms to Edit Tables
Adding Records to Closed CSVs with VBA, ADO, and SQL
Advanced Excel Modeling
Advanced Excel Modeling - Data Model
Advanced Excel Modeling - Data Synchronization
Advanced Excel Modeling - Data Validation
Advanced Excel Modeling - Getting Dynamic
Advanced Excel Modeling - Integrity Checks
Advanced Excel Modeling - Model Structure
Advanced Excel Modeling - Pivot Charts
Advanced Excel Modeling - Power Pivot
Advanced Excel Modeling - Project Planning
Advanced Excel Modeling - Self Documenting Formulas
Advanced Excel Modeling - Slicers
Advanced Excel Modeling - Styles and Protection
Advanced Excel Modeling - Table Types
Advanced Excel Modeling - Transparency
An Excel Christmas Card and Game
Analyzing Excel Projects
Application Prototyping in Excel - 1095-C
Assigned Responsibility – A Parable
Best Practices: Integrity Checks
Budget Dashboard
BXL Format Add-in
BXL Modeling Helper
BXL Modeling Methods
BXL Quiz Helper Add-in
BXL Scenarios
BXL's AMP Management Console
Calculating Level of Effort (LOE) in Excel
Cisco Call Reporting in Excel
Combining Worksheets
ComboBox Data Validation Add-in
Connection Server Function
Copy Table From Excel to Word
Create Databases With Excel
Create MS Access Database with Excel and VBA
Cursor Control Add-In offers Better Protection
Data Dictionary in VBA - Complete Syntax Documentation
Deleting Headers from Exports to Excel
Documenting Excel Projects
Drag And Drop
Drilldown into Embedded PivotCharts
Drilldown into PivotCharts
Dynamic Forms
Dynamic Properties Form
Dynamic Toolbar
Estimating Projects
Excel Model Transparency Definition and Measure
Excel Timers
Excel, LDAP and Active Directory
Executive Dashboard Must Have Add-In
Exposing System Secrets with VBA and WMI API OLD
Feet and Inches in Excel
Formula Catalog
Free Org Chart Add In
Happy New Year!
How to Determine Object Methods and Properties
Illegal Excel Name Characters
Import/Export XL Tables from/to Databases
Installing and Running Add-Ins
Intro to ADO
Is Excel a Database?
July 4th Trivia Game
Keeping Compatible with Excel 2003
Late vs Early Binding OLD
List Worksheets/Named Ranges in Closed Excel Workbooks w/ADO
Looking into Excel Modeling's Future
MAKE!
Making Excel Crash - ComboBox Updating RowSource ListObject
Making Excel Crash - Validation Gotcha
March Madness
MLOOKUP() - the Easy Mult-Key INDEX()/MATCH()
Modeling Best Practices
MS Access vs Excel
Multi-Cell Array Modelling
Names are Good
Need for Speed
One Timeline to Rule Them All
PapaGantt - The Big Daddy of XL Gantt Charts
Parameterized Power Query
Play Videos in Excel with VBA
Quiz for November
RANKIF
RegEx UDF
Ribbon Recipes
RIP Paper Thinking
Save Sorts, Filters, Column Settings aka Custom Views For Tables
SelRows()
SQL Results to Array: GetRows
SQL: Getting Worksheet Names
SQL: Insert Into Excel
SQL:Read Closed Workbook by Cell Address
Super Bowl LI Trivia Game
Ten Commandments of Excel VBA Programming
Trumping Taxes
UDF: Formula()
UnPivot or Cross Tab Transform Add-In
Using ADO with ListObject's QueryTable
Valentine's Day
Want a Free Gantt Chart App?
Web Scraper
xlDialogAlignment
XLOOKUP() - the Easy Multi-Key VLOOKUP()
What is Beyond Excel?
PowerQuerySnippets
fncGetNameValue
fncCrtTblRows
Parameterized Power Query
fncLookup
fncLarge
fncCombineSheets
Add Values to Column
Add-ins
BXL Integrity Checks
BXL Merge
BXL Format
BXL Org Chart
BXL Views
BXL Tiny Database
BXL PQ Helper
BXL TOC Helper
BXL DAN
BXL Scenarios
5G Modeling
5G Explained
5G: Component Libraries
5G: Amortizeλ
5G: Corkscrewλ
5G: CountDOWλ
5G: CountDOWInMonthλ
5G: Depreciateλ
5G: IntOnIntλ
5G: IsBetweenλ
5G: IsOccurrenceDateλ
5G: OverLapDaysλ()
5G: Periodsλ()
5G: PeriodLabelλ
5G: ScheduleRatesλ()
5G: ScheduleRatesByItemsλ()
5G: ScheduleValuesλ()
5G: ScheduleValuesByItemλ()
5G: Timelineλ()
5G Course
5g: Standards
5G: Source Structure
5G: Self Contained
5G: Documentation
5G: Inline Help
5G: Testing Components
5g: Self Certification
5g: Distribution
VBA Coding
VBA Editor
VBA's 10 Commandments
What can VBA do?
Variables and Naming
Parameters
Template
Error Handling
Workbooks
Range Object
Range Structure
Range Properties
Tables
Arrays
Collections and Dictionaries
User Forms
Classes
AMP Management Console
Late vs Early Binding
Naming Convention
WMI
ADO
Connection Object
GetSchema: List Worksheets and Names
Read Workbook by Cell Address
SQL Insert: Add Records to Closed CSVs
Add Records to Excel
ListObject's QueryTable
Create MS Access Database
Make UDFs Dynamic Array-able
Evaluates Many Forms
Excel Library
10 Rational Risk Measures
Illegal Excel Name Characters
Estimating Projects
Dynamic Arrays, AND(), OR()
Modules (Gists)
GIST: Reshape Arrays
LAMBDA: Advanced Formula Environment
LAMBDA: CreateStartDatesλ
LAMBDA: CreateEndDatesλ
LAMBDA:IsOccuranceDateλ
LAMBDA: ScheduleValuesλ
LAMBDA: SumColumnsλ
LAMBDA: SumRowsλ
LAMBDA: SumPeriodsλ
n-Fold Cartesian Formula
Module: Dynamic Ranges
LAMBDA: CBSE Template
VBA Library
Procedures
ArrayDimensions()
Collection2CSV()
Color()
CrtPQt()
DspErrMsg()
Exists()
OLEDBs()
Tables()
Amt2Wrd()
UserForms
ShowDataForm
frmProgress
frmSel
Class Modules
clsForm()
clsSettings()
clsCht()
TBM Modeling
Terms
Business Guide
Products and Services
Partner Acquisition
Customer Acquisition
Professional vs Amateur
Project Planning
SDLC
Project Initiation
Research
Analysis
Design
Development
Testing
Implementation
Maintenance
TBM Examples
Financial Modeling Context
MDM
MDM: TBM
MDM: DM
MDM: PQ
MDM: DA
MDM: LAMBDA
Amortization Schedule
TBM & DAs+
TBM Course
Tables
Tables:Introduction
Model Structure
Sample Financial Model
Inputs Section: Constants Worksheet
Inputs Section: Import Worksheet
Inputs Section: End User Entries
Budget
Budget: Design
Budget: Inputs
Budget: Calculations
Budget: Transformation
Budget: Hierarchies
Budget: Measures
Budget: Aggregations
Budget: Analytics
Process Section: Page 1
Interactive Outputs
Data Model
PowerPivot
Pivot Charts
Slicers
Eliminating Day Sync Errors
Model Transparency
Entry Validation
Self-Documenting Formulas
Dynamic Modeling
Table Types
Model Integrity Checks
Dynamic Modeling w/Power Query
Dynamic Modeling w/VBA
Model Metrics
Appendix
General Principals
Styles and Protection
Cell References and Naming
Frequently Used Formulas
Process Section: Page 2
Proverbs
5G: Validating Function Arguments
LET and Functional Decomposition
More
Home
About
Most Recent Posts
'Appify' Excel Models
Add Forms to Edit Tables
Adding Records to Closed CSVs with VBA, ADO, and SQL
Advanced Excel Modeling
Advanced Excel Modeling - Data Model
Advanced Excel Modeling - Data Synchronization
Advanced Excel Modeling - Data Validation
Advanced Excel Modeling - Getting Dynamic
Advanced Excel Modeling - Integrity Checks
Advanced Excel Modeling - Model Structure
Advanced Excel Modeling - Pivot Charts
Advanced Excel Modeling - Power Pivot
Advanced Excel Modeling - Project Planning
Advanced Excel Modeling - Self Documenting Formulas
Advanced Excel Modeling - Slicers
Advanced Excel Modeling - Styles and Protection
Advanced Excel Modeling - Table Types
Advanced Excel Modeling - Transparency
An Excel Christmas Card and Game
Analyzing Excel Projects
Application Prototyping in Excel - 1095-C
Assigned Responsibility – A Parable
Best Practices: Integrity Checks
Budget Dashboard
BXL Format Add-in
BXL Modeling Helper
BXL Modeling Methods
BXL Quiz Helper Add-in
BXL Scenarios
BXL's AMP Management Console
Calculating Level of Effort (LOE) in Excel
Cisco Call Reporting in Excel
Combining Worksheets
ComboBox Data Validation Add-in
Connection Server Function
Copy Table From Excel to Word
Create Databases With Excel
Create MS Access Database with Excel and VBA
Cursor Control Add-In offers Better Protection
Data Dictionary in VBA - Complete Syntax Documentation
Deleting Headers from Exports to Excel
Documenting Excel Projects
Drag And Drop
Drilldown into Embedded PivotCharts
Drilldown into PivotCharts
Dynamic Forms
Dynamic Properties Form
Dynamic Toolbar
Estimating Projects
Excel Model Transparency Definition and Measure
Excel Timers
Excel, LDAP and Active Directory
Executive Dashboard Must Have Add-In
Exposing System Secrets with VBA and WMI API OLD
Feet and Inches in Excel
Formula Catalog
Free Org Chart Add In
Happy New Year!
How to Determine Object Methods and Properties
Illegal Excel Name Characters
Import/Export XL Tables from/to Databases
Installing and Running Add-Ins
Intro to ADO
Is Excel a Database?
July 4th Trivia Game
Keeping Compatible with Excel 2003
Late vs Early Binding OLD
List Worksheets/Named Ranges in Closed Excel Workbooks w/ADO
Looking into Excel Modeling's Future
MAKE!
Making Excel Crash - ComboBox Updating RowSource ListObject
Making Excel Crash - Validation Gotcha
March Madness
MLOOKUP() - the Easy Mult-Key INDEX()/MATCH()
Modeling Best Practices
MS Access vs Excel
Multi-Cell Array Modelling
Names are Good
Need for Speed
One Timeline to Rule Them All
PapaGantt - The Big Daddy of XL Gantt Charts
Parameterized Power Query
Play Videos in Excel with VBA
Quiz for November
RANKIF
RegEx UDF
Ribbon Recipes
RIP Paper Thinking
Save Sorts, Filters, Column Settings aka Custom Views For Tables
SelRows()
SQL Results to Array: GetRows
SQL: Getting Worksheet Names
SQL: Insert Into Excel
SQL:Read Closed Workbook by Cell Address
Super Bowl LI Trivia Game
Ten Commandments of Excel VBA Programming
Trumping Taxes
UDF: Formula()
UnPivot or Cross Tab Transform Add-In
Using ADO with ListObject's QueryTable
Valentine's Day
Want a Free Gantt Chart App?
Web Scraper
xlDialogAlignment
XLOOKUP() - the Easy Multi-Key VLOOKUP()
What is Beyond Excel?
PowerQuerySnippets
fncGetNameValue
fncCrtTblRows
Parameterized Power Query
fncLookup
fncLarge
fncCombineSheets
Add Values to Column
Add-ins
BXL Integrity Checks
BXL Merge
BXL Format
BXL Org Chart
BXL Views
BXL Tiny Database
BXL PQ Helper
BXL TOC Helper
BXL DAN
BXL Scenarios
5G Modeling
5G Explained
5G: Component Libraries
5G: Amortizeλ
5G: Corkscrewλ
5G: CountDOWλ
5G: CountDOWInMonthλ
5G: Depreciateλ
5G: IntOnIntλ
5G: IsBetweenλ
5G: IsOccurrenceDateλ
5G: OverLapDaysλ()
5G: Periodsλ()
5G: PeriodLabelλ
5G: ScheduleRatesλ()
5G: ScheduleRatesByItemsλ()
5G: ScheduleValuesλ()
5G: ScheduleValuesByItemλ()
5G: Timelineλ()
5G Course
5g: Standards
5G: Source Structure
5G: Self Contained
5G: Documentation
5G: Inline Help
5G: Testing Components
5g: Self Certification
5g: Distribution
VBA Coding
VBA Editor
VBA's 10 Commandments
What can VBA do?
Variables and Naming
Parameters
Template
Error Handling
Workbooks
Range Object
Range Structure
Range Properties
Tables
Arrays
Collections and Dictionaries
User Forms
Classes
AMP Management Console
Late vs Early Binding
Naming Convention
WMI
ADO
Connection Object
GetSchema: List Worksheets and Names
Read Workbook by Cell Address
SQL Insert: Add Records to Closed CSVs
Add Records to Excel
ListObject's QueryTable
Create MS Access Database
Make UDFs Dynamic Array-able
Evaluates Many Forms
Excel Library
10 Rational Risk Measures
Illegal Excel Name Characters
Estimating Projects
Dynamic Arrays, AND(), OR()
Modules (Gists)
GIST: Reshape Arrays
LAMBDA: Advanced Formula Environment
LAMBDA: CreateStartDatesλ
LAMBDA: CreateEndDatesλ
LAMBDA:IsOccuranceDateλ
LAMBDA: ScheduleValuesλ
LAMBDA: SumColumnsλ
LAMBDA: SumRowsλ
LAMBDA: SumPeriodsλ
n-Fold Cartesian Formula
Module: Dynamic Ranges
LAMBDA: CBSE Template
VBA Library
Procedures
ArrayDimensions()
Collection2CSV()
Color()
CrtPQt()
DspErrMsg()
Exists()
OLEDBs()
Tables()
Amt2Wrd()
UserForms
ShowDataForm
frmProgress
frmSel
Class Modules
clsForm()
clsSettings()
clsCht()
TBM Modeling
Terms
Business Guide
Products and Services
Partner Acquisition
Customer Acquisition
Professional vs Amateur
Project Planning
SDLC
Project Initiation
Research
Analysis
Design
Development
Testing
Implementation
Maintenance
TBM Examples
Financial Modeling Context
MDM
MDM: TBM
MDM: DM
MDM: PQ
MDM: DA
MDM: LAMBDA
Amortization Schedule
TBM & DAs+
TBM Course
Tables
Tables:Introduction
Model Structure
Sample Financial Model
Inputs Section: Constants Worksheet
Inputs Section: Import Worksheet
Inputs Section: End User Entries
Budget
Budget: Design
Budget: Inputs
Budget: Calculations
Budget: Transformation
Budget: Hierarchies
Budget: Measures
Budget: Aggregations
Budget: Analytics
Process Section: Page 1
Interactive Outputs
Data Model
PowerPivot
Pivot Charts
Slicers
Eliminating Day Sync Errors
Model Transparency
Entry Validation
Self-Documenting Formulas
Dynamic Modeling
Table Types
Model Integrity Checks
Dynamic Modeling w/Power Query
Dynamic Modeling w/VBA
Model Metrics
Appendix
General Principals
Styles and Protection
Cell References and Naming
Frequently Used Formulas
Process Section: Page 2
Proverbs
5G: Validating Function Arguments
LET and Functional Decomposition
Dynamic Modeling
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse
