Skip to main content

Posts

Showing posts from March, 2014

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'…

Got my 1st Payment from Google AdSense!!

To be honest, I'm really surprised. Just 20 days ago, I shared a success story - 2nd Payment from 360 Ads! In that post I mentioned, due to the transaction issue, my AdSense Payment is not coming to bank account. But only a few days ago, I got my Payout from Google AdSense

Only a few months ago, Google introduced Bank Wire Transfer for Bangladeshis. And I selected this payment system immediately. Then Google sent $272 to my Bank Account. But the payment was rejected by Citi Bank NA Singapore due to compliance issue. And I got disappointed. 

Then I've contacted AdSense team. They assured that, the problem will be solved soon. Days were passing but I found no luck. Again they sent payment of $438 on 21 February, 2014. And I was continuously checking my bank account. Few days later, AdSense Compliance Team informed me that they need some additional information to verify my account. I've provided the necessary information. 

After checking my Bank Account for more than 10 times,…

Related Posts Widget for Blogger

Hey bloggers! Hope you're running your blogs fine. Today I'm gonna share a simple  related posts widget with you. You know how important it is. A related posts widget can retain your visitors. It helps to increase visitors' engagement with the site. Have you noticed, when you visit a site to know something and get a related post just at the end of that post you also read the related post! 

Let's consider my own case. Few days ago I visited My Blogger Tricks to know something. At the end of the post there were 05 related posts. I've also read one of those related posts. From that post, I discovered another posts which I like! After reading the 03 posts from that site, I've used the search option to find another post. 

And this only happens due to the related posts widget. Instead of one pageview, My Blogger Tricks got at least five pageviews from me. And I spent almost an hour on that site! Can you imagine? One hour instead of five minutes. And this is exactly wha…

Convert PPTX to PPT Online!

Hey Guys! Stil using the old version of Microsoft Office? Office XP or 2003? Then you could be trapped several times! Because Office 2007 or later versions save your file with extension x. Such as docx, pptx, xlsx. Last year I published a post about how to convert DOCX to DOC Online. And this time, I am gonna show how to convert PowerPoint files - PPTX to PPT Online! 

Actually I've found a nice tool for you. With this tool you can convert your files within this page! Look at the online converter below. You just need to upload your PPTX file to convert. 



Convert PPTX to PPT Online!







Hopefully you can easily understand the procedure. Or follow the instruction below:

Hit on the Choose File button.Now locate your PPTX file from hard disk and select it.Hit on the Convert PPTX to PPT button. You will be redirected to a new page. (It may take few seconds)Open or Save your file from there. (Look at the image below)




Remember: This site doesn't store your converted file. And it will be remove…

Verify WordPress Site in Google, Bing & Yandex

WordPress, you know, the most sophisticated platform of blogging. It has both free and premium versions. But free version doesn't let you customize the theme or edit CSS. That means, if you don't go premium, you can't edit the code of your WordPress site. But WordPress allows you verify the site in Google, Bing & Yandex through Website Verification Services. 


Last year, I published a post on Blogger Vs. WordPress. If you're interested to know more about blogger and WordPress, you can have a look. 


What WordPress Says about Site Verification & SEO?
WordPress provides enough information about your site's traffic. But if you would like to know more, then you can verify your site in Google or Bing Webmaster. Though it's not necessary to verify your site to be indexed by Google, Bing or other search engines. WordPress itself takes care of your site and it does all necessary SEO for you. When you publish new post, WordPress automatically sends data to search eng…

Convert Image into Icon Online!

Creating icons is somewhat difficult task. The giant photo editing tool I mean Adobe Photoshop has no option to convert an image into icon. Even the graphics master Adobe Illustrator doesn't have any icon format save option. But there are some converters which can convert image into icon. And most of these tools are premium. In Marks PC Solution, I hardly discuss about premium tools. :) 

