In this article I am going to explain How to check whether your driving licence is linked with the Aadhar number in online in Andhar Pradesh State. Please find the steps below to check the Aadhar to Driving Licence status check online in Andhra Pradesh.
Steps:
1) Open the RTA web site https://aprtacitizen.epragathi.org
2) Click on Licence --> Aadhar Seeding Search
3) Enter Driving License No, Issued Office, Date of Birth and the Aaadhar Number in the text boxes and click on Search Button
4) If the Aadhar Number is Linked with the DL Number then It will display the details otherwise it show Record Not Found. Please find the screen shot below.
5) In the below Image I have taken another Driving Licence Number which is linked with the Aadhar number. The Search will be displayed the details in the below row and the Status of the Aadhar linked to Driving Licence number.
You can also check the same in the YouTube Video link
https://youtu.be/GCxPB3jRJDY
Thursday, April 1, 2021
Monday, March 8, 2021
Excel - How to Roate or Align Text in Excel Sheet Cell
In this article I am going to explain How to Rotate text in Vertical, Horizental, Angle Clock wise, Rotate text up and Rotate Text down..
Steps:
1) In the Excel sheet column you can type the text you want to Rotate.
2) Select the column and from the Home Tab click the Orientation button. It will dispaly all the text Roation options from the Orientation List. You can also right Click on the column and click on the Format Cells option and in the popup window you can the text rotation.
3) Now select the option which you need to align to the Text. The available options are Align Counterclockwise, Align Clockwise, Vertical Tex, Rotate Text Up and Rotate textdown.
4) Based on your selection the text is changed.
Please find the screen show below where for each option one sample is provided in the below secreen shot.
Steps:
1) In the Excel sheet column you can type the text you want to Rotate.
2) Select the column and from the Home Tab click the Orientation button. It will dispaly all the text Roation options from the Orientation List. You can also right Click on the column and click on the Format Cells option and in the popup window you can the text rotation.
3) Now select the option which you need to align to the Text. The available options are Align Counterclockwise, Align Clockwise, Vertical Tex, Rotate Text Up and Rotate textdown.
4) Based on your selection the text is changed.
Please find the screen show below where for each option one sample is provided in the below secreen shot.
Saturday, February 27, 2021
WhatsApp - How to send Formatted Messages in WhatsApp Chat in Android Phone
Here in this article I am going to explain How to send formatted text messages in WhatsApp Chat in Android Phones.
If you want to send Message in Bold type add the asterisk (*) before and after your text message
*text*
If you want to send Message in Italic type add the underscore (_) before and after your text message
_text_
If you want to send Message as Strikethrough add a tilde (~) before and after your text message
~text~
If you want to send Message as Monospace type three backticks before and after your text message
```text```
Also in Android phone we can use the shotcuts by Tap and hold the text that is entering in the text field and then select the options that are available for the bold, italic in the list.
You can also check in the youtube link
https://youtu.be/xegyvE8RVfs
If you want to send Message in Bold type add the asterisk (*) before and after your text message
*text*
If you want to send Message in Italic type add the underscore (_) before and after your text message
_text_
If you want to send Message as Strikethrough add a tilde (~) before and after your text message
~text~
If you want to send Message as Monospace type three backticks before and after your text message
```text```
Also in Android phone we can use the shotcuts by Tap and hold the text that is entering in the text field and then select the options that are available for the bold, italic in the list.
You can also check in the youtube link
https://youtu.be/xegyvE8RVfs
Friday, February 26, 2021
Wallpaper Carousel - How to Disable Lock Screen Wallpaper Carousel In MIUI
In this artcile I am going to explain How to Disable the Lock Screen Wallpaper Carousel. Please find the steps below to disable to Wallpaper Carousel..
Steps:
1) In mobile phone click on the Settings.
2) In the Settings -> Search Box type the text Wallpaper.
3) It will display all the apps that are having the text Wallpaper. Select the Wallpaper Carousel.
4) When you click the Wallpaper Carousel it will display the Option Turn On or Off button.
5) Click the Turn On or Off Button to Enable or Disable the Wallpaper Carousel on mobile phone Lock Screen.
Please see the below screen shot.
You can also view the same in the Youtube Link
https://www.youtube.com/watch?v=ORNObSN_sTo
Steps:
1) In mobile phone click on the Settings.
2) In the Settings -> Search Box type the text Wallpaper.
3) It will display all the apps that are having the text Wallpaper. Select the Wallpaper Carousel.
4) When you click the Wallpaper Carousel it will display the Option Turn On or Off button.
5) Click the Turn On or Off Button to Enable or Disable the Wallpaper Carousel on mobile phone Lock Screen.
Please see the below screen shot.
You can also view the same in the Youtube Link
https://www.youtube.com/watch?v=ORNObSN_sTo
Thursday, February 18, 2021
GMAIL - How to Edit or Delete contacts in Gmail Contacts List
In this article I am going to explain how to Edit or Delete Gmail Contats.
Steps :
1. Login into your GMAIL Account.
2. Open the Link in the another tab https://contacts.google.com/
3. It will display all the contacts that are available in your gmail account.
4. Move the cursor on the contact which you need to edit. It will dislay the Edit Contact option. Click on Edit it will open a popup window. Now you can edit the contact details and click on save. Please check the screen shot below.
5. To Delete the contact, Move the cursor to the contact you want to delete. In the Contact it will show three dots. Click on the three dots it will show you the menu item where you can select the delete option. It will remove the contact from your contact list. Please check the screen shot below
You can also view the same in below youtube channel link
https://www.youtube.com/watch?v=k-SXU54udEk
Steps :
1. Login into your GMAIL Account.
2. Open the Link in the another tab https://contacts.google.com/
3. It will display all the contacts that are available in your gmail account.
4. Move the cursor on the contact which you need to edit. It will dislay the Edit Contact option. Click on Edit it will open a popup window. Now you can edit the contact details and click on save. Please check the screen shot below.
5. To Delete the contact, Move the cursor to the contact you want to delete. In the Contact it will show three dots. Click on the three dots it will show you the menu item where you can select the delete option. It will remove the contact from your contact list. Please check the screen shot below
You can also view the same in below youtube channel link
https://www.youtube.com/watch?v=k-SXU54udEk
Tuesday, January 26, 2021
How to Close Your LinkedIn Account
In this article I am going to explain how to Close your LinkedIn account permanently deleting your profile and removing access to all your LinkedIn information from the site.
Steps:
To close your LinkedIn account
Step1: You need to LogIn into your LinkedIn account.
Step2: Select the tab under your profile picture in the top toolbar
Step3: Select the option “Settings and Privacy” from the dropdown menu
Step4: In the “Account” tab select the option “Closing Your LinkedIn Account”
Step5: You can select the reason for closing your account and click “Next” button. Select the option “other” if none of the reasons apply to you and then you click “Next” button.
Step6: Enter your password and select the option “Close Account” button.
Same is explained in the youtube channel
https://www.youtube.com/embed/VG4XFl36WaU
Steps:
To close your LinkedIn account
Step1: You need to LogIn into your LinkedIn account.
Step2: Select the tab under your profile picture in the top toolbar
Step3: Select the option “Settings and Privacy” from the dropdown menu
Step4: In the “Account” tab select the option “Closing Your LinkedIn Account”
Step5: You can select the reason for closing your account and click “Next” button. Select the option “other” if none of the reasons apply to you and then you click “Next” button.
Step6: Enter your password and select the option “Close Account” button.
Same is explained in the youtube channel
https://www.youtube.com/embed/VG4XFl36WaU
Monday, January 25, 2021
Excel - Date functions
I am going to explain Microsoft Excel Date funtions in the below article. Microsoft Excel provides a bunch of Date functions to work with dates and times values. Here I am going to explain most of the time we use to calculate Age, Date formats and difference between two days with the samples.
TEXT Funtion
The TEXT function uses to convert dates to a text string.
Syntax : TEXT(value, format_text)
With the syntax of TEXT(value, format_text) function, we can change the dates to text strings in a variety of formats. Some sample formats are as explained in the following below screenshot.
DATEDIF Funtions
DATEDIF function is used to calculate the difference between two dates in days, months or years.
Syntax : DATEDIF(start_date, end_date, unit)
We have to provide the Unit argument as d, m or y to retun the no of days, months or years. Below I have provided the sample and also the same explained in the screen shot.
=DATEDIF(C2, TODAY(), "d") - This will calculates the number of days between the cell value in C2 and today's date.
=DATEDIF(C2, TODAY(), "m") - This will returns the number of complete months between the dates in C2 and today's date.
=DATEDIF(C2, TODAY(), "y") - This will returns the number of complete years between the dates in C2 and today's date.
Calculating the difference between two dates columns are explained in the below screen shot. The screen shot showing is no of years differrence in the two days. If you want no of days between the two days you have to give unit section as d instedad of y in quotation marks.
You can also view the same in the below you tube link
https://www.youtube.com/watch?v=KS-GiSNV7cY
TEXT Funtion
The TEXT function uses to convert dates to a text string.
Syntax : TEXT(value, format_text)
With the syntax of TEXT(value, format_text) function, we can change the dates to text strings in a variety of formats. Some sample formats are as explained in the following below screenshot.
DATEDIF Funtions
DATEDIF function is used to calculate the difference between two dates in days, months or years.
Syntax : DATEDIF(start_date, end_date, unit)
We have to provide the Unit argument as d, m or y to retun the no of days, months or years. Below I have provided the sample and also the same explained in the screen shot.
=DATEDIF(C2, TODAY(), "d") - This will calculates the number of days between the cell value in C2 and today's date.
=DATEDIF(C2, TODAY(), "m") - This will returns the number of complete months between the dates in C2 and today's date.
=DATEDIF(C2, TODAY(), "y") - This will returns the number of complete years between the dates in C2 and today's date.
Calculating the difference between two dates columns are explained in the below screen shot. The screen shot showing is no of years differrence in the two days. If you want no of days between the two days you have to give unit section as d instedad of y in quotation marks.
You can also view the same in the below you tube link
https://www.youtube.com/watch?v=KS-GiSNV7cY
Subscribe to:
Posts (Atom)










