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.
Master Excel Shortcuts On a Mac.
Office (Excel) on iPad in November [Report] -
More fuel to the fire.
I hope they are taking their time and getting this right instead of being naturally slow to respond. (I can dream, right?)
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.
(Source: excelsemipro.com)
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.)
Microsoft doesn’t want to stop OnLive’s service, just make them pay for it. -
You would think that Microsoft would have created an Office Suite of apps for the iPad already.
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.
The Find and Replace dialog box in Excel 2011. Open with the keyboard shortcut Command + F. Click the Replace button to replace text from the Find box. You can also choose Within: Sheet or Workbook.
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.