Posts

How to Highlight Duplicate values in Excel

Image
How to Highlight Duplicate values in Excel Watch the video for detailed Explanation: ( Click the chapter to directly view that chapter in video ) -------Contents of this Video------ 0:00 - Introduction 0:20 - Highlight Cell Rules 0:45 - Highlight cells greater than a value 1:19 - Give custom format in cell rules 1:58 - Highlight cells for values in between 2:20 - Highlight cells for a specific value 2:46 - Greater than condition for string 3:08 - Between condition for string 3:30 - Highlight cells with text that contains specific value 4:04 - Highlight cells with duplicate value 4:34 - Highlight cells with unique value 4:55 - Highlight cells with dates with specific condition 6:32 - How to delete applied conditional formatting rule in Excel 7:09 - Conclude

How to use VLOOKUP & HLOOKUP Function in MS Excel

Image
How to use VLOOKUP & HLOOKUP Function in MS Excel Like FB page HandPicked Songs VLOOKUP & HLOOKUP functions are mainly used to fetch a specific data from a bulk of data that we already have. So in general, We can state like we are going to look for a data we don't know with a data we already know from the sheet. VLOOKUP & HLOOKUP function are almost similar. The only difference is like VLOOKUP search for data which are fed vertically and HLOOKUP search for data which are fed horizontally. Watch the video for detailed Explanation: ( Click the chapter to directly view that chapter in video ) -------Contents of this Video------ 0:00    - Intro 0:36  - Difference between VLOOKUP & HLOOKUP

How to restore old photo viewer in Windows 10

Image
How to restore old photo viewer in Windows 10 Like and share our page Technology Reveals Here Sometimes the new photo viewer app in windows 10 seems bulky. Here is a quick and simply way to get the old photo viewer of windows in Windows10. Download the registry file and merge it. Done!!! Now you can see the app in change application section. View video for more details.  Share this page on Facebook

How to save picture or video status of friends in Whatsapp

Image
How to save picture or video status of friends  in Whatsapp   Like and share our page Technology Reveals Here Whatsapp is experimenting a lot of new features in the app to compete with other similar apps. Whatapp Status is improved recently in such a way that we can post pictures and videos. That will get shared to our friends with a predefined time interval.  By default we can't save the status to our phone. Some peple may took screenshots if they like their friends status. But what will they do if they want video? The answer is so simple because Whatsapp download those status and save it in side it's folder in the phone memory, but the folder is hidden from user. We need to navigate to the folder and copy the contents. First of all you need a file browser to see the hidden files. Then navigate to the folder Whatsapp >> Media >> .Statuses   Detailed description is available in the video. Feel free to comment.

How to apply default Black theme and night mode in Windows 10

Image
How to apply default Black theme and night mode in Windows 10   Like and share our page Technology Reveals Here The Night mode and   setting default app mode to black is a boon for those who stare at monitor for a long time. Windows 10 creator update consist these settings by default, which protect your eyes and help to work more time with less strain. To enable dark theme: Right click on desktop Select Personalize Select Colors Scroll down to see 'Choose your default app mode' Select Dark To enable Night mode: Go to Settings Click on System In the Display tab , you can see Night light .  Turn it on Click on Night light settings to set color temperature , time schedule etc. If you want to turn it forever , turn schedule off and press 'Turn on now' Like and share our page Technology Reveals Here Share this page on Facebook

How to use different font for whatsapp messaging

Image
How to use different font for whatsapp messaging Like and share our page Technology Reveals Here This video describes, how to use another font face and font style for the messages we send through whatsapp. Play the video for steps. Subscribe the channel for future updates. See More... How to use two whatsapp simultaneously in an Android device without rooting. How to download videos from YouTube, Facebook etc with Android phone.  Happy learning.. Share this page on Facebook

How to download videos from popular websites like Youtube, Facebook, DailyMotion, Vimeo etc with Android device

