Excel Summit South 2016 – Excel News – Week Ending 2015-12-18

Excel.TV News & Article

• Szilvia Juhasz (aka XSzil) demonstrates how to use VLookup to the left. We all know that VLOOKUP works to the right (of the column with the lookup value). But what if we want the ability to lookup a value to the left? Check Out the Video Tutorial.
• It’s time! Excel in the Wild has started! We’re taking conversations about Excel and data out into the wild! – Check this Intro Video and Watch out for more episodes.
• In this episode, Excel TV guest Excel MVP Michael Alexander joins Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Excel MVP Jordan Goldmeier in discussing the DO’s and DON’T’s of data visualization…avoiding the dreaded ice cream sandwich syndrome! Check Out the Video Discussion.
• Excel MVP, Jordan Goldmeier, has an interesting tip for us to make nested IF functions readable. Check Out the Video Tutorial.
• Using Excel Formulas, Jordan shows us a random sorted order without repeats. Check Out the Video Tutorial.

Other News & Posts in the Excel Community

• PASS BUSINESS ANALYTICS Webinar Marathon – http://passbaconference.com/2016/Learn/Webinars.aspx
• ModelOff Financial Modelling World Championship Finals – London 2015 – http://www.modeloff.com/
• Excel Summit South 2016- https://excelsummitsouth.wordpress.com/2015/10/22/61/
• Excelguru Knowledge Base – http://www.excelguru.ca/
• M Is for (Data) Monkey – http://amzn.to/1N9ZoA1
• Power Query Training – https://www.powerquery.training/
• Introduction – Excel In The Wild – http://excel.tv/introduction-excel-in-the-wild/
• 39: Power Query Book Author Ken Puls – http://excel.tv/39-power-query-book-author-ken-puls/

Do you have News or great articles to share?

The easiest way to get the word out is to leave a message in the comments section below.  We will review it and consider it for the next Excel News update.