The attached document allows you to learn how to use the date, nest AND, IF, and OR functions in Excel.
Exercise Files
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
0/2