less than 1 minute read
List of Australian States and their Capital Cities.
| State | Abbr | Capital City |
|---|---|---|
| Australian Capital Territory | ACT | Canberra |
| New South Wales | NSW | Sydney |
| Northern Territory | NT | Darwin |
| Queensland | QLD | Brisbane |
| South Australia | SA | Adelaide |
| Tasmania | TAS | Hobart |
| Victoria | VIC | Melbourne |
| Western Australia | WA | Perth |
Categories: lists
Updated: March 18, 2020
1 minute read
Here’s the simple steps to highlight the row and column of the selected cell which can be extremely useful when navigating large sets of data. Here’s a littl…
less than 1 minute read
How it Works Using SEARCH and ISNUMBER When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functio…
less than 1 minute read
So you have a 0% value on one of your data labels and want to hide it?
1 minute read
Download the example workbook here: calculate-time-between-dates.xlsx