Influence Professionals

This is an amazing feature of Microsoft Team where you can alter your video background or anything else you like. This is very helpful feature when you are in your engagement and someone strolls behind you by an accident, it will blur the entire background hence no one will be visible in your background during the call. Needless to say, you will feel more ready and less oblivious. When you click on join meeting, it will land on you on the page where you adjust your Audio and Video before entering the call, on the left-hand side of that window you will see your video and  Background filters  option available right under it. (Refer to the below image) Just click on Background filters . Once you click on that option, a new Background settings window will appear on the right of the window (Refer to the below image) Just select  Blur  as selected in the above image, and you are done.  You can also add images available under these options or can also add customize...

Microsoft Teams has a great range of features. Not only do they help us to schedule a meeting and connect with your co-workers instantly through chat or call, but also you can access your files stored on Microsoft cloud instantly when & where required. But here I am going to tell you about the feature which allows you to plan a webinar through Teams following simple steps, and you can also add customized forms for attendees to fill out to register for the webinar. I will show you how to schedule a webinar and add a response form to it for attended: 1. Start with going to your Microsoft teams and select Calendar from the left Panel. (Refer to the below screenshot) 2. Now on the right top-hand side, you can see a down arrow near the  New meeting  button. You will get three choices by pressing that arrow button which are Schedule meetings, webinars and live events. Please click on  Webinar . 3. In the next windows, you will have several options. We will start with cre...

1. Open Microsoft Teams and go to your calendar 2. On your calendar, you will find a Meet now button on the top right-hand side of your screen, click on that (Refer to the below screenshot)   3. When you click on that, a new window will appear. Please select Get a link to share (Refer to the below screenshot) 4. You will get your meeting link. You can either copy or share the same through mail from that window. That’s all. Keep learning, Keep improving.

Now you might be already aware of the countif function that most people use for their reports and excel sums. Again as I have explained in my previous blog about sumifs function ,   the ‘ countif’  function can fetch data using one exception whereas ‘ countifs’  can match up to 29 criteria.  Here, i will demonstrate you this function with the simple example: Example1 . Below is the table we will be working on in this tutorial: As you see in the above table, we have Year , Product , country , and total Sales . From this data table, we want to get our total sales using different criteria available in this table.  In the above table, we need count of Red trolley Bags in the year 2019 Here is the formula syntax: COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2, criteria_range3, criteria3, … criteria_range_n, criteria_n] )” In the above example, since we are looking for count of product Red trolley bags in 2019 . Next, we have the first...

This must have occurred with you multiple times in the office while preparing excel reports when you need to bring particular values from the massive chunk of data based on specific criteria and requirements. Essentially, if you ever want to make a sum with exceptions and specifically, if these exceptions are more than one which is typically the case in actual life. This is when 'sumifs' function in excel comes handy. Now you might be already aware of the ' sumif'  function that most people use for their reports and excel sums. However, ' sumifs'  is there in the system since Excel 2007 version, and many of us may have just skipped this. It is not only a time-saving function but also assists you to fetch data from large data arrays using several criteria in one go. while the ' sumif'  function can fetch data using one exception whereas ' sumifs'  can match up to 29 criteria.  Here, i will demonstrate you this function with the simple example: E...

Microsoft provided us with many useful tools and applications, and Microsoft form is one of the finest apps we can use to capture surveys, polls and feedback from the customers or your end-users. It is a component of office 365, released in 2016. It is not only fairly simple to create a data input form with Microsoft, but also it is user-friendly and easy to navigate, which requires little technical proficiency to make a highly dynamic and creative form. Since it is a part of Microsoft 365, it will be free for you to use if you have active Microsoft 365 subscription. As we all know, data has become an essential part of any process or function in a small or big organization, and the Microsoft form application comes in handy when we need a tool to collect any kind of data from the end-users or customers.  Here I will demonstrate how to build a Microsoft form and manage data by using it. 1. Firstly, you need to log in to your Microsoft account if you are not already. (Please note Mi...