Dates are notoriously finicky to use in spreadsheets. You can’t type them into a formula and expect it to work. However, there are a few different ways to use them in formulas. Once you know how, using dates is much easier. Method 1 – Surround Dates and Times with Quotes For the first example, dates … Read more
How Dates Work Though it may not be obvious initially, spreadsheets store dates as numbers instead of text. You can show dates in many different formats to the user, but their underlying value doesn’t change. To illustrate the concept of the format changing but not the value, all of the rows in this table consist … Read more
See the four depreciation functions and their differences.
Learn about Google Sheet’s four depreciation functions – SLN, SYD, DB and DDB.
Google 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 … Read more