Live streaming Teams meetings and webinars to YouTube may expand your audience and allow for more viewers to engage with your event than otherwise might. It’s great for running a virtual conference or event where you need to embed YouTube videos in the platform for a streamlined approach. YouTube also saves your live streams as videos in your channel without the need to do a separate upload after an event. This concept gives users/presenters the ease of just having a normal Teams meeting, but the power of enhanced broadcasting and distribution. Though I’m focused on YouTube in this blog post ..read more

If you’re considering becoming a certified Microsoft Teams administrator, you’ll be well-prepared for the exam when you use Peter Rising’s and my MS-700 exam guide. It includes 168 practice questions throughout the book, or the equivalent of about three full exams. We’re excited to share that right now, until November 15th, you can get 20% off the regular price of the guide by using code 20EXAMGUIDE at checkout on Amazon. Get your copy today! Happy studies. The post For a limited time only: 20% off my MS-700 Teams administrator certification exam guide first appeared on NateChamberlain.com ..read more

There are many web tools out there to generate random “lorem ipsum” filler content, but you can do the same thing using Microsoft Word. Simply: Type =RAND(5) on a line Hit enter Instantly, the formula is replaced with five paragraphs of sample content. Replace 5 in the formula with the number of paragraphs you wish you to generate. See a video demonstration here: Shoutout to Jaime Velez for telling me about this for the first time. Game-changer! Want additional tools for different types of sample content? Try the following: Jeff Goldbum quotes | jeffsum.com General lorem ipsum paragraphs ..read more

Note: Video demonstration at bottom of post. In some applications, like Power BI, you can get a distinct count of unique values in a column in just a click or two. But of all the functions in Excel, there isn’t a straightforward “Distinct Count” unfortunately. There are, however, the following two functions that, when used together, give the desired result: COUNTA – Counts the number of cells in a range that are not empty UNIQUE – Returns the unique values from a range or array So, we’re listing all the unique values we have in a range or column by using UNIQUE and then nesting it within t ..read more

I am so excited to be presenting two workshops and three general sessions at the upcoming 365 EduCon and PWR EduCon conferences happening simultaneously in Chicago September 26-30. WRK109 – Unboxing Microsoft 365: Make the most of your productivity toolbox WRK502 – Build the intranet of the future using SharePoint Online OFF103 – Goodbye, TwoNote: A OneNote refresher PWR203 – How (and when) to use calculated and lookup column types in lists OFF303 – How well do you know the Office desktop apps? 70 min of tips & ideas to wow your co-workers I’ve included the details for my workshops (incl ..read more

This is the fourth consecutive year I’ve been awarded as a Microsoft MVP in the Microsoft 365 Apps & Services category. What does that mean? Microsoft presents the MVP award annually to individuals who have regularly made high-quality contributions to the tech community. Sometimes this is forum participation, conference and user group presentations, books, blogs, videos, code and solutions, social media, or any number of other ways a person has evangelized and helped drive adoption and understanding of Microsoft 365. I focus my contributions on Microsoft 365 productivity and collaboration ..read more

You may have noticed your Microsoft Teams meeting invites now include meeting IDs and passcodes, and there’s a new Join with an ID button on Calendar. In this blog post I’ll cover several meeting ID-related topics for meeting organizers: Find your Teams meeting ID and passcode Find your Teams meeting ID and passcode during a meeting Add someone to a Teams meeting already in progress Microsoft Teams meeting IDs vs join links In a rush? Here’s the quick answer: Not in a meeting yet? Open the event on your calendar and you’ll find the meeting ID and passcode in the event details In a meeting a ..read more

When using OneNote (Business) in a Power Automate flow, you may be attempting actions such as Create section in a notebook, Get sections in notebook, or Create page in a section but getting errors when trying to select the relevant notebook and section. And depending on what you’re using as the Notebook Key and/or Notebook section value(s) you may get any of the following specific errors: Error; the requested notebook or section may have been deleted or is otherwise inaccessible. Invalid notebook key The specified resource ID does not exist. The section id is invalid. If a custom value was en ..read more

Sometimes people need to move or copy many files at once from their OneDrive to a shared folder or location. This is sometimes simply for reorganizing and sharing content more efficiently. Other times, it’s because a user learns that OneDrive is tied to individual employees so when they leave, their OneDrive will be gone as well. What files do you currently have in your OneDrive that others would need if you left the company? Does your team use Microsoft Teams regularly? Every team in Microsoft Teams has a SharePoint site that supports it – so moving files to a site connected to a team makes t ..read more

I was honored to be a judge again this year for one of my favorite community initiatives: Imagine Cup Junior. Imagine Cup Junior is a technology-centered competition hosted by Microsoft for teams of 1-6 students ages 13-18. Judges this year were asked to evaluate teams’ contest submissions using a standardized rubric for the theme, AI for Good. I am so very inspired by the ingenuity and heart behind the solutions presented. Check out the top 10 winning teams for Imagine Cup Junior 2022 and their innovative, AI for Good solutions that earned them a top acknowledgement. Many who compete in Imagi ..read more