Teaching analytics with modern Excel
Can you believe it? We are approaching the final week of 2016.It's been a big year here at the blog. Some highlights:Appeared at Excel.TV in the springReleased an ebook of my top essays in the …
Continue Reading about To Good Friends and Good Spreadsheets! →
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 →
Note -- this is a guest post from Kasper at Spreadsheeto. He and his business partner Mikkel are doing some awesome Excel training -- check out their site! I was introduced to their work after …
Continue Reading about Guest Post: How to Create a Dependent Drop-Down List in Excel →
This one comes from a friend who wants to know how to average out a score for each person from a list where scores are recorded multiple times for each person.Subscribe for more Excel tips and get …
Continue Reading about Excel Tip: Averaging Grades with AVERAGEIF( ) →
A feature of my blog has been turning Excel skills into career opportunities. My first course was a deep dive into getting "hired with Excel." What, as I said, does "every analyst need to know?" This …
Continue Reading about What Makes a Good Analyst? And How Do You Interview to Find One? →
Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook!This is a preview of my course on Excel for healthcare. Learn more at http://georgejmount.com/excelforhealthcare Every …
Continue Reading about Excel for Healthcare Preview: What is a Dashboard, Anyway? →
