Step 1: Open Excel then access “Insert” tab in the ribbon menu.

Step 2: In that tab, click on “Get Add-ins” option.

 

Step 3: Search for QR4Office add-in and then add it.

 

Step 4: Now again go to Insert tab, click on “My Add-ins” and select QR4Office add-in. This will open the sidebar of this add-in on the right side of the document.

Step 5: The add-in sidebar has multiple options which include:

• Select the type of QR code: Email, SMS, URL, custom text, etc.
• Color palettes to set QR code color and its background color. 
• Error correction level: Low (7%), Quartile (25%), High (30%), and Medium (15%). 
• Slider to change the size of QR code.
• Preview feature to see output QR code preview, its size, and input added by you. 

You can also right-click on QR code preview and save it as image.

Set the options and press “Insert” button. This will add the QR code in your document.

You can again change any of the options, generate as many QR codes as required, and then insert it into your document as many times as you prefer. 

Products supports the following versions of Microsoft office:

PowerPoint for iPad

Word for iPad

Excel 2013+

Excel 2016+

Excel 2016 for Mac

Excel Online

PowerPoint 2013+

PowerPoint 2016+

PowerPoint 2016 for Mac 

Word 2013+ 

Word 2016+ 

Word Online

Sohail

When locating an email by date, use the search bar at the top of the Gmail dashboard. Simply enter the relevant text/numbers and press Enter.

Locating an email before or after a certain date

In the following examples:

• YYYY = Year (e.g. 2020)
• MM = Month (e.g. 01)
• DD = Day (e.g. 23)

To locate emails received before a certain date, type into the search bar Before:YYYY/MM/DD and press Enter.

So, for example, if you want to search for emails received before January 17th, 2015, then type:

To locate emails received after a certain date, type into the search bar After:YYYY/MM/DD and press Enter.

For instance, if you want to search for emails that were received after January 1st, 2020, type:

Locating an email between two dates

Gmail also lets you locate emails that were received during a particular period by combining After and Before conditions in the advanced search function.

So, if you want to locate an email sent between January 1st, 2020 and January 3rd, 2020, type:

Locating an email that’s older or newer than a certain time period

In the following examples:

• Older_than looks for emails older than the specified days, months or years.
• Newer_than searches for emails newer than the specified days, months or years.
• D, M, Y denotes the day, month or year.

To find an email received longer than 6 months ago, type:

To locate an email received within the last 2 years, type:

Combining “before” and “after” with “newer_than” and “older_than”

And finally, you can get even more granular by searching for emails that were sent after a specific date, but that are older than a certain number of days, months, or years.

So, if you want to find an email received after Feb 1st, 2017, but that’s older than 5 months old, type:

Narrowing down your date search with keywords

Once you’ve gotten used to using date-based search syntax, you can start including keywords to further narrow down your search.

So, for example, you want to locate an email between November and December 2019 that was about invoicing, type:

(Note that, in this example, the search is started at the end of October and ended at the start of January to capture the full date range).

Sohail

In Microsoft Excel, merging is the process of creating one cell out of two or more selected cells.

Method 1

To merge cells using the Merge and Center tool on the ribbon, here's how:

Step 1: Select the cell range you want to merge.

Step 2: Go to Home tab, click Merge & Center command.

 

The selected cells will be merged, and the text will be centered.

 

Method 2

To merge cells using the controls in the Alignment tab of the Format Cells dialog box, here's how:

Step 1: Select the cell range you want to merge.

Step 2: Right-click on the selected cells, and click on Format Cells.

Step 3: In the Format Cells dialog box, select Alignment tab, then check on Merge cell checkbox.

 

Method 3

You can merge cells in Excel by simply pressing shortcut key: Alt+Enter. 

When merging cells and more than one of the selected cells contains data, the data in the upper-left or upper-right cells is kept and all remaining data is deleted.

When it prompts this warning dialog. Click on OK to confirm merge cells.

