Skip to main content

Posts

Showing posts from May, 2016

Featured Post

Boost Your PC Speed by Using SSD

In short you can explain an SSD (Solid State Drive) as modern HDD (Hard Disk Drive). What's the difference then? Maybe the functions are almost same but there are some big differences between the two. Go through the post to clear the concept . . .

What's an SSD A solid state drive or SSD is a storage device that uses non volatile flash memory along with necessary controller and chipset to store the data. It's somewhat like RAM, but unlike RAM it can store data for a long period of time. 
An SSD drive is considered to be more durable and stable in that sense - There is no moving parts i.e. platters, spindle, R/W head etc. which are available in traditional HDD.  

Advantages of SSD over HDD If you use SSD as your primary boot device instead of HDD then you may get the following advantages -  Faster performanceLower power consumptionBetter vibration resistanceLower heat No noiseIn short we can say, SSD is more durable and stable than traditional HDD. 

After installing SSD, you will…

Converting Numbers into Words in Excel

Well, actually MS Excel doesn't include any direct function to convert your numeric values into words. But with the help of Microsoft Visual Basic, you can input a module in your worksheet and convert numbers into English words. Let's do this - 


Applies to Excel 2003Excel 2007Excel 2010Excel 2013Excel 2016

Prepare Workbook for Conversion Run MS Excel (I'm using Excel 2016).Open a new/ blank workbook.Press Alt+F11 to open Microsoft Visual Basic.Go to the Insert Menu > Module > Copy and paste the following code in the blank box.Press Alt+Q to close and return to Microsoft Excel.Go to the file menu and save this workbook as Excel Macro-Enabled Workbook (*.xlsm). I.e. Word Converter.xlsm. That's it!

Function words(fig, Optional point = "Point") As String    Dim digit(14) As Integer    alpha = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Ni…

Use Hue/ Saturation to Modify Color in Photoshop

Adobe Photoshop offers some extraordinary photo editing tools that make it a great program to the users. Hue/ Saturation is one of them. With this tool you can modify the color of your photos and images. Let's explore this tool . . .


Necessary Tools Adobe Photoshop (I prefer CS5 or 6)Some photos or images (I prefer flowers)




Using Hue/ Saturation Open Photoshop.Go to the File Menu > Open an image you need to modify.Now go to the Image Menu > Adjustment > Hue/ Saturation (Keyboard Shortcut: Ctrl+U)You will get three options: Hue to modify the color, Saturation to adjust the amount of color > Lightness to adjust the lighting.Move the slider of Hue (left to right or right to left) and observe the changes.You can also try other options here (at your own responsibility).Finally, press OK and Save your image. That's it!

Showing you some Illustrations:
Example 1



Open it using photoshop > Image > Adjustment > Hue/ Saturation > Change the value of Hue from 0 to -55. And…

Claim your Business on Google Maps . . .

In my previous post I discussed about adding your business to Google Maps. And in this post I would like to talk about claiming a business on Maps. If your business is not already listed on Google then you can read my previous post. But if your organization is already listed then you're good to go . . .


Prerequisites for Claiming your Business Your business should be listed on Google Maps

Necessary Tools Android Phone with GPS & Data ConnectionGoogle Maps ApplicationBrowser (I prefer Google Chrome)My Business App (Optional)





Steps in Claiming the Business Open Google Maps on your Android Device.Search and locate your business on Maps.Tap on your business and it will prompt you to a new window.Choose the option - Claim this business.Now you will be redirected (maybe by your web browser) to this address - business.google.com.Here you need to confirm your business. Tick the option - I'm authorized to manage this business . . .  > Continue.Tap on the Mail button > Google will s…

Add your Business to Google Maps!

Google Maps is a great communication app developed by Google. Millions of entities are already listed on it. But your own business may be missing here. If you'd like to add your business to Google Maps, follow this post . . . 


Necessary Tools

Android Phone with GPS & Data ConnectionGoogle AccountGoogle Maps AppMy Business App (Optional)
Adding your Business to Maps Get your Android Phone and turn on its GPS & Data Connection.Make sure you're signed into your Google Account and its services.Run Google Maps from your Phone.I guess you're exactly on your business spot. Make sure the location indicator is in exact position.Now click on the menu button from the upper left corner.Scroll down and choose Add a Missing Business.Add a Place > Enter your business Name, Address, Category, Phone Number, Web Address, Photos etc. If the location indicator doesn't locate your position exactly, then you can use this option (Mark Location on Map) from address.  Make sure everythi…

Got a New Phone? Clone it Easily!!

Android Devices are getting smarter everyday with new features and styles. A handset you're using today, may not use tomorrow. But you may need to get back everything from your old phone. And CLONEit is capable of importing everything from your old mobile. Got a new phone? Try it now . . . 




About the Tool Name: CLONEitCategory: ToolFile Type: APKFile Size: 4.1 MBDeveloper: SHAREit TechnologiesOffered by: Super Tools Corporation100% Free!

Features & Benefits The simplest way to clone your mobile12 Types of data can be transferred including contacts, messages, apps, call logs, SMS, MMS, pictures, musics, videos and even your system settings!Fast, safe & reliableNo computer or cable is required except the Wi-Fi network of two devices





Using CLONEit . . .  Download CLONEit from Google Play or fromthis link.Both of your handsets require this tool. So install it on both devices.Now run CLONEit on your old and new mobiles.On your old device, hit on the Sender button. And on your new dev…