1. Ask the right questions 2. Extract Transform and Load relevant Data 3. Apply appropriate Data Analytics techniques 4. Interpret and share the results with stakeholder
CTRL+NCreates a new, blank file.CTRL+PDisplays the Print dialog box.CTRL+SSaves the active file with its current file name, location, and file format.CTRL+UApplies or removes underlining.CTRL+VInserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.CTRL+WCloses the selected workbook window.CTRL+XCuts the selected cells.CTRL+YRepeats the last command or action, if possible (i.e. if you hit CTRL+Z and want to undo the undo, you can hit CTRL+Y)CTRL+ZUses the Undo command to reverse the last command or to delete the last entry you typed.F2Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.CTRL+Arrow KeyMoves to the edge of the current data region in a worksheet.SHIFT+Arrow KeyExtends the selection of cells by one cell.CTRL+SHIFT+Arrow KeyExtends the selection of cells to the last nonblank cell in the same column or row as the active cell.CTRL+ENDMoves to the last cell on a worksheet, in the lowest used row of the rightmost used column.CTRL+SHIFT+ENDExtends the selection of cells to the last used cell on the worksheet (lower-right corner).ALT+ENTERStarts a new line in the same cell.CTRL+ENTERFills the selected cell range with the current entry.HOMEMoves to the beginning of a row in a worksheet.CTRL+HOMEMoves to the beginning of a worksheet.CTRL+SHIFT+HOMEExtends the selection of cells to the beginning of the worksheet.CTRL+PAGE DOWNMoves to the next sheet in a workbook.CTRL+PAGE UPMoves to the previous sheet in a workbook.SPACEBARIn a dialog box, performs the action for the selected button, or selects or clears a check box.CTRL+SPACEBARSelects an entire column in a worksheet.SHIFT+SPACEBARSelects an entire row in a worksheet.TABMoves one cell to the right in a worksheet.SHIFT+TABMoves to the previous cell in a worksheet or the previous option in a dialog box.ALT + W, then FFreeze PanesCTRL + "-" then hit C or CTRL+SPACE BAR then CTRL + "-"Delete ColumnCTRL + "-" then hit R or Shift+SPACE BAR then CTRL + "-"Delete RowAre you sad?Yes, I am.
