Teaching analytics with modern Excel
AI is often misunderstood as a magical solution, leading people to believe it requires no user effort. But experienced Excel users, who have faced many data challenges, know better. To unlock AI's …
Continue Reading about AI-Powered Excel: How to prepare your data for best results →
A reader had a group of items separated by commas which he wanted to turn into a vertical list. In this video I show how to transform the data using text-to-columns and paste special: …
Continue Reading about Excel Tip: Turning a comma-separated group of items into a vertical list →
These are the little things that make a good analyst. You should not assume your recipient has Excel, especially if the recipient will be reading the report from a point of service like a retail …
Continue Reading about Excel Tip: It’s all in the PDF and Print. →
