Teaching analytics with modern Excel
The integration of Python into Excel marks one of the most thrilling advancements for the application in recent times. This feature offers Excel users a multitude of straightforward and rapid …
Continue Reading about How to insert a Python cell into your Excel worksheet (three ways) →
Probably one of the most thriving niches of the "learn Excel" industry is to memorize keyboard shortcuts. The idea is that using a mouse is slow and inefficient. Keyboard shortcuts can speed up your …
Continue Reading about Excel users need to do this before memorizing keyboard shortcuts →
As a blogger and curriculum developer, I am often writing about R from a text editor instead of RStudio. I feared that working outside RStudio meant saying goodbye to fantastic hotkeys it provides. …
Continue Reading about Take your RStudio Hotkeys Online with a Text Expander →
We all have that one untameable workbook. You need to get back to a "home worksheet" each time but can never find it. Here are a couple of ways to set a homepage in your Excel workbook.Download the …
Continue Reading about Setting a “workbook homepage” in Excel — 2 Ways →
Here's a great shortcut I picked up recently: Use Ctrl + - to delete a row. Note my use of Shift + Spacebar to select the row. Cool, huh? Or was it?I've said it many times: I love Excel because there …
Continue Reading about Quick bit of magic…. then a question for you →
April is over, and so is Oz du Soleil's daily video blog. I am still enjoying these.Tonight I caught up on a look at Oz's Excel work environment.It's fascinating to see others' Excel work habits -- …
Continue Reading about Data Realism and the Missing Keystrokes →