What is Icon?
Icon is a special type of image format. And normally it's not used to share photos or images. Usually icons are used in folder or hard disk drive to distinguish it from others. And normally icon is small in size. It maybe 16x16, 32x32 or 64x64. 

Do you remember, In 2012, I wrote a post about Showing Picture on USB Flash Drive. And that custom picture must be an icon. That means the picture format must be .ico in order to show in USB drive. 


Show Custom Picture on Pen Drive




iConvert Icons: Convert Icons Online for Free!
This is a free online tool. This site allows you to create icon onl…

Shut Down, Restart, Sleep & Hibernate Shortcuts!!

If you are bored with shut down option of your Windows, this post is for you. Not only shut down, this post will guide you create shortcuts for restart, sleep, hibernate and lock too. After creating the shortcuts you can keep them either on desktop, task bar or start menu. And this post is gonna be the most useful topic for Windows 8 users who face problem while shutting down or hibernating their PCs. 

Well this trick can be applied to Windows XP, 7 and 8. And I am writing this post in Windows 8. If any step is not matched with earlier version of Windows, then I apologize. 

Let's begin with Shut Down options of Windows 8:  Windows Charm: As made for tablet computers, Windows Charm is a touch friendly feature of Windows 8. If you tap your finger at the upper right corner you will get this in touch devices. In desktop, move your mouse pointed to the upper right corner to open the Charm. Or you can also press Windows Key + C to open the charm. Then hit on the Settings button and click o…

Remove Unwanted Spots by Content Aware

All of you are familiar with Adobe Photoshop. Everybody knows Photoshop is a great tool to work with images. It's really helpful to edit image. The latest version of Photoshop is CS6. Today I am gonna write about an amazing option of Adobe Photoshop - Content Aware. It's a magical tool. With this tool, you can vanish unwanted spots or area from your photos just like a magician! 

System Requirement
Unfortunately content aware is a new feature of Photoshop. It's just added to the CS5 version. Even CS4 doesn't have this cool feature. But if you're using CS6 then you will get this option under the Edit menu. 

About Content Aware
As mentioned earlier, Content Aware is a new feature of photoshop. Photoshop version CS5 (or higher) users can enjoy it. With this tool you can remove unwanted spots or area from an image. 
Of course you can do this with the help of Clone Stamp Tool. But in this method you have to choose sample from one area and copy it to another. And sometimes it …

Understanding the Parts of a Keyboard

Most of the computer users are confused about the parts of the keyboard. Sometimes users can't distinguish among the different parts. However you can operate your PC without understanding the parts of a keyboard. 
Graphical user interface lets you operate computer using mouse. Most of the commands are now performed by mouse. And the advent of touch screen could be the reason of the departure of keyboard! But real PC users can't leave it. I'm capable of typing up to 70 words per minute in normal keyboard. But in touchscreen, I simply hate typing. :( 
Anyway, today I'm gonna discuss about the parts of a keyboard. I was searching information to write this post for few weeks. And I've been able to collect sufficient information. And now I am sharing with you. 

Don't be confused! I'm not talking about mini keyboard. Here my concern is normal keyboard. 

Look at the image below:



The parts of a keyboard are clearly outlined here. Each part has seprate color. So you will…

Move Site between WordPress & Blogger

New bloggers are often confused about choosing the right platform for blogging. Most of them choose either WordPress or Blogger to start blogging. But after few months or years, depending on your requirements you may think to switch your platform. Both WordPress and Blogger let you move the site easily. And they support each other! 


You Should Know -

All of your posts will be moved with comments and images.No data will be deleted from your current site unless you delete it. You can back up your site as XML file.Images will be stored by server URL.However you will lose your SEO score or rank.
The transfer procedure is almost similar both in Blogger and WordPress. 


Blogger to WordPress

This is the most common situation. Most of the new bloggers start writing on Blogger. When they need more resources, they shift their sites to WordPress. In fact, when a blogger becomes professional, he usually moves the site to WordPress. 

If you would like to move your site from Blogger to WordPress, then you…