Teaching analytics with modern Excel
Among the numerous exciting features that Copilot is set to introduce for Excel, one significant requirement is that Excel data must be organized in tables. This is crucial because Copilot will not …
Continue Reading about Copilot for Excel: How to format data →
openpyxlExcel's popularity is attributed to its user-friendly data formatting and presentation features. Although Python offers distinct advantages for Excel, its raw data output is often unsuitable for …
Continue Reading about How to format a column as percentage in Excel using openpyxl →
When exploring a workbook, I like to color-code cells so that I remember what I need to do with that information. Red cells indicate I need to take action on something, while green means all …
Continue Reading about Assign Cell Color Fills to Custom Keyboard Shortcuts in Excel →
This summer I am taking a course on measurement theory ... which is as difficult as it sounds. But one of the complications of the course has little to do with sophisticated statistics or management …
Continue Reading about Excel Conditional Formatting for Statistical Significance →
Another quick formatting tip: Ctrl + Shift + _ will erase all border formatting from selected cells in Excel. …
I love PivotTables because they do all the "data housework" for me, allowing me to analyze data rather than gather, manage, and format it.One undesirable feature of the PivotTable is how it treats …
Continue Reading about PivotTables: Replace Blanks with Zeros →
