Posts

Showing posts with the label Windows

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

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