Excel Fun

EXCEL: Play the evergreen PACMAN on Excel. Download now !

http://www.systemfunda.com/forum/viewforum.php?f=5
-------------------------------------------------------------------
EXCEL : Keyboard shortcut to open Microsoft Visual Basic Editor 

ALT + F11 opens the Microsoft Visual Basic Editor, to create macro by using VBA (Visual Basic for Applications)

Try it out.
-------------------------------------------------------------------
EXCEL : Calculate the time difference between two times

=TEXT(C4-B4,"H") Hours between two times.

=TEXT(C5-B5,"HH:MM") Hours and minutes between two times. 

=TEXT(C6-B6,"HH:MM:SS") Hours, minutes, and seconds between two times.
-------------------------------------------------------------------
EXCEL : Use 'Wrap Text' to accommodate sentences / long words in one cell.

Text in cell longer than the width of the column? And constraints on column width?

Use Alt + H + W.

Try it out.
-------------------------------------------------------------------
WORD : Shortcut for Subscript and Superscript

Subscript - Ctrl + =

Superscript - Ctrl + Shift + =

Try it out.