Skip to main content


Showing posts from 2012

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

How to Change or Create Password in Windows 8

If you're still using the earlier versions of Windows then you may thought creating or changing a password in Windows 8 is same as previous versions. But those who are working with Windows 8 know that this is not same at all. 
When you are installing Windows 8 for the first time then you can set a password at the end of the installation process. If you skip that step during the time of installation then you will have to set it from the PC settings. 
In earlier versions of Windows password can be managed from a control panel item named User Accounts. This item is still available. But you can't manage your password from here. Today I will show you the easiest way to do this task. 
Remember: Your Windows should be genuine or it may ask you to activate windows while doing this task. So, if you have any problem regarding activation then visit: Windows 8 Activation Process.  Press Start + W > type Password > select Change your password. Or you can simply press the Start button and…

How to Change Windows Password without Knowing it !!!

Today I'm gonna write about an amazing trick for you! By this time you've already understood about what I'm talking about. Yes, you can change windows password without knowing it. But PC should be in a running condition! 
This is a very easy method. If you're new user then you might face some problems. But mid level user can do this within few minutes. But your PC should be in the Administrator mode to do this task. 
This system has been tested for Windows 8 and 7. But this method may also work on Windows XP. Okay let's start. 
Open Command prompt as Administrator. XP users don't require Administrative mode. Now type this command and press enter- net userNow type another command and press enter- net user Administrator *Type the new password and press enter.Retype the password and press enter.If password is changed then you will see the message- the command completed successfullyRemember: When you typing the new password, you cursor will not be moved. Don't b…

The Fastest Possible Ways to Improve Alexa Rank

Certainly Google Page Rank or PR is the most effective and reliable way to estimate the value of a website or blog. No other method is as dependable as PR. But recently Alexa Ranking is becoming a popular ranking method. 
In PR system a site is valued in a scale from 0 to 10. The higher the PR the higher is the rank. In this system thousand of websites might have the same rank. For example, both Google and Facebook's rank is PR 9. 
But in Alexa Ranking the sites are ranked from 0 to last. The lower the position the higher is the ranking. Though Alexa Ranking is still not as popular as PR even many advertisers are interested in it. And hopefully it will be a popular ranking method in the near future. 
Today I will tell you about the best effective ways to improve the Alexa Rank of your site. If you follow these methods properly I'm sure you can easily take your site from 10,000,000 to 100,000 within just 1 month! 
I'm recommending you the following 8 tips.  Update your site regu…

Place Alexa Review Widget & Boost Your Alexa Ranking!

Dear Visitors! Good evening. Hope you're alright. 

This is another post about Alexa. Hopefully, it will also help you to increase Alexa Ranking. You can also read the following posts with this one:  How to Create Custom Alexa Toolbar for a Site?How to Claim a Site in Alexa?Benefits of Using Alexa Toolbar.How to Insert Alexa Traffic Widget in a Site?Writing reviews for a site in Alexa is very essential to increase the traffic rank. Alexa gives importance to that sites which have more reviews. But is it logical that users will find Alexa Review link for your site? Or would they like to search your site in Alexa? Then they will review it? 
That's very funny. Certainly they will not do it. That's why you should place a Review Widget in your site. So that interested person can easily write a review for your site. Simply copy and paste the following HTML code in your site. You're done! 
Hope you've got my points. Let's do it. (This Method is for Blogger Only!) Sign in int…

How to Create Menu or Tabs in Blogger Blog?

I'm gonna post a new topic after a long break. I'm very sorry for those people are looking for new topics. Actually I was not getting new ideas. If someone is looking for a specific content then he might use this option to inform Marks PC Solution. 

OK let's start our today's concern. This post is specially helpful for blogger users who are trying to set Tabs in their blogs. And many of you may not know that there are two ways for creating tabs. I'm gonna discuss about both the methods one by one. 
Tips for Blogger
Method 1: This system is powered by blogger itself. This system allows you to create stand alone pages in your blog. Stand alone means you can only post a single topic in this page. For example, Contact Us or Report Us etc. This system may be less popular but still useful for creating a single but important post. 
To add Tabs in this system follow the instructions below:  Sign in to your blogger dashboard. Now click on the Pages button from the left panel.If y…

How to create Password Reset Disk for Windows XP

