Create a CRM using Excel with dropdown customer selection and FILTER plus XLOOKUP, saving time while keeping leads and deals organized.

Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.

Power Query is great for filtering data before it gets loaded into Excel, and when you do that you often need to provide a friendly way for end users to choose what data gets loaded exactly. I showed ...

ExcelGen is a PL/SQL utility to create Excel files (.xlsx, .xlsb) out of SQL data sources (query strings or cursors), with automatic pagination over multiple sheets. It supports encryption, cell ...

NOTE: This post was written before Data Explorer was renamed as Power Query. All of the content is still relevant to Power Query. One of the first questions I get asked after showing someone ...

Have you found this content useful? Use the button above to save it to your profile. Following his first tutorial on how to set up MS Query and the Sage ODBC drivers, David Carter's second tutorial ...

OLE DB settings that enable Microsoft Excel to connect to an OLE DB data source ODBC settings that enable Excel to connect to an ODBC data source A URL that enables Excel to connect to a web data ...