Saturday, 12 December 2015
Google Sheet Conditional Formatting for Different Ranges
I'm an Excel user for may years and I'm good at working with excel conditional formatting. However When my clients asked me to do a google sheet conditional formatting to compare and Highlight two different list , i ran into a problem. The first thing i did was using the functions i use within Excel,
However Google Sheet doesn't support conditional formatting with 2 sheets. But Google...
Saturday, 3 October 2015
How to Solve Adobe Acrobat "Out of Memory" Error
This Acrobat Error happens often with My Acrobat Pro. I was searching online for a solution none of the articles gave me a solution finally i found the solution.
...
Friday, 19 June 2015
How to remove white spaces in spreadsheet

There is no in built function in excel for removing whites spaces when it appears at the end of a text or middle of a text , but you may wonder why can't we use the Trim Function. Yes, Trim () Function works when there is a white space at the beginning of a text area. But It doesn't...
Excel formula to Count Specific Words in a Cell
This tutorials shows you how to count specific words in excel cell. As shown in the picture we are going to find the number occurrences of word "Prince" in Cell "A2". On Cell "B2" is the word that we are searching for. The formula in cell c2 as below.
=(LEN(A2)-LEN(SUBSTITUTE(A2,B2,"")))/LEN(B2)
A2=...
How to Resize PDF Page Size

This article intend to show how to resize an already existed PDF's page size. Let say you have a PDF page which is in A2 size probably you would encounter problem with viewing in small device or you may feel it is too large to fit on your screen.
So solution you would find is how...
Sunday, 14 June 2015
Which is best payment method for freelancers
When it comes to get your money into your pocket it is vital important how are you going to withdraw. These questions may rise in your mind what payment methods are available to you, which is best for you? Choosing a right payment method can reduce your cost and can save your time.
Things to consider when you choose a payment methods
What are the payment methods supported to...
Subscribe to:
Posts
(
Atom
)
Popular Posts
-
This Acrobat Error happens often with My Acrobat Pro. I was searching online for a solution none of the articles gave me a solution finally...
-
This article intend to show how to resize an already existed PDF's page size. Let say you have a PDF page which is in A2 size probabl...
-
When it comes to get your money into your pocket it is vital important how are you going to withdraw. These questions may rise in your mind...
-
This tutorials shows you how to count specific words in excel cell. As shown in the picture we are going to find the number occurr...
-
There is no in built function in excel for removing whites spaces when it appears at the end of a text or middle of a text , but you may ...
-
I'm an Excel user for may years and I'm good at working with excel conditional formatting. However When my clients asked me to do a...
© Knowledge Meeting 2013 . Powered by Bootstrap , Blogger templates and RWD Testing Tool