Skip to main content

Posts

Showing posts from December, 2013

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

Customize the Default Settings of MS Office

This is somewhat difficult to write about. Delivering the message to the reader is somewhat complicated. New users of Microsoft Office may not get my point. But a regular  user of Microsoft Office must understand what I'm talking about. 

What is Default Settings? 
When you open up a new document in MS Word (Suppose Word 2010), you get the followings:  Paper Size: Letter (8.5*11)Orientation: PortraitFont: CalibiriFont Size: 11Font Style: RegularLine Spacing: 1.15After Spacing: 10 ptMargin: Normal (Top, Bottom, Left, Right: 1")And so many . . . This is called the default settings Microsoft Word. The settings you get just after opening a program is called the default settings of that program. The developers try to use the most common settings as the default settings. So that most of the users don't need to change the settings frequently. 

But the reality is quite fantastic! Every organization has its own method of working. Every person has his own choice. Naturally we need to mo…

Customize Your Blog by Blogger Template Designer

If your site is made by Blogger, then you should be familiar with Blogger Template Designer. This is really a lovely way to redesign your site with custom color, look, layout etc. But many new bloggers don't know about it. I've already helped some new guys in blogging. Believe it or not, they shared their password with me to redesign their sites! 
Today I would like to discuss about Blogger Template Designer, so that new bloggers no longer need to share their passwords with meto redesign their sites. This method is as easy as editing a MS Word Document. :) 

The advantages of using blogger template designer are:  Coding knowledge is not necessaryJust select and preview your lookYou can easily back to the previous look 

What can you do with Template Designer?
With template designer, you can modify the following things:  Templates: Lets you change your template. Background: Allows you to change the background and color. Adjust Widths: Change your site's width and sidebar width. Lay…

UniJoy Layout: Unicode Bengali Typing System

16th December!The Victory Day of Bangladesh. Regular visitors of Marks PC Solution know that, we hardly celebrate any National or International day. But today I've a topic to write about! Though it is more relevant to the International Mother Language Day, I can't wait until 21st February. Today I am gonna talk about UniJoy Layout: Bengali Keyboard Input System. 

Well you know this is not my first post about Bengali Typing. Earlier I've published posts about: Type Bengali with Avro KeyboardRules for Bengali Typing in PDF (Bijoy Layout)
Most of the people are now using Avro Keyboard to type Bangla in Unicode. Bijoy has also introduced Unicode Bangla typing system for few years. But it has failed to meet the users' demand. The first reason is that Bijoy demands money from the users. The second reason is it's inability to run smoothly. 

Bijoy can't run well in Windows 7 or 8. Where Bijoy 2003 was excellent for Windows XP, Bijoy 2010 and 11 are below standard for Windo…

How to Check the Performance of Antivirus?

It's been a long time since I discussed about PC security last time. Because I've talked about MSE and Windows Defender. If you use any of the two in your PC, I believe you don't need any other security tools to protect your PC. But if you use any third party security tools or if you've any doubt about your current security software, you can check its performance by a sample virus

Windows users often purchase security software ie. Norton, Kaspersky, Bit Defender etc. Many of them use trial versions to protect the system. But how much safe you are? Are these tools really working for you? Can these tools detect viruses or worms? Let's check it!  Go to Run by Pressing Start + RType Notepad and hit EnterCopy and Paste the following code on notepadNow Save the file as Virus.exe Scan the file with your antivirus
X5O!P%@AP[4\PZX54(P^)7CC)7}$EICAR-STANDARD-ANTIVIRUS-TEST-FILE!$H+H*
If your security tool is strong and if it has real time protection system, then you don't …

How to Create Transparent Image by Photoshop?

I'm really sorry for the long break in writing. I published the last post few weeks ago. Because there were weeks but no weekends. Due to the serious political crisis in Bangladesh, Banking Sector and business activities were down. And Govt. was trying to recover the loss through continuous banking. And I had to attend the office every day. In this week, bankers got weekend finally. And I'm gonna publish a new post. 
This is an exclusive post for this site. I've never published any tips on Adobe Photoshop. This is the first time I'm writing about Photoshop. Today I will discuss about creating transparent image. You know transparent image has no background color. It looks very smart when transparency is used with any design or logo. A logo with a white background is not as fine as transparent logo.


If you use transparency, only the image or logo will be displayed. There will be no background of that image. If you place the logo in a black color, background will be black.…

Page Setup & Printing Tips for MS Excel

Beginners are usually scared while printing from Microsoft Excel. They face problem when setting up page or margin. I had the same problem few years ago. Remember, when you can't do something, never give up. Try to do it with care. You will learn through mistake. I've just wasted some papers to understand which option does what. And thus I learned how to print excel workbook properly . . . :) 

In this post, I'm gonna discuss about Page Setup, Margin and Print option of Microsoft Excel. Since I'm using version 2010, it will difficult for me to show the related screenshots of 2003 and 2007. But I will try to make it clear for the users of previous versions. 

Microsoft Excel 2003: 
Before I begin, I'd like to say you, upgrade to Office 2010. This is really an amazing version of Microsoft Office. If you're still using 2003 or 2007, you're just missing the magic! Okay let's start -

Page Setup: You should set up your page properly to print a workbook. Otherwise …