Anytime you may forget your password. Or someone who knows your password may change it to challenge you! 
That’s why Windows XP has a system to create a reset disk for forgotten password. No matter how many times the password has been changed. This disk will allows you to reset the password until you re install Windows XP on your system.
And if you're using Windows 7 or 8 then Read This
And don’t be confused. This reset disk only work with your computer. It will not work in any other system.
To create a reset disk, all you need is just a USB flash drive and your current password (if any).
Let’s start-
To open Control Panel Press Start + R > Type Control > Press EnterDouble click on User Accounts and Choose AdministratorNow select Prevent a forgotten password from the left panel\Press Next > Next > TypeCurrentPass (if any) > Next > NextFinish

Caution: Anyone can change your password using this disk! So, keep it in your safe. 

Create Password Reset Disk for…

Create Automatic Screen Shots of Your Tasks with Steps Recorder!

Dear readers! Couple of months ago I wrote about how to create screen shot by snipping tool. Snipping tool is an easy way to capture image or screen of any window. 
If you're interested to know more about snipping tool then click here
Snipping tool is a manual tool to capture image. But today I will discuss about Steps Recorder which is an automatic tool to capture image or screen. You can use it for different purposes. Say for example, you can use it to make tutorial of something. When are writing about how to do something then you can use this tool to record the process with your written instructions. 

Steps Recorder is built in with Windows 8. But it was also available in Windows 7 named Problem Steps Recorder. Only the name of this app has been changed everything remain same. 
To start and use the recorder follow the instructions below: Windows 8 users, Press Start and simply type Steps then choose the Steps Recorder. And windows 7 users Press Start + R > type psr > Press E…

Measure Your Site's Speed with Google Page Speed

Page speed is an important factor to increase the traffic of a site. Survey shows that most of the people ignore the sites that takes more than 3 seconds to load. Though the loading time depends mostly on the net speed. But excessive use of flash, JavaScript, Images can down the speed of any page even on a fast network. 
In this post I'm gonna tell you how can you measure your site's speed. There are several methods. As a standard way, I'm talking about Google Developers.

