In partnership with Experts Exchange.
If you know Python, you’re going to love this: you can now run Python code inside an Excel worksheet directly in cells! It includes five popular libraries, including Pandas, you can import additional libraries, and you can toggle individual cells back and forth between Python mode and Excel mode. It’s currently in beta and for the Windows edition only, so you might not have it available yet, and it can change somewhat by the time it’s officially released.