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 let us get this done via Google Script, it is a good choice if you are familiar with Google Script.

I don't think many of you would like to go with google script due to your Google Script Knowledge. This tutorial is intent to provide an alternative method using google sheet functions.


I assume you have opened a google sheet.
Now Copy and Paste the Data from this below sheet and name it "Data1"

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.
                                              This Error happens when capturing website articles as PDF. When we download a article from a link it takes sometime, you can stop the download by clicking on the Stop button on the download popup window rather if you click on the close mark on the right top it will cause the problem.





When you do it actually there is a background download is being done. But you don't have direct access to either stop or pause the download.










Solution

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 work with with all instances.

I have also tried filtering white spaces and  do a "Find and Replace" But It replaces all white spaces within a cell , what I actually mean is when there is a single space between 2 words. This removes all the white spaces.

I finally found google sheet is a good solution to solve this problem in no time. What you have to do is

1. Sign into your Google account. 
2. Create a blank spreadsheet. 
3. Now go and copy the data areas in your excel.
4. Now Paste the copied data into newly created google sheet. 
5. All the white spaces  will have been removed. 
6. Now copy the data from google sheet into your excel. 

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= the text from which we look for specific word
B2= the text which we are searching for

Description about this function. 

Subtract the length B2 cell from length of A2 cell and dive the all length by length of of B2 cell which gives the numbers of occurrences.

The functions used here are Len() and Substitute. 

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 to resize it. I'm a longtime user of Adobe Acrobat and Nitro PDF. Using both programs you can resize it.

How to Resize Using Adobe Acrobat.

1. First open your document which you would like to resize. 


2. Now Go to File >Print option. Actually you don't need a printer. By default it will be Adobe Acrobat. 


3. In the Open window Choose Properties which is located Top right. In the pop window choose Adobe PDF Settings.


4. Now Choose the Adobe PDF Page Size as you wish.


5. Click Ok and Save the file.

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.