Skip to main content

Posts

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…

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. http://munnamark.blogspot.com) 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…

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

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="https://sites.google.com/site/…

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…

Remove Powered by Blogger Widget from your Blog!

You may wanna remove the powered by blogger text from your blog that shows at the end of the page. But this task is not very easy if you don't know the proper way. If you try to do it just by editing the template, for sure you will not be able to do so! 
Because this text is set up by a widget. Without proper guide you can't find this code! So, in this post you're getting a guide to remove this text. Follow my instruction.  Sign in to your blogger account. Then hit on the template button. Click on the Edit HTML option and proceed to the next step.Then mark the option named  Expand Widget TemplatesNow you've to delete a minor portion of the template just below this line- <b:section class='foot' id='footer-3' showaddelement='no'/>Press Ctrl + F to find this line. And select and delete the following lines as shown in the image below.

When you press the delete button you will show the following image:




Hit on the delete widgets button as indicated …

Hidden Option Can't be Unchecked? Fix it Now!

If you look at the above picture, you'll notice the property of a hidden file. And carefully look at the attributes. The option Hidden is checked. And you will not be able to uncheck this. Because this option is disabled. 
In this situation you need to view the files by unchecking the protected operating system files from folder options. Which is very annoying. Because this option reveals many unnecessary files with your required files. 
Today I'm gonna share a cmd command by which you can easily unhide all files and folders from a particular drive.  Press Windows Logo Key + R.Type cmd and press Enter and you will see command prompt window.Now type this command: attrib -s -h K:\*.* /s /d This will unhide all files and folders of the drive K. Remember K is name of the drive in which you wanna run the operations. If you wanna unhide the folders of any other drive ie. D, then type D instead of K.

To view all hidden files and folders of your PC, follow this instructions:  Go to My Compu…

Convert a Webpage into PDF Online- No Registration!

Sometimes you may need to copy something from a webpage. If you need to copy only the text then you can copy the text and paste it to any program. But sometimes you may need to copy the whole site including the pictures and original formatting. In that case, what should you do? 
Today, I'm gonna share a site with you. Using this site you can easily convert any webpage into PDF and download it in your PC. You don't need any other software to do it. Even you don't need to register! It's free!  NB: Of course you need to register if you wanna enable some extra option. 
The site I'm talking about is PDF My URL.  When you need to convert a webpage into PDF, first copy the URL of that site. ie. http://munnamark.blogspot.com/Now go to the http://pdfmyurl.com/. Then enter the URL you wanna convert. ie. http://munnamark.blogspot.com/And finally hit on the button looks like P with down arrow. Immediately a PDF file will be start downloading in your PC. 
Stay with Marks PC Solution

Domain Name Extension for All Countries

Net users sometimes need to know the domain name extensions. So ,in this post I am sharing the domain name extension for almost all countries. If you need to know a specific domain abbreviation or the domain name of a country you can simply search by Ctrl +F then type the extension or country name. 

DomainCountry Domain Country A .adAndora.aoAngola.aeUnited Arab Emirates.aqAntarctica.afAfghanistan.arArgentina.agAntigua and Barbuda

.arpaAdvanced Projects Research Agency.aiAnguilla (U.K.).atAustria