Audit hidden data, filters, and hard-coded values to ensure your Excel spreadsheets are professional and precise.

LAMBDA defines the custom logic, and SCAN moves that logic through your data range.

See how try and otherwise protect custom column math from type errors in Power Query, saving time and keeping your refresh ...

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it ...

Ryan Eichler holds a B.S.B.A with a concentration in Finance from Boston University. He has held positions in, and has deep experience with, expense auditing, personal finance, real estate, as well as ...