In this lesson, we are explaining some basic formulas in MS Excel.

1. Sum
2. Average
3. Sumif
4. Count
5. Counta
6. Countif
7. Concatenate
8. If
9. Vlookup

Important 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