Skip to main content

Posts

Showing posts from May, 2016

Featured Post

Changing Digit Grouping (Comma Style) in MS Excel - Million to Lakh

Well this is a very common problem for our sub-continent i.e. Bangladesh, India, Pakistan, Nepal, Maldives, Sri Lanka. Cause our digit grouping system doesn't match with the international system. To be more specific - they use million, billion etc. But we use - lakh (also lac), crore etc. 
Users of the mentioned regions often face problem with the comma separator position in MS Excel. Cause the default system is international. It doesn't suit our digit grouping system. 
International System - Separates every three digits 1,000.0010,000.00100,000.001,000,000.001,000,000,000.00
Subcontinental System - Separates every two digits after the 1st three digits
1,000.0010,000.00 1,00,000.001,00,00,000.001,00,00,00,000.00 
If you're familiar with the Indian Subcontinent system and if you're bound to use this system then it will be a big trouble if you don't know the solution. Well nothing to worry about as you are going through this article. Cause from the very next moment you'…

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…