Tutorials

Comparison of Depreciation Functions in Google Sheets

by

Google Sheets offers four methods to calculate depreciation on your fixed assets. We’ll use the example asset outlined below to compare the different techniques. Basic information about the fixed asset’s depreciation: Asset Cost – 36,000 Salvage Value – 3,000 Life – 5 years Year SLN – Straight Line DB – Declining Balance DDB – Double … Read more

Filter Functions – FILTER, SORT, SORTN, and UNIQUE

by

Sheets offers functions for sorting and filtering data. On the desktop version of Sheets, the SORT and FILTER functions are available through the menus as shown in the pictures below, while the tablet version has a ‘Create a filter’ option in the more (three circles in a vertical line) menu on the right-hand side of … Read more