Method 1 (TEXT Function): Here values from which Name of the Month is to be extracted are in range C5:C9. If we wish to extract the name of the month using function, the below function will be used: Function: TEXT(Value, FormatText) Here the date or the address/reference of cell where the
Tips & Tricks
Boost the Speed of your PC
ReadyBoost is one of the best features of versions of Windows Vista onwards. ReadyBoost can be used to boost the performance of your PC by making use of USB Flash Drive as extra fast-access Cache Memory for frequently used files and data. When plugged in, USB displays a ‘Auto Play’
Block or allow pop-ups for a specific site in Google Chrome
To manually allow pop-ups from a site: At the end of the address bar, click the pop-up blocker icon. Click the link for the pop-up window you’d like to see. To always see pop-ups for the site, select “Always show pop-ups from [site]” The site will be added to the
Restore File Associations
USE AT YOUR OWN RISK. This solution will modify your windows registry. Please make a backup of registry before proceeding further. Download the below file, unzip it and run with administrative privileges: Download Restore Association Registry file This file restore all the incorrect associations of .LNK files. This has been checked on Windows 7 PC.
How to Share a Google Cloud Printer
Outlook is repeatedly prompting for pop and smtp passwords
User is using Gsuits for business mails. He created one new email Id on GSuits and is configuring the mail on Microsoft Outlook. While configuring, user is sure that every configuration setting that he is entering is absolutely correct but still MS Outlook is not able to connect and repeatedly
Using PING command in Chrome OS
For using PING command in Chrome you will need to open Crosh. To open the Crosh, press Ctrl+Alt+T anywhere in Chrome OS. The Crosh shell will open in a browser tab. CTRL + ALT + T will open Crosh tab with Crosh> command prompt. Type ‘PING <IP Address>’. In may case it was PING
How to Set Up and Use Google Cloud Print
Chromebooks do not support printing from local printers via USB port or network printers on other network. To print from your Chromebooks, you need to connect to the Google Cloud Print service and share a printer: Download and install Google Chrome to the computer where the printer is connected. Open the Google
Top Useful URLs for Google Users
Google stores everything privately and here are the 10 important links (URLs) that will unlock everything Google knows about you. They are hidden somewhere deep inside your Google Account dashboard and they may reveal interesting details about you that are otherwise only known to Google. Let’s dive in. 1. Google stores a list