Influence Professionals

1. Notification’s settings  Getting notifications of the necessary apps and email is crucial. Windows 10 has this feature that we can set alerts for certain applications and programs, and also much more. However, getting these alerts for all the programs and emails is most of the time is annoying, and we need to make necessary modifications as per our requirements. To do so >> Go to the Home>> Systems >> you will see Notifications & actions on the left>> Make necessary alterations as per your need. Settings page with Notifications tab 2. Change default color and size for mouse pointer Although it is not much of a useful function, we can personalize it as per our preferences by adjusting the dimensions and color of the pointer. Furthermore, when you alter the appearance, it is easier to navigate. To do so>> Go to Home >> Ease of Access >> On the left side of widows you will see the Mouse pointer (Refer to the below image)  Se...

VLOOKUP is an exceptionally impressive tool in Excel which allows you to locate values in a table or range by row. It is very advantageous  when you need to work on a huge chunk of data and find things from the other sheets or workbooks. Here is the formula =VLOOKUP (What is the source reference value, from where you want to reference it with and pick the desired data, Column range for the desired value, Add 0(False) if you need exact outcome or add 1(True) if you need approximate value). You need to keep a few things in mind before I will explain it through an example. The reference value is also called the Lookup Value, and It should always be in the first column in the lookup range to work this formula without an error. Sample1 . Now take the example of the below table. Suppose we have two sheets ( Sheet1 & Sheet2 )    Sheet 1 Sheet 2 As per the above Image, we have huge data in sheet1 with multiple data fields, and sheet2 only has a name. Now we want to...

Windows 10 has been released with several unique and thrilling features. Being a successor of Windows 8.1, it has carried all the functions along with some additional ones. Here I will explain a theme function that i find very fascinating and compelling to use Adding high-contrast feature This function is very useful if you want to accentuate each & every text or app on a particular page or window. For example, if I want to change the background color for all the applications that open and highlight its function with a different color or outline it, I will use this segment. Here are the steps to enable it: Search in the menu bar > Change contrast Theme and click on that (Refer to the below screenshot) Windows Menu search bar Once the window is opened, you will see a option to turn high contrast on or off , slide the bar to turn it on (Refer to the below screenshot) Turn on\off toggle button O n sliding the turn-on toggle , the please wait window will appear for 3-4...

Although we can reset our windows machine with an internal tool Reset my PC and can restore our OS efficiently. However, this method tends to fail in the middle of the processing due to one or another error, and we get stuck with no OS in our system. In such cases, we need an external bootable Pendrive loaded with the latest OS to install the same from the top. Here are the few steps you need to complete to build a bootable Pendrive for the latest OS. 1. Connect your USB drive to your System. 2. Go to this link and click on the Download tool now ( Refer to the below screenshot ) 3. Once you click on the Download tool now button, it will download a small executable file Named MediaCreationTool . Double Tap on that. 4. It will open a new dialogue box after you double-click that file. It will prompt you to Accept\Decline the License Terms. Please Accept the terms( Refer to the below screenshot ) 5. After Accepting the agreement, it will give you two options to choose from. The firs...

Excel is an excellent tool for Data entry, analysis, programming, accounting, task management and much more.  It is up to our aptitude and understanding how we want to use this robust tool to examine and cultivate our data. Here I will demonstrate about simple IF function and how you can use it more effectively to get the desired results. Example 1 : Suppose you want to analyze some financial values for the entire year, and you have a budgeted amount and the actual invested amount. Now you need to see if you have gone under the allotment cost or over budget during the whole year. Here is the sample data: Sample Data Table Now you want to see if you have over-spent or stayed under the specified cost. Here is the formula. IF Formula for the Sample Table As per this formula, if <B2> (Budgeted Amount) is less than <C2> (Total Spending) then it should say Over Budget , else Under Budget Sample Table with IF Formula Very straightforward. Isn’t it? Let’s try some more sampl...

Nowadays, most of the professionals are working from home due to ongoing covid situation, and many of us still did not get fully satisfied with the standard laptop models, due to several related problems ex. Heavyweight, heating issue, low configuration and many more…Here I am going to explain the top 3 laptop models which are full of great features, and durability. Of course, I have operated on all of these machines and sharing my experience with you guys. 1. Surface Laptop 4 This one is the latest model, and I recently worked on this machine. Very slick, weightless and commendable battery life, these 3 features make it ideal for anyone working from home. Microsoft has remarkably done a great job producing this model. This is not only quite contemporary, but also a high-performance and swiftness is unbeatable in this price. I have been using it for the last 6 months continuously and never had any software or hardware-related issues. I would give it a 10/10 rating and certainly recomme...

