Archive for 'tips and tricks'
Mac tip – showing folder sizes
By default, in the Mac finder you can see the size of individual files but not folders (unless you click on “get info” for each one.
However it’s easy to set the option to see the folder size. Just go Finder, View, Show View Options, and select the “calculate all sizes” box.
Bear in mind that the [...]
Posted: May 2nd, 2010 under tips and tricks.
Comments: 1
Currency conversion in Google spreadsheets
This is pretty useful and I can never remember the exact syntax, so here it is for me (and now you) to remember.
In a Google spreadsheet, you can do an online currency conversion that looks up the exchange rate in real time, making my life much easier.
For example to get EUR to GBP just type
=googlefinance((”CURRENCY:EURGBP”))
(note: [...]
Posted: November 9th, 2009 under Business, tips and tricks.
Tags: google spreadsheets, tips and tricks
Comments: 2
Spreadsheets: how to count weekdays between 2 dates
One of the things I often need to do is to calculate the number of work days between 2 dates in order to calculate billable days. There is a very useful function called NETWORKDAYS which does exactly this. It works the same in both Excel and Google Spreadsheets
The syntax is =NETWORKDAYS (start_date, end_date, [holidays])
example =NETWORKDAYS [...]
Posted: November 9th, 2009 under tips and tricks.
Tags: excel, google spreadsheets, tips and tricks
Comments: none