Skip to main content

Posts

Showing posts from February, 2015

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

Tight Policy for Adult Contents on Blogger!

After March 23, 2015, sexually explicit or nude contents are not allowed to publicly share in sites hosted by blogger. But Blogger will allow nude contents only if it is artistic, educational or scientific. Nothing was clearly mentioned about sexually explicit text - policy changed only for images, videos and graphics.


All of you know that Blogger is one of the major blogging platforms next to WordPress. It allows us to share our personal views, opinions, ideas with the world. Above all, it's a social media. And Google is trying to punish those who are earning through sharing sexual contents. 


Previous Policy

Earlier, it was allowed to share sexually explicit videos or images in blogger. And such blogs should be marked as "Adult". So that the visitors can understand that they are about to enter a site with adult contents.


Settings > Other > Adult Content? > Yes > Save Settings. 



But Google has changed its policy. And certainly this is a good move to keep the web s…

Tutorial on Goal Seek (Project File Included)

Goal Seek helps you to find a specific target from a given data. Suppose you are required to adjust either cost or price or production unit to make a certain amount of profit. In this situation, you can use Goal Seek to find out the optimum level of input to meet your target. Here you must know that the Goal Seek can only work with a single variable. 

Note: This tutorial is prepared on Excel 2013. Excel 2007 and 2010 will be much similar to version 2013. 


Example 1

Let's start by a simple example. Go to Excel > Open a Blank Worksheet > Input the data as shown below:



The red figures are negative values.

Input the figures in Sales for Product A, B and C.Enter Cost of Goods Sold in the next row.Deduct 3rd row from 2nd row to find out the Gross Profit. (i.e. =B2-B3)Enter the other expenses in the 5th row.Deduct expenses from Gross profit to find Net Profit. (i.e. =B4-B5)
Important: you must find out the Gross Profit, Net Profit through formula. Otherwise, the Goal Seek function may no…

Transcend - The King of Flash Drives

Very often, I face a common question - which flash drive should I purchase? Or which flash drive do you use? Or which flash drive is faster? Considering a number of factors, the answer is Transcend and always. Transcend is a brand which I can trust and recommend to others. It's the king of USB flash drives!

Flash drives you know are the most commonly used devices for offline file sharing. When we share a movie, large software or documents we usually use USB Flash Drives or Micro SD Cards. If you need to transfer the files faster and your drive is slower, definitely it kills your valuable time.


If you want super speed, then you must go for USB 3.0 Flash Drives. But your device may not have supports for this. In that case, you will get only USB 2.0 features. And some brands will charge you too much. So, I always prefer Transcend considering the following factors: SpeedActual Storage CapacityCompatibilityDurabilityWarrantyPrice
To be honest, the speed varies with the models. But I can as…

AddThis Social Sharing Sidebar for your Site

AddThis sharing sidebar is a very common gadget for social sharing. Smart developers or bloggers often use AddThis tools in their webpages. Because it looks nice and thus attracts many visitors to share your contents in their networks. And I also like it because it's small in size and loads faster. 

If you would like to design your own sharing buttons, then it's okay. But if you're thinking of third party tool, then I recommend AddThis. It's very easy to setup. You've to register in AddThis website. There you will get a dashboard which provides your sharing analytics!

Limitation
AddThis has both paid and free tools. Of course the paid users get more benefits. Suppose if you're a free user, then you will not have button counts in your gadget. 

Registration/ Sign Up
First you've to create an account in AddThis. Creating an account is very easy here. You can sign up via Google, Facebook or Twitter. Or you can simply create an account through your email ID. The link…