Teaching analytics with modern Excel
"You don't really know a person until you have shared a pound of salt with him." -Russian proverb"You don't really know a coworker until you have shared a spreadsheet with him." - georgejmount.com …
Continue Reading about You don’t really know a coworker until… →
Download the exercise file here.Let's say you need to come up with a seating chart. Using RANDBETWEEN, you may get duplicate entries for the same number, or missing numbers.Using RAND in conjunction …
Continue Reading about Generate Unique, Non-Repeating List of Numbers in Excel with RAND and RANK →
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( ) …
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 →
