Download the exercise file here. Requires Excel 2013 or greater. These are new functions in Excel. You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) …
To Good Friends and Good Spreadsheets!
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! →
Excel Tip: Turning a comma-separated group of items into a vertical list
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 →
Guest Post: How to Create a Dependent Drop-Down List in Excel
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 →
Excel Tip: Averaging Grades with AVERAGEIF( )
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( ) →
What Makes a Good Analyst? And How Do You Interview to Find One?
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? →