Sohail

Step 1: Log in to your Gmail account and click on the square-like Google Apps icon on the upper right corner of your Gmail inbox.

 

Step 2: The Google Apps drop-down menu will pop-up. Click on the Google Contacts icon.

 

Once you click on the icon, your Gmail contact list page will appear.

 

Alternatively, you can copy and paste this URL into your browser and go directly to your contacts.

https://contacts.google.com/

Sohail

How to Count the Number of Words in a Word Document 

Method 1 

Take a look at the status bar at the bottom-right corner of the workspace.

See more information, click it to open Word Count dialog box. 

 Method 2 

Step 1: In Word, go to Review tab, click Word Count in the Proofing group.

In the Word Count dialog box, you can see the number of: Pages Words Characters Characters excluding spaces.

Method 3

Step 1: Click where you want to add the number of words that are in your document.

Step 2: On the Insert tab, in the Text group, click Quick Parts.

Step3: In drop-down list of Quick Parts, click Field.

Step 4: In the Field names list, click NumWords, and then click OK.

 

Sohail

Sometimes you don’t want to be disturbed by email notifications from the Microsoft Outlook app on your phone, such as when you are in a meeting at work. The sounds and the screen lighting up can be distracting.

You might not want work emails to bug you at weekends when you are supposed to be relaxing and you certainly don’t want to be pestered in the middle of the night by emails that can wait until the morning. A good night’s sleep is essential if you want to be productive the next day.

To stop email notifications on Outlook for Android:

Step 1: Open the Outlook app on your phone and tap the menu button with three dashes in the top left corner to open the sidebar. 

Step 2: Press the bell icon at the top.

Step 3: The Do not disturb screen is displayed and you can use the controls to choose when to display or hide email notifications.

Make sure the email account you want to set the do not disturb on is active. You can verify which email account is active by the title in the menu. 

Timed

• Until I turn it off is an indefinite do not disturb. All notifications from the Outlook client are silenced until you chose otherwise.
• For one hour silences Outlook for one hour. The time to the right of the selection lets you know when do not disturb will expire.
• Until tomorrow keeps do not disturb in place until 8 am the following day.

Scheduled

• During events allows you to silence Outlook notification during any busy time on your calendar. This can include both appointments and meetings. This is particularly useful if you want to automatically quiet your email during meetings.
• During work hours allows you to silence Outlook notifications during work hours.
• During weekends silences Outlook notifications from Friday 5 pm to Monday 8 am.

Tip: Only one option under Timed can be active at any one time. However, all three of the Scheduled options can be active simultaneously. Also, any of the timed options can be used in conjunction with any or all of the scheduled options.

The Zz’s superimposed over the email icon also identifies which accounts currently have an active do not disturb in place. 

Canceling Do Not Disturb

To cancel or modify a do not disturb click the Do Not Disturb icon (Bell icon). This will bring up a menu where you can either disable or modify the do not disturb by selecting Turn off, or, Adjust Settings respectively.

Sohail

If your iPhone is running iOS 11, you can turn off your iPhone in the Settings app. 

Step 1: Go to Settings -> General and scroll all the way to the bottom of the screen.

 

Step 2: Then, tap Shut Down and swipe the power icon from left to right.

Turning your iPhone back on is simple: just plug it in to charge over USB. Your iPhone will start up a few seconds after it starts charging (as long as the battery isn’t dead, in which case it takes longer).

Sohail

Step 1: On your Android phone or tablet, open the Gmail app Gmail.

Step 2: Open an email.

Step 3: In the top right, tap More icon with three dots and then Snooze.

 

Step 4: Choose a later day and time to get the email.

 

To snooze multiple messages, select the messages, then tap More icon with three dots and then Snooze. 

Step 1: On your Android phone or tablet, open the Gmail app Gmail.

Step 2: In the top left, tap Menu with three dashes and then Snoozed.

 

Sohail