MS Excel for Beginners
Date Functions & Nested AND,IF,OR Functions
MS Excel for Beginners
0% Completed
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
