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

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

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

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.

qrcode3

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.

qrcode4

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
Gmail


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


msexcel

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.

excelmergecell1

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

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

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.

excellmergecell4

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

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.

excellmergecell6
Gmail

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

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

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

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

https://contacts.google.com/
msword

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

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.

wordcount02

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

wordcount03

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.

wordcount4

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

wordcount5

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

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.

iPhonexbeyond

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.

  iphonesettingsiphonegeneral

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

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

snoozegmailandroid2

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

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.
 
snoozegmailandroid4
Now seems about the best time to teach you how to properly clean and sanitize your smartphone, as the spread of the COVID-19 coronavirus heightens our awareness of personal hygiene.

According to a 2016 study, we touch our phones on average 2,600 times per day. The same study also claims that we pick up our devices 150 times during a 24-hour period. 

Because smartphone use has only increased since then, it’s very likely that those figures are now even higher. So because of that, it, in means that our smartphones and tablets are highly prone to serious pathogens such as E.Coli and MRSA without factoring in the recent coronavirus epidemic — that is, if we don’t clean them correctly.

Things to avoid

Alcohol wipes and gels — anything over 70% alcohol will damage your display oleophobic coating.

cleanphone1

Compressed air — most compressed or canned air can be flammable and may cause device issues. It can also leave a damaging solvent coating that can discolor or damage your device.
 
cleanphone2

Water (on devices without IP ratings) — a small amount of water on an antimicrobial cloth will do no damage, but too much water can cause severe issues with your smartphone.
 
cleanphone3

Never dunk your phone, laptop, trackpad or keyboard in a cleaning agent or spray a cleaner or aerosol spray directly onto the product. That just raises the risk you’ll get moisture in openings like the charging port.  

Things you might want

Antimicrobial cleaning cloth

Screen protector + cleaning wipes

UV sanitizer

Wash your hands

cleanphone6

The easiest method of cleaning your Android phone and screen is to use an antimicrobial cleaning cloth. You can slightly dampen your cleaning cloth with lukewarm water or with 70 percent isopropyl alcohol and then gently wipe the display, bezels, and rear of your Android phone.
 
clean1

If you have a screen protector installed, you can wipe your display with disinfecting cleaning wipes. Alternatively, you can replace your screen protector regularly. The screen protector will ensure that your display is safe from any solutions that might damage the oleophobic coating or the phone itself.
Twitter

Tweets can now be scheduled in advance when composing a tweet on the web based version on Twitter.

Schedule a tweet for later. Follow the below steps to schedule posts on Twitter.

Step 1:  Log in to your Twitter account and open tweet composer window and type your Tweet.

Step 2: Click on Schedule Button
When you are ready to schedule your Tweet, Click on the Schedule button. 


Step 3: Set Tweet Schedule Date and Time
From the ‘Schedule’ window Set Date, Day, Year, and Time.


Step 4: When you’re ready to continue, click “Confirm.”



Step 5: Click “Schedule” to finish scheduling the tweet.

How to Find Scheduled Tweets or Draft Tweets on Twitter

Method 1: From the compose tweet window, Click on "Unsent Tweets."


Method 2: Directly by visiting this URL https://twitter.com/compose/tweet/unsent

From the Unsent Tweets window; Select Schedule Tab or Draft. 

How to save a tweet as a draft

If you don't want to finish a tweet in the moment and would like to come back to it, simply save it. Just follow these steps:

Step 1: Compose a tweet.

Step 2: From the compose window, hit the left arrow icon in the top left corner.


Step 3: Select Save.