Macro in Excel is an incredibly valuable function that allows us to automate numerous repetitious tasks. Once a Macro is made, you can execute it as many times you want and whenever you want. This saves our time while minimizing some repetitive acts. Below are the steps you must to follow to create a Macro As you can record any task that you conduct often, here I am assuming an example of conditional formatting. Apparently, we continually verify for duplicate data in your report. In order to do so, you have to go to Conditional Formatting Tab >> Highlight Cell Rules >> Duplicate Values >> then you need to select which colour you want to have for duplicate entries >> once you are done, all the duplicate date will get highlighted   Ok Now we will automate try function. 1.  Go to the View tab in the menu bar and click on Record Macro ( Refer to the below screenshot) 2. Once you click on that, a new window will be opened, Enter Macro Name and pick Sho...

Excel has a massive amount of functionality and components. Just need the right triggers and measures to make the most benefit out of it. Here I will again present a few amazing excel tools which would be a terrific help for you to generate compelling reports. Specifying user data type inputs in excel columns means that you can design a report where you can restrict users to enter precise data types only in defined excel columns such as Date, number, time text length etc. Here are the few steps you need to follow. 1. Go to the menu Tab and select Data. click on Data validation in the right top of the data bar ( Refer to the below screenshot ). 2. Next, a fresh window will appear on the screen. Choose the Validation Data type that you want to be specified ( Refer to the below screenshot ) 3. We can also specify the Data range type from Data drop-down list ( Refer to the below image ) For example, I want people to enter dates specific between 24-Jan-2022 to 31-Jan-2022 in the precise...

MS Outlook is a hub of awesome tools and features. While everyone knows the usage of outlook. It is an email client, and its functions include calendar, task managing, contact managing, note-taking, journal logging and web browsing. Here I will explain a few notable hidden functions: 1. Add or remove the number of lines in the email preview  Yes, you adjust the message preview span in the mail outlook window by following these steps. Go to the view tab on the top >> Select Current View >> Message Preview > choose Off if you don’t want any preview and pick number of lines if you need a preview. O nce the above steps are complete, it will prompt you to select if you want these modifications to be applied to the current folder or all mailboxes . Choose as per your requirement and you are done.  2. To view your pending\flagged task on the main outlook window It is crucial for any office employee to organize their pending task and complete those on\before timelin...

We all love to do our work in a hurry personally or professionally, and shortcuts are the best way to achieve the same. So why don’t you try these incredible time-saver outlook shortcuts to boost productivity at work? Here is the list: CTRL + 1 - Suppose you are in some other outlook window such as Calendar and you want to switch back to your outlook main screen, simply press Control + 1 CTRL + 2 - Use this shortcut to switch to Calendar tab instantly CTRL + 3 - To switch instantly to the task window CTRL + SHIFT + A - This is to make instant new appointment CTRL + R - Simply press these two buttons to send a reply to an email CTRL + SHIFT + C - To add new contact in Outlook CTRL + SHIFT + M - To open windows to compose new Email. CTRL + O - To open a received message CTRL + ALT + J - Mark mail as Junk CTRL + SHIFT + G - To add flag a message CTRL + Q – To mark message as read

Please refer How to do a Mail-Merge in MS Office to pursue this article further. I am going to explain the steps to send personalized emails to a huge group of receipts by looping people\groups in an email CC. Though, there is no straightforward technique for doing so. But there is one trick that functions like a charm. The trick is that we will create a new outlook rule which indicates whenever we send an email with the specific subject line, it will automatically include certain group\people in the CC. Steps to create this new rule in Outlook 1. Go to Rules in the menu bar and select Manage Rules & Alerts. 2. Then a dialogue box will appear. Click on the New Rule and choose Apply rule on messages I send in the following wizard (refer to the below screenshot) and Click Next. 3. In the subsequent window, tick the first line, which says with specific words in the subject line in Step 1 and click on a specific word from Step 2 (Refer to the below screenshot). 4. On clicking ...

Mail-merge is an excellent feature of MS office that lets you send personalized emails, letters, also allows you to print addressed envelopes for a large group in one go and much more. We can either send individualized mail to a big group of receipts or can either take a bulk printout of a huge list of addresses with minimal effort. Here is the series of steps which you need to perform in-order to do a Mail-merge in Outlook 1. As usual, create an excel data sheet with all the necessary columns such as receipt name, email, date or whatever you want unique in each mail to be sent. Here is the instance. Below is the mail-merge bulk excel file we have prepared. It has the email ID for the users, to whom we want this mail to be sent and other distinct details that we would require in our mail merge. 2. Below is the example mail structure we prepared in MS word, which we are going to send to the users. This mail has all the required data columns ( Highlighted Red ), which will be picked f...