Chris Menard's Training Roundup | Issue #1

Posted on:  07/14/2020
Chris Menard's Training Roundup | Issue #1
  1. Microsoft just added the Zip Code Data Type in Excel. Unlike the Geography Data Type, which only shows data for countries, states and cities, the Zip Code Data Type returns things like household income, latitude, longitude, population by marital status, water and land areas and much more. Watch the video.
  2. You can now pull stock history directly into Excel with the Stock History Function. You can view historical data of stocks and other financial instruments. Watch the video.
  3. Using the SORT function in Excel for the Web. Watch video.
  4. You can now add polls directly in an email with Outlook. It works in conjunction with Microsoft Forms (but you don't need Forms to use this feature). Read the blog post about this feature.
  5. Microsoft Teams introduced Live Captions in Teams Meetings. This is pretty cool, almost real-time and quite accurate. Even adds punctuation. English only for now. Watch the video.
  6. Over on my Zoom Resource Center, I'm offering 28 free virtual background videos for you to download and use in your meetings. They're all seamless and relaxing. Check out my video introducing these. Zoom Virtual Backgrounds not working? Check here and here for possible reasons.
 
Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories