Excel is Pretty Dang Cool

The article discusses various features and functionalities in Excel that make it an impressive tool for data analysis and manipulation. These include the ability to assign names to cells and ranges, create custom formulas using LET and LAMBDA, use Flash fill to automatically fill in data based on patterns, maintain good data provenance through Power Query, and even perform APL-like operations with spillover arrays. The author also highlights some miscellaneous features such as the constraint solver, sheet moving and copying between files, linked data types, 3D globe map generation, and image conversion. He recommends exploring these features to enhance one’s productivity and efficiency while using Excel.