 Hello everybody. We are here for another one of my webinars on our Git Microsoft 365 Git Developer Certified, Microsoft 365 Developer Certified. Today, we are gonna be talking about Office add-ins. That's our next thing that we're gonna be covering in our session today. If you would, if you would just before we get started here, can you raise your hand and zoom? Make sure you can see and hear me. Should be able to see and hear me. Got a bunch of hands up, that's good. So everybody can see and hear me. All right, cool. So let's go ahead and let's get started with this. What are we gonna cover today? We are gonna be covering, again, the Office add-ins workload for our Microsoft 365 Developer Certified series. So really quick, let's go, let me do a quick little introduction here so you guys know who this is. My name is Andrew Connell. I'm an MVP for Office Development. I've been doing SharePoint development specifically for a very long time, 15 plus years, 17 years, something like that. And I was also heavily involved with working with Microsoft and getting the certification together. So come back to that in just a few minutes. I'm also a member of the Patterns and Practices core team with Microsoft 365. We do a lot of SharePoint community-based work. And then also have a podcast at co-hosts that has weekly episodes that come out every Tuesday and also a founder of the training company, Voitanos, where I have a SharePoint framework development course that I focus on. You got my contact info there that you can see. Let's start talking a little bit now about this exam. What can you guys expect to see on this exam? The exam, the Microsoft 365 workloads or what's gonna be covered in this exam and in the certification. We've got five separate workloads. This is our fifth webinar and we've kind of gone all the way around the circle. We started with identity at the very top. Then we went to Microsoft Graph, then SharePoint. We talked about Microsoft Teams and today we're gonna talk about Office add-ins and we're talking about that specific workload in the certification. That's what we're gonna focus on today. Come on PowerPoint, keep moving. All right, so a little bit of background for those of you who have not tuned in to any of the previous webinars. Why should you listen to me on this? So I was involved with working with Microsoft on helping them identify and define the topics that people should know and should be tested on to be considered a Microsoft certified developer or Microsoft 365 certified developer. And so what does that mean? What topics are covered, stuff like that? If you wanna know more about the process about the exam and how Microsoft comes up with the topics and what that whole process looks like, join me in two days for the last webinar in this series where we're gonna do a behind the scenes. But you wanna know why should you listen to me on this? Well, not only was I involved in this whole thing but I also took the exam. I also helped them build some of the content, the self-paced training content. And then I also have been involved with the, I also took the exam. And so you can see here from this slide, I'm showing you my results, just to kinda show how he has taken the exam. I took the beta exam, that's why you see beta at the top there. And what that means is I took it when they had a limited people that they were letting take it for a very discounted price because they wanted some feedback on not only the performance that people had on the exam, but they also wanted to see how everybody performed on the exam primarily. They wanted to make sure that is, are people passing that should be passing? Are people getting questions correct that they should be getting correct? Or are they not getting questions correct that they should have been getting correct? So oops, what have done my PowerPoint? PowerPoint just got screwed up. Hold on one second, let me fix that. That should be right, okay. So yes, that's all, that's the kind of stuff that they wanted to focus on. Now you can see here, each, there's different areas, different workloads that you're gonna be tested on for the exam, for the certification. You'll have workloads such as identity. So that's Microsoft Azure AD type stuff. You'll have stuff related to, what does he got? Microsoft Graph, Microsoft SharePoint, Microsoft Teams, and you have different questions for each one of those different sections. And each workload takes up a percentage of the number of questions on the certification. Today, what we're gonna look at again is office add-in. And I show you here, you can see that that was my weakest area when I took the exam. And from the experience that I've asked everybody else, in fact, I got a question for you in a minute, that's what everyone that's come to all these different webinars, that's what they've said as well, that this is the weakest area for everybody. So I hope that this webinar will give you some good tips on what things you should study for, for to take the certification. Actually, and I'm curious, if you'll mind me asking a question here, take a look at the, take a look at the poll that I just posted, that I'm curious how many of you are actually planning on taking the exam to get certified? How many of you are just thinking about it? How many of you have already taken it? Just curious. So, most people have answered here, that's interesting. So we got almost 90% of you has said that yes, you're planning on taking it and the rest of you are saying, yep, I wanna learn more about it, so I might end up taking it. Now, I got another question for you too, before we really start to dive into this. So let me go ahead and launch this one. There are two questions with this, and I don't wanna do a little bit of housekeeping stuff that I meant to do just a minute ago. So first question, both questions are very similar and it's basically of all five of these workloads, question one is, which one do you have the most experience or which one do you have the, are you feel the strongest at for tech or on the technology? And then the second question is the inverse, which one are you the weakest at and which one, or which one do you have the least amount of experience, okay? And, it's like everybody, same responses I've gotten every single time, all right? So most of you have answered all of these questions, let me go ahead and share this with you so you can see this. So first you can see, what are you the strongest at by far and away at SharePoint? No surprise, I know a lot of people are on my email list and that means that you're on my, that means that you get a lot of this stuff or that you get a lot of the, that's how you found out about these webinars. And then for the weakest, well, it's far and above, it's office add-ins. So I'm hopeful that this webinar will actually help you guys a bit and understand what things you need to learn on what's available to you. All right, so, oh, wrong window, there we go. Now, let's talk a little bit here about the certification and then I'm gonna come back, I see somebody asked a question about where the recordings are available, just stay tuned, give me a second, I'm gonna answer that in just a minute, you'll see that on the next slide. Okay, so let's talk a little bit now about the exam as well. So what does it mean? How do you get certified? How does Microsoft measure people being certified? How do you, let's see, what was the other question I wanted to do? What was the other one? It was, oh yeah, and how do I get certified? Like, what's the process? So first, let's start at the bottom of the slide, right? Microsoft measures developers in three different levels. You've got the foundational level, you've got the associate level and you've got the expert level. Foundational level, that is someone who is like a technical sales person. That is someone who can walk into a customer, they can talk to that customer, a customer can say, here are the different things I'm trying to achieve. Here's the stuff that I'm trying to, that I want to be able to solve, a business need that I'm trying to solve. And when they, that person should be able to take those results that are, or take that answer that comes from the customer and they should be able to design or model out an application with the different technologies that are available to them. Say like, you want to be able to do this, you want to be able to do that. Here's how you go about doing all of that stuff. Here's how you end up doing it. But you maybe, they don't have the experience to be able to go build it and actually implement that themselves. The next level up is the associate level and that is someone who should be able to go build the system without any help. And that is someone that Microsoft likes to say that they've got four years of experience, but I mean, they understand that not everybody has four years of experience. So they, you know, and not only that, it's, I mean, you look at technologies like SharePoint framework and Microsoft Teams, they haven't been around for four years. So it's impossible. But is that level of experience is what they're looking for? They want to make sure that people have that level of experience. They have that level of experience, okay? Another thing, another expert, another level is the expert level and that's somebody who could teach. The certification that Microsoft has provided, the Microsoft 365 certified associate developer, that's that middle link you see there on the slide, that is, that's the certification that you're going for. So they're gonna test you at the associate level. Now the way that you, the way you achieve that certification is by passing an exam. And the exam is the MS-600. It's called building applications and solutions with Microsoft 365 core services. You can see that at the top of the slide. Now this, that when you take the exam and when you pass it, your trophy is the certification, all right? Think about it like that. So to get certified, you have one prerequisite past the exam. So we're gonna go through, and the previous webinars I've done, you can, in the previous webinars I've done, you can see where you have a list of all of those, the different workloads. Today we're gonna focus on office add-ins, all right? And it looks like the person that asked the questions already answered their own question, but here is the entire webinar series that we've done. So we first did Microsoft Identity, then we did Microsoft Graph, then we did SharePoint, then we did Teams, and today we're doing office add-ins. And the previous ones, if you go to the link at the bottom of the slide, it's all lowercase, and the color coding is just there to make it more readable. But the link at the bottom of the slide will take you to a blog post that has each one of the different webinars that we've done with a recording that you can watch on demand as you see fit. You happen to miss any of them. The recording for this one will also be posted as well. I think I should have it posted later today because the new style I started recording these is working out really well. So I was able to push that out a lot faster this time, which is what we're gonna do, hopefully today. If you're interested, we have one more that we're doing on Thursday. And like I said, that's the behind-the-scenes one. So it's a great place to come and ask general questions about the certification. I'm gonna share with you what my experience was like, how I was involved, and just some general stuff on it. So it should be interesting. It's a great place to ask the questions. Today, I'm gonna really try and focus on only addressing any questions that show up that are related to the technology that we're gonna be focusing on today, which is office add-ins. I don't wanna go off and talk about share point stuff or team stuff today because that's not what this focus is all about. Now when it comes to the office, when it comes to office add-ins, what, you know, how much of the exam is it make up? So it's like the teams section was, which is it takes up about 15 to 20% of the questions that you'll find on the exam. There's also some self-paced learning content that is available for you as well. And you can see that from there on the slide. I wrote all of that content. Well, yeah, I wrote all of that content, all of the learning paths, the five learning paths that are out there for each one of the workloads. I authored all of that content. So that was my involvement in terms of self-paced study stuff. And that stuff is freely available. It's wide out there. Anybody can go take a look at it. Oh, share point topics, that's wrong. It should have been office add-in topics. Let's get off that slide quick. Sorry about that. All right. So now let's start diving into some of the things. What do you need to know? Now, it's office add-ins and there really isn't a lot of different areas for me to focus here. I've only got about four or five slides today, okay? So if you got any questions, send them my way, right? We're gonna have lots of stuff that we can go into. We're not doing any of the, and again too, just as a reminder, because I do see a bunch of new people in here today. We're not, I'm not focusing on like teaching you the tech. This is a how do I get certified? What things do I need to know? And I'm not gonna teach you those things. It's just what do I need to know? So you need to understand fundamental concepts related to office add-ins, fundamental concepts. So for example, what is the difference between a task pane and a content pane or a content add-in? What does it mean by that, right? Task pane being the things that go in the right-hand margin inside of clients like Outlook, Word, Excel, PowerPoint, a content add-in, that makes sense in things like inside of Word or Excel or PowerPoint. And then further, and it doesn't say on the slide, but you do need to understand the other kind of an add-in when you work inside of Outlook, where it will show on a mail compose or read our view panel or when you're composing or viewing a meeting from your calendar. You need to understand how to work with dialogue. So how do you surface a dialogue from an add-in to prompt the user for information or to display information. And you need to understand also how to implement custom functions. These are little JavaScript functions that you write that are loaded in the add-in that show up and will be that you can execute from your add-in. You need to understand add-in commands as well. So what does that mean? That's like those are the buttons in the ribbon that you wanna add. How do I go through and create one of those? How do I respond to when one of those is clicked? What kind of things can I do? Can I create just a button or can I create like a whole button with like sub-buttons inside of it, right? What can you do with that? You also need to understand and the thing they tell you need to understand, it says understand the purpose of the manifest. You need to understand how to declare these things. You need to understand the components, like the different sections in the manifest. Why, what, you know, how is some stuff used? What are the values that you would have in some of those things? Some of the other stuff too that you, that I don't have here on the slide that you are gonna need to know as well is what does the general development story look like? Right? What does the general dev story look like for building an add-in? What are you doing? Are you creating a server-side thing and uploading it and installing it inside of Outlook? You need to understand what that story is gonna end up being like. So we'll come back to that in just a minute. Let's talk a little bit now about the piece that's gonna allow us to have our add-in talk to the hosting application. And that's OfficeJS. That is a JavaScript library that we have to include in all of our add-ins and you need to know like some of the special, some of the required pieces to it, not special, but some of the required pieces to it. For instance, you have to know that you're going to, when you create your add-in, you have to know that you have to call a method called initialize, you have to implement it in OfficeJS and you have to respond, give a result back within five seconds of the Office app calling your add-in. Because if it doesn't happen, then the Office app is going to disable your add-in and show some sort of user experience that tells the user, sorry, I can't, and that's too expensive, okay? So you need to understand that or not expensive, that it's not working, right? And that way, Microsoft's really doing that to make sure that people that are using Outlook or Word, that they don't think that Outlook or Word is broken. They wanna make sure that they understand that, hey, it's this random person's add-in, we, Microsoft, everything's fine with Word. So that's why they do that. You need to understand what the programming model looks like, what are the developer tools? And that kind of goes back to what I mentioned just a second ago. You're gonna be creating essentially a web app and that web app is gonna be surfaced inside of the Office client in an iframe. And that iframe is either gonna be surfaced, is either gonna be displayed as a task pane or it's gonna be, it's gonna show up as a, like a content box inside of like a Word document or an Excel spreadsheet, Excel workbook, okay? You need to understand, you know, there are, OfficeJS has different sections of the API for each one of the different clients. So like there's a whole section about that you would use if you're working with Excel. So how do you get access to a cell inside of Excel? How do you get access to a table or how do you make a named range? How do you insert charts and graphs and stuff? That stuff's all on the exam. Same thing with Outlook. How do you get access to the header of an email or to the body of an email? How do you make it so that your add-in will appear when you find specific content inside of an email? Like for example, if I built an add-in, I could check to see if the content of the email contains a UPS tracking number or a Federal Express tracking number. And if it did, then I want my add-in to show up to where someone could click on it and it would open up in the email and show a map of where it is with the history of the tracking information in my package. Same thing for a word, right? How do I get a range of text? How do I insert a paragraph? How do I insert a picture? How do I format content? You need to understand how to do those things. PowerPoint, similar story. How do I work with PowerPoint? How do I work with the different elements inside of PowerPoint, creating a new slide, creating a new section, stuff like that? And then the last one is how do you create custom functions? And what can you do with a custom function? How does it work? You're gonna create a JavaScript file that's gonna load in your client and you just map that JavaScript function to one of the buttons you put in the ribbon. So when someone clicks the button in the ribbon, what happens? Now, you also need to understand some of the customization things of add-ins. So this is the stuff that gets, where I think add-ins start to get a little more complicated, a little more tough. For example, you can implement your user experience. Excuse me. You can implement your user experience using OfficeUI Fabric. How would you do that? What limitations do you have for that? What are the implications for that? What things are required? You also need to understand how do I persist settings or persist state in my add-in? So with add-ins, I have the ability to, like let's say I created add-in for Word and I wanna have specific settings that I store. Not sure what that is. Sorry, so let me just add a comment. I'm not sure what they're referring to. So what that's essentially saying is is that you need to be able, how do I define settings in my add-in and save those settings when I'm using it on like Outlook desktop or an Excel desktop on Windows? And then if I go over to my iPad or go over to my phone or go over to the web experience, those same settings are available to me, okay? So I have all those different things that are, how do I go through and work with settings and state between the applications? You also need to understand when can you and how do you use Microsoft Graph within your add-in? Because when you're working with your add-ins, you're almost always working with people who are using Office 365. And in that case then, your number one API that you wanna use to be able to go get data about the current user or content inside of Microsoft 365 is Microsoft Graph. Microsoft Graph though requires authenticated requests. So how do you authenticate from your add-in? How do you obtain an access token? How do you call Microsoft Graph from the add-in and get that data? Those are things you need to make sure you're aware of and know how to do those things because you will be tested on that. The next thing, I think this might be the last thing, the last slide about this stuff. What does deployment look like? How do I test? And this, I guess in my opinion, this is one of the more challenging aspects to working with Office add-ins. Testing is tough and it's because you need to host your app inside of another experience, but it can be tricky and it's kind of like Teams, but I think I find it harder with Office add-ins. When you create something for Office, there's two pieces to it. You have to register your add-in with the Office client and then you have to host your add-in application. And so that's gonna be done, generally you're gonna host your application on a local host on your local machine, but then you gotta get that manifest file, that big XML file and you gotta somehow install that into the Office clients. And there's a couple different ways you can do it. There's a couple of ways you can run this. You can test your stuff and do the browser-based clients in Office. I find that to be the easiest. The other option that you can do is you can do it, sideload it, your add-in into your local install of Word or Excel or PowerPoint or Outlook. And how do you go about doing that? So you need to understand what those things mean. How do I sideload? How do I do a deployment? What does my ultimate deployment look like when I wanna go to production and make my add-in available to everybody else in the world and let them go about using it? So you've gotta go through and figure out those different things, like what you have to know those different things and how, because you will be tested on those on how to deploy it, how to upgrade it and all that stuff. There was one more that, sorry, I wanna make sure, this is an important one. And this kind of overlaps with something we talked about in the Teams workload. There's a concept called adaptive cards. And all an adaptive card is, is it's a block of JSON that you describe a user experience and then when you give that JSON to different applications, like if you gave that to teams or to like a web experience or to Outlook soon it'll be in like the Windows timeline. When you give that experience, when you give that JSON to those different experiences, it'll get rendered in the native experience for that client. So you can do the same thing with actionable messages. So what that is, an actionable message is in Outlook is when you receive an email and that email will render out an adaptive card and the person that receives the email can interact with that card and even submit the results or submit some feedback in the card and have that card be posted back to a RESTful service. And that RESTful service can process the response but it can also respond back to Outlook, to Office 365 with a new card to refresh it. So like one of the labs that I built for that self-paced study content was we do a webinar review process and so someone receives an email after they've attended a webinar and it says, what did you think? And you can rate it one, two or three and then there's a comment section and when they fill that in and hit submit after a second, the card refreshes without ever leaving Outlook, it refreshes and shows the average score, the total responses and the last four or five responses and what's nice about adaptive cards that are an actionable messages is people don't, they can interact with something without ever leaving Outlook where they're already living and they're already receiving the message. So it's a better experience and it's a more streamlined and quicker experience as well. What you need to understand as far as it goes with the exam is what are actionable messages? So what I just explained and then what kind of capabilities do you have with this? What can you do? And adaptive cards, there was something called and this gets a little confusing so I'm gonna give you a little bit of a tip here. There wasn't an actionable messaging card format and that is like the legacy thing and that still works but it's been like, I don't wanna say deprecated because I don't think that's official but if I were you, I would treat it as something being deprecated and instead you should use into adaptive card protocol and format because that actually came from, it was inspired by actionable messages. So the new one is adaptive cards. What you're doing is you're sending an adaptive card to Outlook that is gonna be rendered as an actionable message. So the thing in Outlook is an actionable message but to get the actual message you have to send an email with an adaptive card in it. So understand what kinds of things you can do but not only that you need to also understand how can you refresh it? How do you receive and how do you process the HTTP request from Outlook when someone interacts with a card? You need to understand like you need to validate a token. What does that mean? How can you check to make sure what kinds of security things should you check for to ensure that you're receiving something that you expected to receive? Stuff like that. Those are things you definitely need to know. Another thing that you need to know is how do I respond and refresh the card? Like what HTTP header do I have to use? How do I respond if there's a problem? How do I respond without refreshing a card and to just give some feedback and say, yes, that was successful. What do you do there? You need to understand how to do all that stuff. And you also need to understand what are the registration requirements for this because you do have to register your web service and what does that mean? What do you have to do? Where do you do that? What are the limitations? What can you do when you're doing development and testing things? First, what can you do when you go into production? You need to figure that stuff out, okay? All right, let's see. I think that's it on my actual messages. If I'm not mistaken. Yeah, so that, we finished like 30 minutes into this. I didn't think it was gonna take the whole time either. Those are all the things that you need to know about Office Add-Ins. It's not a ton of stuff when you compare it to things like identity and Microsoft Graph and Microsoft Teams and SharePoint. But each one of those different topics we touched on, like when I have one bullet for, you need to know OfficeJS for Excel. That's a big topic. You need to know OfficeJS for Word. Again, a big topic. And then the same thing for Outlook and for PowerPoint. I only remember questions on Excel. There were in Outlook primarily, very, very few on PowerPoint. In fact, I didn't get one for PowerPoint, but that doesn't mean that you wouldn't get one because it's a pool of questions that you get when you take the exam. And you will receive a subset of the pool of all the questions I wrote. There was some on Word, but not much. It's a lot more like general Office Add-In style questions of things you need to know, okay? So again, Office Add-Ins, another one of the workloads you need to know, just like one of these other four workloads. Quick little reminder. Oh, and if you have any questions, so I didn't get any questions about the content here. If you got any questions, now's a good time to go ahead and post them. If I don't get any questions, we're not gonna leave the webinar going for a whole hour unless I'm happy to, but there's no sense in just leaving it here if nobody has any questions. Sweet, so there's a couple of questions coming. So definitely, if you have a question coming, now's a good time to go ahead and post them. Wow, everyone just all said, you were holding onto those for a while, sweet. Just to wrap up this slide here in case anybody leaves. Actually, I'm gonna wrap this up and let me ask another question and then I'll start answering these other ones. So first, if you missed any of the webinars, you can see the link down on the slide on where you can go to actually see the recorded version of all these different webinars. And again, I will have this one today posted as well. And love to see you join us, join me again on Thursday when for the same time for a little bit of behind the scenes stuff. Much more casual, well, this is pretty casual, but be much more casual. Anything actually would be cool is if you have anything that you would like to see in that webinar or like kind of stuff that you'd like, send me a mail, right? Or just reply in the chat here to let me know what kinds of things you'd be interested to see. I plan on covering, what was the experience like? How do we go about identifying stuff? How does the whole project progress from who's involved? How long does it take? How they write questions? How they evaluate the questions? Not only when they were writing them, but also when they were, after that people started taking the exam, stuff like that. What the experience is like taking the exam, like if you do it remote because you have the ability to do it from home, that's a heck of an experience. So that's all stuff that I plan on going through. And again, the recording is there if you're interested. Now, another thing that I'm doing as well is that I, so as I said earlier, I have a SharePoint Framework Development course that I sell through my training company. Still working on that. In fact, last week we published a chapter on integrating DevOps, Continuous Integration and Continuous Delivery with SharePoint Framework. Got another chapter that should be publishing in the next week and a half. So by the end of next week on Continuous Monitoring with Azure App Insights and then I have two more chapters I'm planning for that one. When that course is done, I'm likely gonna build some sort of a bootcamp for getting for passing guidance for passing the MS600 exam. And it's something I'm curious if that's something you guys would be interested in. So I just posted a chat here or a poll here on if it's something you were interested in. Before anybody asks, I'm sure this can influence your thing. You're saying, well, how long is the course? How much is it gonna be? When's it gonna be available? The when's it gonna be available? I don't know. I can't say that just yet because it's, you know, a lot of things change. My goal is to get it out quick. But that's gonna be like, I mean, July, August, something like that. So I'm not sure what your timeline is on taking it. Pricing though, it's not gonna be a very long course and it's not gonna be a, because I'm gonna leverage a lot of the content that I built for Microsoft. I'm gonna point you to that content for like self-paced stuff. Instead, I wanna just guide you and give you a place to ask questions as well and give you the tips and tricks of the stuff that we don't have in the content, what things you need to know and what's the best way to take it past the exam. Pricing goals to make it below $250. I'd love for it to be less than that. We just have to see. But again, we're just in the planning phases. So cool, thank you very much for those of you who answered that. So let me go through and let me answer, let me go ahead and address some of these questions that we've got. I'm gonna switch over to Cameron instead of that other slide. All right, so I've got five questions here. So first question is, is there a version of Microsoft Office that's required for adaptive cards? I found that mine didn't render correctly from flow even though I'm using Office 2019, but they do work with Outlook that's online. So it's hard to say. Adaptive cards are only Outlook. The documentation specifies where they are supported. Yes, there is a specific version. I don't know it offhand. I know that the web version definitely does. I know that the Windows version for 2019 Outlook for an Office 2019 does. I can't remember if the previous one does. Outlook on Mac does not support it right now. And Outlook on mobile for iOS and Android does support it. If you're using the actionable message format, then it does not work on mobile. Only the adaptive card format works for actionable messages on mobile. So that was from Mr. Anonymous. Joseph, Joseph A. Question, with a registration required and the need to host it on a server somewhere, is it similar to SharePoint Add-ins where we were just building prior to SharePoint framework was released? Yeah, I mean, it's like SharePoint Add-ins. It's like Microsoft Teams-based stuff. You build something, a manifest, that you're going to install. And I put that in quotes because it's just, in the case of Office Add-ins, it's XML, I guess in the case of SharePoint Add-ins, it was XML, in the case of Teams, Apps, it's JSON. You're gonna install that into the hosting client and then you have to host the application itself somewhere. The web app has to be hosted somewhere. When you're doing development, you're gonna do that on your laptop or on your desktop. When you're in production, you're gonna do that someplace that can serve up an HTTPS endpoint. Azure, an Azure web app, an Azure Function. I mean, it's up to you. But yes, it's similar to how that all works. Ralph, what type of use cases are covered in the questions? Part of the issue for scoring is that folks rarely architect this as a solution, so knowing how they think should be used helps prepare. Yes, okay, so there's no specific scenario that comes to mind that you need to know. And I wouldn't really focus so much on scenarios. I would focus more on capabilities. How do I read and write to an Excel workbook, worksheet? How do I read and write to Word? How do I, I guess, read and write? Let's see, what is it? So for Outlook, it is read and write. But I can't remember if you get tested on the calendar items. I do remember questions about emails. So it's how when someone opens up an email or they're reading an email, how do I get information from that email, like from the body or from the header? And then if I'm writing, if somebody's composing a new email, how do I write to that email? That's the kind of stuff that you need to know how to do. This goes on to the next, to somebody else's question, Michael's question says, what recommend, what do you recommend as ways to prepare for the office add-in portion of the test? At the beginning of this webinar, I mentioned a learning path on Microsoft Learn. That is what I would recommend. As some background, when, and I'll cover more of it, you'll actually, you'll get a little bit better. I think you get a really good idea of how you should prepare for this and how do you evaluate if you have the experience level to pass this exam, if you come to the webinar on Thursday. But since we have the time, the way that we built the certification, the way it was constructed is it kind of follows this path and then it spiderwebs out in a couple of different directions. And one of those directions is an exam. So what we do is we got together last year, twice, where we defined all the different topics. It was kind of like, it was a, just what is possible? What could you be tested on? Don't think about timing, just what could you be tested on? What level of knowledge should you have to do this? And we had this giant list. And then we came for each one of the workloads. And then we came back a month or two later, a month later, I think, and we started to scope it. And first we made sure of, yes, this is a foundational level of knowledge. This is an associate level of knowledge. This is expert level of knowledge. And then we had to prioritize stuff. What things could we put into different buckets and what things need to be that people have to know? That, the outcome of that was a spreadsheet that had like a giant manifest of here's the topic. Here are the topics that people should know. That spreadsheet was given to three different groups to go build out the certification. So that is now the spec for the certification essentially. One group wrote the questions for the exam. I was not involved with that group. I was involved in these first two things I just mentioned. I was not involved, once we started spiderwebbing, I only went one direction. And the reason I went one direction is for conflict of interest reasons, which I'll explain more about in the next webinar on Thursday about the bonus stuff. For those of you who are watching the recording of this, that's the behind the scenes webinar. So make sure you watch that one if you want. That's what I'm referring to now. So one group that wrote the questions, they got that spreadsheet and they wrote questions based on what that spreadsheet said, people need to know these things. Another group got it to go write an instructor led training course on it. I was not involved in that group either. They wanted me to, but I was not involved in it. They asked me to do it and I turned it down. It was a conflict of interest again. And then the third group, individual, that got that spreadsheet and said build content for this was the group that built the self-paced training content. That was me. So I wrote the self-paced training content. So what do I mean by that? So why do I share it with you? Because all the content, all the questions are based on what that spreadsheet was. All the content that I built was in the self-paced content on Microsoft learning. So all those different learning paths and all the modules in each one of them, it's probably 25-ish modules. All of that content, they all came from the same place. They all came from that spreadsheet, right? So we use that as the inspiration to build all three of these different things. The exam questions, the instructor led course and the self-paced training course. If you go through the self-paced training course and you feel all the, sorry, if you go through the self-paced learning paths, you feel comfortable with that entire office add-in section, should be good. Now it's not, don't think that it's everything that's on the self-paced content. I know everything on this and nothing else. Don't think you're gonna walk into the exam and you're not gonna get asked a question that it was not something you covered. So while, like for example, let's see, let me think of one. In the self-paced content, there's nothing about, there's no modules or training about creating add-ins for PowerPoint. You may get a question about PowerPoint though, right? Stuff like that. So it's just, it gives you an idea of, if I go through this one and it says, here's how you go through an extended Excel and you go through that entire module and it's like, feel pretty good. Here's how you go through and do the same thing with Word. Feel pretty good. There's not one for PowerPoint. Based on what I learned about Excel and Word, I think I can kind of figure out the kind of things that you know for PowerPoint. So I need to go through and figure that stuff out too. That's what I mean, that's how you would go, that's how I would approach it. But if you feel good about it, you'll be good. Now granted, I've been doing this for a while. So I've been doing mainly SharePoint development for 17 years, but Graph and Identity, development with Graph and Identity, as long as they've been around, even longer actually, because I guess I used the predecessor to Graph, which was the universal API is what they call it, the different Office 365 APIs. And then I also, and I've been doing, I've done add-ins here and there for Office and doing Teams development as well since Teams has been around. So I have the experience doing it, but I also wrote all the content. And when I went and took the exam, I intentionally did not study at all for it. I just went right in and said, let me just take it, let me see how I do. And it shows that the things that I've got more experience in, I did better. And the things I have less experience in like add-ins, I didn't do as good. I mean, that's not surprising. But I felt comfortable that if I feel strong enough about these other areas, I only have to get a 70% or higher collectively on the entire exam. If add-ins are 15 to 20%, so upwards, so max would be 20% of the questions I'm gonna receive. If I missed all of them, which I didn't think I was gonna do, I still was gonna pass. As long as I did okay, I did good on the other sections, which I felt comfortable with. So that's how I would look at it. Matt, will extend Microsoft 365 fundamentals learning path be enough to prepare for this section of the exam? Absolutely not. Because foundational, if you remember from the beginning of this webinar, that foundational level is not the level that you're being tested at. You're being tested at the associate level. And that's where all the foundational level is not intended to get you ready for this exam. The foundational level is just a what's possible kind of a thing. I built the foundational content as well. And if you only studied that, there's no chance you're gonna pass. That's not gonna be enough. Okay, I have no more questions. If you got a question, now's a good time to post it. Or raise your hand to let me know that you're about to post a question so I don't shut the webinar off on you too quick. I hope you guys have enjoyed this. I hope you've gotten a lot out of this series. Would really appreciate it if you told people about it. Again, all of them are recorded so everybody can watch it. That's the, I did these for free. And honestly, it's part to generate, to see what interest there would be for boot camp course that I'd like to work on. I'd really like to do it. And I'm going to do it. I just gotta go through and sit down and to plan the thing out. But got my other course, I wanted to finish first. So I'm gonna knock that guy out first. I actually wasn't gonna do this, but I was surprised at the amount of interest that there was in it. And I was very interested, I was surprised at how many people said that they wanted me to do this. So I was like, okay, this is stupid, just ignore it. So let's go through and do this. So I kind of moved the schedule around a little bit to make sure to do this. Not just the webinar series, but the course, the boot camp course as well. I don't see anybody raising their hands. So I don't see a reason to keep our webinar going for another 11 minutes, just to fill up the time. So, if you would, please tweet this about it or put it on Facebook or send it to your friends. Send them the link to that webinar series. I would really, that you see there on the slide. Actually, let me show you the slide. Where is it? It's here, it's right there. To help other people actually see it to jump in and just gives me a hand. I appreciate it. Social media is always good. LinkedIn, Facebook, Twitter. I don't think Pinterest applies, but whatever. Anyway, thank you very much. No other questions. I'm gonna go ahead and shut it down. I hope everyone has a fabulous day and I will see you next time.