Legacy Site
Looking into Excel Modeling's Future — Nov 19, 2020 2:07:22 AM
SQL: Getting Worksheet Names — Nov 3, 2020 7:21:40 PM
SQL:Read Closed Workbook by Cell Address — Nov 3, 2020 6:40:04 PM
Excel Timers — Sep 8, 2020 5:44:28 PM
Best Practices: Integrity Checks — Sep 2, 2020 4:32:07 PM
BXL Scenarios — Jul 9, 2020 2:34:18 PM
Budget Dashboard — Mar 19, 2020 6:33:01 PM
Ribbon Recipes — Jun 27, 2019 8:56:22 PM
Cisco Call Reporting in Excel — Feb 14, 2019 10:16:59 PM
BXL Naming Convention — Feb 13, 2019 7:35:25 PM
Advanced Excel Modeling - Power Pivot — Sep 17, 2018 11:47:58 PM
Advanced Excel Modeling - Pivot Charts — Aug 24, 2018 1:24:09 PM
Advanced Excel Modeling - Slicers — Aug 10, 2018 10:11:49 PM
Advanced Excel Modeling - Data Model — Aug 3, 2018 9:32:49 PM
Advanced Excel Modeling - Integrity Checks — Jul 28, 2018 12:44:34 AM
Advanced Excel Modeling - Table Types — Jul 24, 2018 10:39:46 PM
Advanced Excel Modeling - Getting Dynamic — Jul 22, 2018 2:24:02 AM
BXL Format Add-in — Jul 21, 2018 1:35:20 AM
Advanced Excel Modeling - Self Documenting Formulas — Jul 19, 2018 11:05:00 PM
Advanced Excel Modeling - Styles and Protection — Jul 19, 2018 3:00:55 AM
Advanced Excel Modeling - Data Validation — Jul 17, 2018 12:02:17 AM
Advanced Excel Modeling - Data Synchronization — Jul 14, 2018 5:40:23 PM
Advanced Excel Modeling - Transparency — Jul 14, 2018 3:34:05 PM
Advanced Excel Modeling - Model Structure — Jul 14, 2018 1:26:01 PM
Advanced Excel Modeling — Jul 14, 2018 12:59:34 PM
Advanced Excel Modeling - Project Planning — Jul 11, 2018 12:19:24 AM
Parameterized Power Query — Apr 12, 2018 9:16:44 PM
Analyzing Excel Projects — Jan 25, 2018 2:16:13 AM
Documenting Excel Projects — Jan 6, 2018 11:29:47 PM
An Excel Christmas Card and Game — Dec 22, 2017 1:03:29 PM
Need for Speed — Dec 21, 2017 3:10:55 AM
MLOOKUP() - the Easy Mult-Key INDEX()/MATCH() — Dec 11, 2017 9:51:40 PM
XLOOKUP() - the Easy Multi-Key VLOOKUP() — Dec 8, 2017 2:55:25 PM
[Evaluate] — Nov 14, 2017 10:36:11 PM
MAKE! — Oct 23, 2017 6:33:12 PM
Save Sorts, Filters, Column Settings aka Custom Views For Tables — Jul 19, 2017 1:44:52 PM
July 4th Trivia Game — Jun 30, 2017 12:33:19 PM
BXL's AMP Management Console — Apr 23, 2017 1:31:03 AM
March Madness — Feb 26, 2017 2:11:12 AM
RegEx UDF — Jan 31, 2017 10:22:27 PM
Super Bowl LI Trivia Game — Jan 31, 2017 6:16:53 PM
Valentine's Day — Jan 31, 2017 3:20:30 PM
Drag And Drop — Jan 30, 2017 5:38:34 PM
Happy New Year! — Dec 30, 2016 6:50:41 PM
Installing and Running Add-Ins — Nov 23, 2016 8:44:39 PM
BXL Quiz Helper Add-in — Nov 18, 2016 2:34:12 AM
Quiz for November — Nov 7, 2016 6:26:46 PM
Excel Model Transparency Definition and Measure — Nov 4, 2016 3:29:25 PM
Multi-Cell Array Modelling — Oct 26, 2016 2:13:56 PM
One Timeline to Rule Them All — Oct 19, 2016 6:21:44 PM
Modeling Best Practices — Oct 7, 2016 1:50:18 PM
Trumping Taxes — Oct 4, 2016 11:40:48 PM
Illegal Excel Name Characters — Sep 25, 2016 2:59:12 AM
BXL Modeling Helper — Sep 20, 2016 7:24:06 PM
Assigned Responsibility – A Parable — Sep 20, 2016 4:25:53 PM
Names are Good — Sep 19, 2016 2:03:31 PM
RIP Paper Thinking — Aug 11, 2016 5:54:42 PM
10 Rational Risk Measures — Jul 26, 2016 12:44:00 PM
Create Databases With Excel — Jun 23, 2016 1:30:24 AM
Estimating Projects — Jun 2, 2016 5:23:26 PM
BXL Modeling Methods — May 17, 2016 2:08:39 PM
Formula Catalog — May 11, 2016 2:55:14 PM
'Appify' Excel Models — Apr 12, 2016 1:35:20 PM
Dynamic Properties Form — Apr 6, 2016 5:52:34 PM
Application Prototyping in Excel - 1095-C — Apr 5, 2016 7:14:38 PM
Deleting Headers from Exports to Excel — Jan 10, 2016 5:57:27 AM
RANKIF — Jan 5, 2016 11:04:25 PM
ComboBox Data Validation Add-in — Jan 1, 2016 4:51:20 PM
Calculating Level of Effort (LOE) in Excel — Dec 29, 2015 11:06:23 PM
Feet and Inches in Excel — Dec 28, 2015 10:15:14 PM
Copy Table From Excel to Word — Dec 28, 2015 2:45:29 PM
Web Scraper — Nov 7, 2015 8:18:19 PM
Excel, LDAP and Active Directory — Aug 17, 2015 12:23:24 PM
Intro to ADO — Aug 13, 2015 3:56:07 PM
"Classy" Excel UserForms — Jul 11, 2015 1:34:24 PM
SQL: Insert Into Excel — May 2, 2015 12:47:36 PM
Create MS Access Database with Excel and VBA — Mar 17, 2015 3:03:11 PM
Free Org Chart Add In — Feb 1, 2015 3:52:52 AM
Executive Dashboard Must Have Add-In — Oct 20, 2014 5:53:14 PM
Cursor Control Add-In offers Better Protection — Sep 22, 2014 1:01:35 PM
Dynamic Toolbar — Aug 31, 2014 12:32:44 AM
SelRows() — Aug 15, 2014 4:36:40 PM
UnPivot or Cross Tab Transform Add-In — Jul 12, 2014 4:12:14 AM
Import/Export XL Tables from/to Databases — Jun 13, 2014 6:59:01 PM
Combining Worksheets — Jun 8, 2014 6:51:24 PM
Dynamic Forms — May 15, 2014 6:32:39 PM
Is Excel a Database? — Feb 14, 2014 10:18:23 PM
Exposing System Secrets with VBA and WMI API — Dec 23, 2013 2:23:05 PM
Connection Server Function — Dec 18, 2013 5:05:45 PM
Ten Commandments of Excel VBA Programming — Dec 18, 2013 1:59:06 PM
Connection Object Introduction — Dec 12, 2013 10:52:41 PM
List Worksheets/Named Ranges in Closed Excel Workbooks w/ADO — Dec 8, 2013 9:35:28 PM
How to Determine Object Methods and Properties — Dec 3, 2013 1:09:26 PM
Play Videos in Excel with VBA — Nov 29, 2013 8:52:53 PM
PapaGantt - The Big Daddy of XL Gantt Charts — Nov 5, 2013 11:55:03 PM
SQL Results to Array: GetRows — Oct 22, 2013 9:30:57 PM
Data Dictionary in VBA - Complete Syntax Documentation — Sep 30, 2013 6:53:07 PM
Want a Free Gantt Chart App? — Aug 29, 2013 7:28:29 PM
Making Excel Crash - ComboBox Updating RowSource ListObject — Aug 5, 2013 7:09:22 PM
Adding Records to Closed CSVs with VBA, ADO, and SQL — Jun 2, 2013 11:38:03 PM
Keeping Compatible with Excel 2003 — May 21, 2013 6:28:58 PM
Late vs Early Binding — May 16, 2013 1:34:26 PM
UDF: Formula() — May 14, 2013 6:59:04 PM
Using ADO with ListObject's QueryTable — Feb 9, 2013 4:35:28 PM
MS Access vs Excel — Jan 29, 2013 3:43:44 PM
Making Excel Crash - Validation Gotcha — Nov 29, 2012 2:18:35 AM
xlDialogAlignment — Oct 26, 2012 9:19:31 PM
Add Forms to Edit Tables — Oct 10, 2012 1:17:31 PM
Drilldown into Embedded PivotCharts — Oct 20, 2009 5:41:11 AM
Drilldown into PivotCharts — Oct 20, 2009 4:47:51 AM