Blog

>Blog

Excel Modeling in 2024

Modeling Dynamic Excel in 2024 for Business It is February 2024 and the solutions I am developing right now will for my business clients will most likely be outdated within the year.  Why?  Because the Microsoft Excel Team has been making so many monumental changes in Excel, that Excel 365 is now called "Dynamic Excel".  [...]

Excel Tables versus Access Database

Recent Microsoft Excel Tables Project Where we used Excel Tables instead of an Access Database We recently completed an Excel Development project for a custom guitar builder.  The Excel solution was mostly built with Excel Tables.  Lots of Excel Tables.  The Tables provided the data structure we needed, to build a semi-relational database, in Microsoft [...]

Dynamic Excel Changes in 2023

Changes Continued in Dynamic Excel # in 2023 I am sitting on a train, looking out the window at the Pacific Ocean, as I make my way to Santa Barbara to celebrate the Christmas holiday with family. Nothing to do for the next 5 hours.  Given that the year is coming to an end, this [...]

Effectively using Named Ranges in Excel Programming

Effectively Using Named Ranges Simplifies Excel Programming One of the most underutilized advanced features of Microsoft Excel is Named Ranges.  Properly using Named Ranges makes programming Microsoft Excel much easier.  They make understanding Excel functions, and what they are trying to calculate, more understandable.  Efficiently using Named Ranges in Excel simplifies Excel programming, we suggest [...]

Excel Dynamic Array Functions for Dashboard Reporting

Excel Dynamic Arrays for Dashboard Reporting Everyone reading this has most likely heard of Excel Dashboards.  If you are an Excel programmer, you should have heard of the new Dynamic Array Functions.  Knowing how to properly leverage these functions will greatly simplify your Excel programming.  Here we show how to use a few of the [...]

Remote One-On-One Microsoft Excel Training

Remote One-On-One Microsoft Excel Training   Personalized One-On-One Excel Training When it comes to learning Microsoft Excel, remote one-on-one Microsoft Excel training is the best way to learn Microsoft Excel.   There literally is no faster or more effective way to learn Microsoft Excel than doing it one-on-one, how could there be?  It is you, the [...]

Intermediate One-On-One Excel Training

Intermediate One-On-One Excel Training When it comes to intermediate Excel training, remote one-on-one training is simply the best way to learn Excel.  For one, you don't have to leave the house.  Secondly, it is you, the instructor, and your Excel file.  No distractions, no other students, just you and our Excel expert.   Thirdly, this is [...]

Beginner One-On-One Excel Training

Beginner One-On-One Excel Training When it comes to learning Microsoft Excel, remote one-on-one training is the best way to learn.  There literally is no faster or more effective way to learn Excel.  With Beginner One-On-One Excel Training You work directly with an expert Excel instructor, focused on you and your needs. All of our Excel [...]

Dynamic Array Functions Simplify Excel Programming

Microsoft Excel's New Dynamic Array Functions Simplify Excel Programming The Microsoft Corporation is on a tear!  First, it rebuilt Excel's Calculation Engine in 2018.  Then it released a series of new Dynamic Array Functions for Office 365 in 2020.   Microsoft's Dynamic Array Functions simplify Excel Programming. =SORT(FILTER(CHOOSECOLS(rangeEmployeeData,1,2,3,4,5,6,7),AgeColumn>AgeSelection),3,1)   Microsoft's Dynamic Array Functions are a Game [...]

Xlookup Built-In Offset Functions use with Messy PDF Data

Xlookup Built-In Offset Functions Use w/ Messy PDF Data   Microsoft Excel Prefers Clean Data Tables: Businesses often find themselves programmatically importing data into Excel from a PDF data file.  The Excel Xlookup's Built-In Offset Functions use with Messy PDF Data.   When you do this, which formulas you are able to use to extract the [...]