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( ) …
I ordered Chinese takeout… then this happened
The other day the family ordered Chinese takeout.Normally one of us would take out a notepad and scribble notes, which often became illegible and ran across multiple pages. There has to be a better …
Continue Reading about I ordered Chinese takeout… then this happened →
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! →
Generate Random Qualitative Data in Excel with CHOOSE()
What's the only thing better than real data? Fake data! Well, at least sometimes -- such as for conducting training or testing models. Subscribe to the newsletter for more Excel tips and tricks. …
Continue Reading about Generate Random Qualitative Data in Excel with CHOOSE() →
Change the Default Number of Worksheets in Your Excel Workbook
The default Excel workbook begins with three worksheets. Perhaps the reason is the very solid advice that most models should have three tabs: input, output, and calculation. But most of my workbooks …
Continue Reading about Change the Default Number of Worksheets in Your Excel Workbook →
Could Spreadsheet Developers Use the IKEA Effect?
I have been watching "Universal Principles of Design" on Lynda.com, an absolutely fascinating series on design with rather un-intuitive -- and powerful -- lessons for us spreadsheeters.I have …
Continue Reading about Could Spreadsheet Developers Use the IKEA Effect? →