MS Excel for Beginners

Intro to MS Excel

MS Excel is a spreadsheet program that is developed by Microsoft Office. It is used for data entry and storage, performing calculations, data analysis and accounting. Excel shortcuts Close the current work book – Ctrl + W Create the new work book – Ctrl + N Save the work book – Ctrl + S Open the existing workbook - Ctrl + O Create the new sheet in same excel - Shift +F11 Move to the end of the page - Ctrl + Page Down Move to the beginning of the page – Ctrl + Page Up Edit a cell – F2 Move the next cell – Tab Move the previous cell – Shift + Tab Insert current date – Ctrl + ; Insert current time – Ctrl + : Print the sheet – Ctrl+ P Select the entire row – Shift + Space Select the entire column – Ctrl + Space Hide the selected row – Ctrl + 9 Unhide the selected row – Shift + Ctrl + 9 Hide the selected column – Ctrl + 0 Unhide the selected row – Shift + Ctrl + 0