Image
How to download videos from popular websites like Youtube, Facebook, DailyMotion, Vimeo etc with Android device Like and share our page Technology Reveals Here This video describes, how to download videos from YouTube, Facebook, Vimeo, DailyMotion  etc with your Android device. It's very simple and described in a way such that a beginner can understand. Play the video for steps. Subscribe the channel for future updates. See More... How to use two whatsapp simultaneously in an Android device without rooting. Happy learning.. Share this page on Facebook

HOW TO USE TWO WHATSAPP/FACEBOOK ACCOUNTS SIMULTANEOUSLY IN AN ANDROID DEVICE

Image
HOW TO USE TWO WHATSAPP/FACEBOOK ACCOUNTS SIMULTANEOUSLY IN AN ANDROID DEVICE Like and share our page Technology Reveals Here This video describes you how to use use two accounts in the apps which is not allowed by default. From Android lollipop version, there is an option to create two user accounts which is not available in previous versions. This method is very simple and can be use in the new versions for easy switching.  One of the important advantage is that, you will get notifications from both accounts on the notification pane. Play the video for steps. Subscribe the channel for future updates. Happy learning.. Share this page on Facebook

Technology Reveals Here Video Channel Trailer

Image
Technology Reveals Here video channel release on 1-6-16 Subscribe our channel. Like and share our page Technology Reveals Here www.Youtube.com/SagaValsalan Share this page on Facebook

How to open more than one Android applications at a time in your computer

Image
How to open more than one Android applications at a time in your computer   Like and share our page Technology Reveals Here The answer is very simple. You can use more than one Android applications simultaneously in windows with Bluestack 2 [Download link inInstallation procedure]   Bluestack-2 enables us to use more than one app at a time like tabs of a browser.  Bluestack released a new version named Bluestack 2 with various new features added. Main features are, Multitasking is easier  Can easily import files to and from computer Shake button is added{Some applications which use shake function in your phone can also installed and use} Can download as a single file of 283MB . {Earlier version of installation file can be downloaded in small size but it will download this much data while installation.}  Take Screenshot and directly send it via apps or save in your PC.{You can do it with snipping tool of Windows also.}  Enables us to assign keys

How to convert Mbps to MBps or Kbps to KBps

Image
  What is the difference between Mbps and MBps or Kbps and KBps Like and share our page Technology Reveals Here Most of the people have a misconception that 1 Mbps speed means 1 MB data will transfer in 1 second. But it's not like that actually. Simply for converting 1 Mbps to MB , just divide it by 8. That is 0.125 MB (125 KB ) data transfers in 1 second. Detailed discription. 1 Mbps -- 1 M ega b its p er s econd 1 MBps -- 1  M ega  b its  p er  s econd 1 MBps = 8 Mbps 1000 Kbps = 1 Mbps These are transfer rates or speed. Don't confuse it with size of files. For size, 8 bits = 1 byte 1024 bytes = 1 KB 1024 KB = 1 MB and so on... Convert it simply 256 Kbps = 256/8 = 32 KBps 512 Kbps = 512/8 = 64 KBps 2 Mbps = 2/8 = 0.25 MBps 2 Mbps = (2*1000)/8 = 250 KBps Multiplication with 1000 is for converting Mb to Kb (Don't use size conversion factor 1024). Dividing by 8 is for converting bits to bytes

How to install adroid apps in PC without Bluestack or Youwave [How to setup Android x86 using virtualbox]

Image
  How to install adroid apps in PC without Bluestack or Youwave [How to setup Android x86 using virtualbox] Like and share our page Technology Reveals Here Here i am describing, how you can install Android [ any version-Upto kitkat is available ] on your PC without installing emulators like Bluestack, Youwave. Here the things you needed are 1. Virtualbox [Direct link]   [Torrent] 2. Android-x86-4.4-r2   [Torrent] NB: You need any torrent donloading software [ u torrent ] [ Bit torrent ] before using the torrent link. Magnetic links are provided here   Download both files, then install Virtual box and open it. You will see this. *Click on New * Type a name for your device, select type LINUX and version Other Linux 32 bit *Select RAM memory you want, am using 1024 MB *Select Create Virtual hard drive now *Select the option VDI *Select Dynamically allocated *Click Create *Now Select te device you created and click Start *C