Entering dates into a Google Spreadsheet is straightforward; you can simply type the date out in a cell, but there is a better way; by using data validation. We'll explore how to add data validation to enter dates here. Once a date has been added manually, if you double-click on the cell again, you’ll notice that a date picker appears, which is useful when you want to adjust it later. However, there are occasions when you might like to have this date picker appear in all cell

The VLOOKUP function is unquestionably in my top 5 most used functions.

There are 6 simple steps you should take to smarten up the header row in a table

Have you ever Googled a currency exchange rate or asked Google to convert one currency value to another? If you search for something like “exchange rate for euros to pounds”, you’ll get a result something like this: Did you know that Google has a function built into Google Sheets called the GOOGLEFINANCE function that returns current and historical financial data? You can use this Google Finance function within a formula to provide real-time stock market prices, internationa