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...

This is a very fascinating feature of excel to visualize your data and make it more constructive and impressive to the viewer. Let’s begin: We will be using the below table to demonstrate how to add icons to your data in excel Assume we want to ascertain our target status in the above table more visual with the help of  icon Sets  from the format conditioning Here is the code table. For instance, we have assigned -1 to depict target status as  Not Met , 0 to show  Met  and 1   if the target is  exceeded.  And   we want to assign format icons to these classes as per the below table: Now we have to convert Target Status numbers to text values ( Met, Not met & Exceeded) which we defined earlier and, we will do the same with the help of custom formatting. Step 1. Select the entire column and right-click. Select  Format Cells  from the available options  (Refer to the below screenshot) Step 2 . A new window will appear. Please...

Excel is a sea of very useful and compelling features. You just need to give proper time to explore and operate it in the best possible way. Here I am going to demonstrate how to portray your percentage data in excel in a way that not only looks professional but also, a great way to impress your colleague and boss with your reporting skills.  Let’s begin: Below is the sample table which we are carrying here to demonstrate this tool to you So, in this data table, in the ' Difference'  column we want to exhibit increase\decrease arrows to show if the sales went above the defined target or down. Step 1 . Go to the ' Insert'  tab from the menu and select ' Symbols'  from the right side. ( Refer to the below image) Step 2. A new dialogue box will appear with multiple options. Just choose required titles as shown in the below image and add both up & down arrows to your excel sheet. (Refer to the below image) Once the selection is complete, add both the symbols one...