|Icebreaker, Energizer and Recap Activities|
|Install CommCare for Android Smartphones|
|Android Phone Screen Projection to your computer|
|Adding a horizontal line to Excel charts (Target value)|
|CommCare Data Export Tool|
|Common Logic and Calculations|
|Beginner Tutorial Part 2 - Navigating and Preparing the Application Builder|
|Maintenance and Downtime Announcements (Archived)|
|Move within a range:||Ctrl + Directional Arrow|
|Select cells:||Shift + Directional Arrow|
|Select a range:||Ctrl + Shift + Directional Arrow|
|Fill/Copy Formula across range:||Ctrl + R; Ctrl + D|
|Beginning / End of sheet:||Ctrl + Home / Ctrl + End|
|Cycle between sheets:||Ctrl + Page Up / Ctrl + Page Down|
|Bold / Italicize / Underline:||Ctrl + B / Ctrl + I / Ctrl + U|
|Find / Replace:||Ctrl + F / Ctrl + H|
|Undo / Redo:||Ctrl + Z / Ctrl + Y|
|Format Cells Menu:||Ctrl + 1|
|Select Row / Column:||Shift + Spacebar / Ctrl + Spacebar|
Alternative Fill/Copy formula across range
|F2||Inside Cell (useful when wanting to edit a formula inside a cell)|
|F4||Repeat Previous action (useful when you want to repeat same action such as formatting or deleting etc.over and over)|
F4 (while in a cell)
|Lock cell references* - A1, $A$1, A$1, $A1 (very helpful when dragging formulas across big datasets)|
|F9||Recalculate (useful when working in large spreadsheets, can set to manual calculate and then calculate as necessary)|
*Note: In Excel there are two types of cell references: Relative and Absolute. An absolute range will have a $ character before the column portion of the reference and/or the row portion of the reference. A relative range does not use a $ character and is not fixed in any way. The $ character indicates to Excel that it should not increment the column and/or row reference as you fill a range with a formula or as you copy a formula across a range.
Example of Relative range: A1:A14.
If this was to be dragged to the next column, it would become A2:A15.
If instead it was dragged to the next row, it would become B1:B14
Example of Absolute Range: This is defined by where the $ is located - if in front of the row number, then row will be constant, column will change. If in front of letter, then the column is constant and the row will change.
|$A$1||Both the column and row reference are fixed. Neither will be incremented or changed during a copy or fill operation.|
|$A1||Only the column reference is fixed. It will not change during a fill or copy, but the row will change.|
|A$1||Only the row reference is fixed. It will not change during a fill or copy, but the column will change|