I’m surprised to see no mention of the LET function for making formulas more readable.
Another glaring omission is Power Query in Excel. I find it incredibly useful for connecting to data sources and transforming data. It’s easily auditable as it produces steps of code for table transformations rather than working with thousands of cells with individual formulas.
When it comes to writing about spreadsheets, it’s just about impossible to even skim the surface without missing anything, especially considering many aspects like array formulas, VBA macros, pivot tables with DAX measures, and Power Query can go super deep. I own a 758-page textbook just on Power Query and multiple books on Power Pivot / DAX.
I’m surprised to see no mention of theLET functionfor making formulas more readable.Another glaring omission is Power Query in Excel. I find it incredibly useful for connecting to data sources and transforming data. It’s easily auditable as it produces steps of code for table transformations rather than working with thousands of cells with individual formulas.
When it comes to writing about spreadsheets, it’s just about impossible to even skim the surface without missing anything, especially considering many aspects like array formulas, VBA macros, pivot tables with DAX measures, and Power Query can go super deep. I own a 758-page textbook just on Power Query and multiple books on Power Pivot / DAX.
They’re mentioned in the companion piece (Google Docs) linked at the bottom of this post. This isn’t the full post.
Ah, I do see the LET function now but I still can’t find a reference to the Power Query editor.
True, but that’s because the author is writing about working with Google Sheets, not Excel.
Ah, I was under the impression that OP was covering both, not only things relevant to Google Sheets.