MS Excel Tips

Want to have several lines in a cell?

To add a line break (line change) in a cell, use Cmd-Opt-Enter (Mac) or Alt-Enter (Windows).

Where is the Personal Macro Workbook located?

In MS Excel Mac, it could be located in either /Users/<your user name>/Library/Application Support/Microsoft/Office/Excel or Users/<your user name>/Documents/Microsoft User Data/Excel

When Excel is opened and you want to see this "hidden" workbook, go to the Windows menu, then click Unhide...

Formulas

How to construct date from year month day?

=DATE(2012,12,31)

How to get day of week from date?

=WEEKDAY(DATE(2012,12,31))

VBA

Here are some Excel Visual Basic tips.

How to find the last cell in a column?

LastCellRow=ActiveSheet.UsedRange.Rows.Count

Functions in other languages?

Ever got stuck because your Excel software is not in English and the tips you can find on the web have the English functions? Use this to translate Excel functions from one language to another: http://wwwhome.ewi.utwente.nl/~trieschn/excel/excel.html