Let's test the speed now. Visit this page- Page Speed. Now type your site's URL in the box (ie. and hit the analyze button. Within few seconds you will get the result as below: The page Marks PC Solution got an overall PageSpeed Score of 95 (out of 100).

With this report, you will get some tips about how to optimize your site's loading time. Here are some tips to speed up your side:  Avoid unnecessary Java Scripts.Try to use compressed images.Try to avoid flash conten…

Place Alexa Traffic Widget on Your Site- Get Higher Ranking!

This post is a part of serial tutorial on Alexa. Earlier I wrote about-  Creating Alexa Toolbar for Your SiteHow to Claim a Site in AlexaBenefits of Using Alexa ToolbarAnd in this post I wanna tell something about Alexa Traffic Widgets. If you're a regular visitor of blogs and websites you might notice some widgets than shows Alexa Traffic Rank of that site. But this widget doesn't only show the ranking of that site. It does something more . . . 
Guess what? Helps to boost the ranking.  How? When someone visit a site and if there is Alexa Widgets, then Alexa got information of that site usage information from this widget. Thus it can increase your rank.  

Okay, I'm gonna stop the discussion and start the procedure. 
Method 1:  Visit Alexa Rank Widget page. Now copy and paste your site URL in the box and hit on the Build Widget button. (ie. pressing the button you will get 3 widgets. You can choose any of them. Copy the HTML code from any of th…

Dot Net Framework 3.5 Not Installing on Windows 8? Fix it Now!

You may face a common problem while using Windows 8. Microsoft .Net Framework 3.5 is not installed with Windows 8. And several programs may ask you install this. And you can't install this from your PC. It will ask you to connect to the net and use Windows Update. 

By default Windows 8 comes with .Net Framework 4.5 and it doesn't include 3.5. When you try to install .Net 3.5 that you previously downloaded from web the you will see the following message. 

And you will get the same message while installing some some programs that is developed using .Net 3.5 platform. And you will not able to run those programs on your PC! This is a very bad job by Microsoft. A great trouble for Windows 8 users. 

But today you will get the solution. You've install this using command line. I mean you have to use Command Prompt. And surprisingly you Windows 8 DVD includes the .Net Framework 3.5! 

Method 1 (Offline Installation using cmd): Enter your Windows 8 Installation Disk on DVD Drive.Now run

Claim Your Site in Alexa: Increase your Ranking!

A common tendency of bloggers and web masters is to increase their sites' ranking. The most popular ranking system is Google Page Rank. A page is ranked from 0 to 10 in Page Rank system. 
And another method is getting popularity day by day. Yes, I'm talking about Alexa Traffic Rank.  This ranking system still not as popular as Page Rank. But in the future it will be very popular. Couple of days ago I wrote about the importance of using Alexa Toolbar
And today I'm gonna show how to claim a site on Alexa. Definitely, if you claim your site in Alexa, it will give you a higher ranking in return! 
Okay let's start our mission.  At first create an account on Alexa following the normal rules as you usually do. Now follow this link to claim your site. Type your home page URL (ie.  in the Get Started box and hit on Claim Your Site.  Now you will get the sign up option. Choose the Free option. There will be 2 options. Follow any method that is suitab…

10 Exceptional Features of Windows 8- Upgrade to Enjoy!

I've already written more than 3 posts about Windows 8. But all of these were related to preview versions. And I'm writing this post just after installing the Final Version in my PC.  Built in Security for your overall PC protection! Built in Reader to view your PDF and XPS files! Live tiles that let you know the latest weather forecast, news updates, sports updates and so many.Touch friendly and drag and drop interface that eases the use of mouse. Don't be afraid. You can also use the keyboard shortcuts for Windows. Efficient use of hardware.Task Manager with new useful features. (Shift+Ctrl+Esc)New apps for view image and video, using camera.New apps for Mail, Messaging and connect with people. You can also integrate your Facebook account with Windows Mail. Great way of multitasking. Quickly switch between the apps. Press Alt+Tab or just move your mouse at the top left corner of the screen to switch the app. New Start Screen! That irritates many users. This is the most im…

Guidelines before and after Getting AdSense!

This topic might be very useful for those who wanna place AdSense Ad in their websites or blogs. In this post I'm giving you some guidelines that maybe useful for you to get Adsense and to maintain it after getting this. 
If you carefully follow these guidelines, it will be easier for you to earn some cash from Adsense. Otherwise you may suffer just like me! Regular visitor of this site should know that I've already rejected 4 times from AdSense Program! And waiting to be rejected for the 5th time! 
Let's start our AdSense concern. AdSense provide a specific set of rules for publishers. You can find it here- AdSense Program Policy. But very few of them read this carefully and consequently they suffer and lose their account. 
So I will try my best to make the rules clear to you. Let's start. 

Before Getting AdSense - Be Steady . . .

Your site must be easy to navigate. And it should be user friendly. It shouldn't contain any types of illegal, matured, adult or violent co…

Show your Recent Blog Posts as Headline !!

Recent posts widget can increase your page views to a great extent. When someone is on your blog and reading a topic he may find another topic useful from recent post list. So adding a recent posts widget is also important for attracting readers to stay long in your site. 
But there maybe many other widgets in your blog. And adding too much widget is boring and it also looks odd. 
Today I'm gonna share a code with you. This code will show your recent posts as headline! And certainly it will be space effective. It will take space just as a single line. All you need to do, is just add an HTML/ JavaScript gadget at the top of your site. 
First, sign in to your blogger account and go to design.Then hit on layout button from the left pane.Click on Add a Gadget (Select gadget from top).Choose HTML/ JavaScript.Now copy and paste the following code into the content box.Now save the gadget and view your blog.
<script style="text/javascript" src="…

Find your IP Address and Get Detailed Information about any IP Address!

Many days ago I wrote about how to find your IP address. And in this post I'm gonna write something more for you. If you read this post carefully, you will be able to know How to find IP addressHow to collect detail information about an IP including its location, ISP etcWhether it is blacklisted or notHow to Trace EmailNot only the above, but also you can do many things with the sites I'm sharing with you right now.
There are many sites available in the web for doing these tasks. But I am recommending you only the following sites: WhatIsMyIPAddress.comIP-LOOKUPWhatIsMyIP.comBut my personal choice is the first one. I mean What Is My IP Address. Let's start our operation. 
Click here to start. And let the page load in your browser. Now you will notice your IP at the screen as below.

Here you can see the detailed information about your own IP. If you wanna know something about any other IP then type its address in the Additional IP Details box and press on it. It will show you the…

How to Change the Drive Letters

Few days ago my PC got some problems. And I need to reinstall my Windows 8. After installing a fresh Windows, I got surprised! Drive D was missing from my drive list! 

What happened actually? D drive was automatically named as E. And all the drives' names were replaced by the next letter. Such as E with F, F with G and G with H. Though I don't the actual reason maybe it is caused by the new Windows, but I can show you how to get rid of this change. 
If you face the same problem, or just want to change the name of your drives, you can follow my instruction.  Right click on My Computer icon from desktop and select Manage.Now hit on the Disk Management from the left panel.Here you will get the list of your drives.Then right click on any drive that you wanna change, and hit on Change Drive Letter and Paths.Now Click on the Change andSelect another letter for this drive from drop down list. Finally hit on the OK button for twice. Open your Explorer to see the change. 

Stay with Marks P…