Fiddling around in Excel on my Mac and realized that Page Down and Page Up are keyboard combinations Fn+Down Arrow and Fn+Up Arrow, respectively.
Normally, to return column 2 of a named range, you would use the following formula =INDEX(myTable,0,2). The zero means: return all rows (of column 2).
If you want to return row 2 of the named range you would use =INDEX(myTable,2,0). Here the zero means: return all columns (of row 2).
This comes from the Help section of the INDEX function where in Excel 2011 it reads:
If you set row_num or column_num to 0 (zero), INDEX returns the array of values for the entire column or row, respectively. To use values returned as an array, enter the INDEX function as an array formula in a horizontal range of cells for a row, and in a vertical range of cells for a column. To enter an array formula, press ⌘+RETURN.
I’ve finally memorized the fact that on a Mac, the Excel keyboard shortcut to repeat the last command is: COMMAND+6 (and not the beloved F4 like on a Windows machine.)
To count the number of weekdays, minus holidays for your working days, you can use the NETWORKDAYS function, which has three arguments: Start Date, End Date, and Holidays.
The holidays are usually a range of Holiday dates, but this last argument is optional. If Holidays are not used the formula returns the number of weekdays between the two dates. If there is a Holiday list, then they are subtracted as well.
Here is an example:
The Holiday List is a named range that refers to cells A6:A8 in this example.
The answer in cell C2 is 21 days. Meaning July has 21 working days, which are all the weekdays in July minus the 4th of July, which is a Holiday in the USA.
There is also a NETWORKDAYS.INTL which has four arguments.
There is a Parallels program that lets you switch seamlessly to Windows on a Mac. A another reason that makes it easier to run Excel for Windows on a Mac.