PinnedKathryn DeanLittle data, big analyticsA framework to bring big data maturity to your spreadsheets. For anyone wanting to improve their data management & better answer questions.Feb 13Feb 13
Kathryn DeanMy favorite spreadsheet formulas & formula combosThere are several formulas that I find myself returning to. They can be used in both Google Sheets & Excel!Mar 30Mar 30
Kathryn DeanUnpivoting data in Excel & Google Sheets“Unpivoting” is the opposite of “pivoting” data. Data typically needs to be in an unpivoted/flattened format for analysis — learn how here!Mar 24Mar 24
Kathryn DeanAn intro to PowerQueryIt is my great honor to introduce you to PowerQuery — one of my favorite tools for automating data work. It’s built right into Excel…Mar 24Mar 24
Kathryn DeanUsing AI for data prep & analysisBenefits of using AI, like Florence GPT, for spreadsheet data management & analysis along with practical prompts to use in your analysis!Mar 10Mar 10
Kathryn DeanThe essentials of data cleaningThis article is for anyone doing data work and analytics in a spreadsheet, who’s trying to learn more about how to clean their data or what…Feb 15Feb 15
Kathryn DeanStructuring data in a spreadsheetThis article is for anyone doing data work and analytics in a spreadsheet, who’s trying to learn more about how to structure their data or…Feb 12Feb 12