Chris Menard's Training Roundup | Issue #1

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 is a Microsoft Office Master. He trains corporate clients in Microsoft Excel, PowerPoint, Word, and Outlook. Menard is a speaker for the Georgia Society of CPAs and a senior lecturer at the University of Georgia Terry College of Business. Menard's YouTube channel has over 600 technology videos. Chris works full-time as a Training Specialist for a global law firm. His office is in midtown, Atlanta.

Categories