States In Australia

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

Twitter Facebook LinkedIn

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

Leave a Comment