Power Query Updates – Excel News – Week Ending 2015-06-05

Excel.TV News & Articles

• Oz shows you how to Cleaning  name suffixes with Array formulas with this download and tutorial
• Jordan shows you a tip that he wishes he has learned years ago. Shortcut to finding VBA Definitions
• I honestly never knew this was a thing.  Guest Dan Fylstra shows you that there are Solver Examples that are already shipped with Excel.  Cool, right?
• The expert panel discusses things that have been conquered with Excel.
• Is your management team responding to just about everything under the sun?  If so, this standard deviation in Excel tip from me will be helpful
• Plus, friend of the show Szilvia Juhasz stops by to chat about her Excel Inspired Cocktail Book that hits the bookstores in September
• Excel.TV LinkedIN Group passes 300 members – so join Excel.TV on LinkedIN

Other News & Posts in the Excel Community

• 11 Updates to Power Query – http://blogs.office.com/2015/05/08/11-updates-to-power-query/
• Timing Excel Formula Calculations- https://fastexcel.wordpress.com/2015/05/11/timing-excel-formula-calculations/
• AMP – Activists Mobilizing for Power- http://www.westernstatescenter.org/our-work/leadership-development-and-organizing/about-amp

Excel Conferences & Competitions

• ModelOFF Moves to London for 2015
• NOTE: We would like to get a better handle on Conferences and Competitions happening in the Excel Community.  We certainly have out Excel Challenge every episode.  And there are maybe 3 conferences a year that we are aware of.  Plus Chandoo usually has a dashboard contest at some point throughout the year, and DataPig may have something fun like his meme content.  But it just seems like there has to be more out there.  Are there any Excel competitions that we are missing?  If so, please add them in the comments section.

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.