Excel Master Class- Basic to Advance

Excel Master Class- Basic to Advance

1. Interface Overview:

Open excel file from window menu-> More templates

Select any one templets.

Quick Excess toolbar:

Menu bar:

Footer Bar:

Cell, Rows, Column, Name box & formula bar:

2. Workbook & Worksheet:

  1. Workbook is different different excel files
  2. Worksheet is different different excel sheets.

3. Save File:

  1. Save As for first time save- Ctrl + S ,(F12 (shortcut key))
  2. Save for Save file ( Ctrl + S shortcut key)

4. Movement Shortcut Key:

  1. Movement through Mouse
  2. Movement through keyboard
    • Arrows- left, right, up & down
    • Right – Tab key
    • Left – Shift + Tab key
    • Up – Shift + enter key
    • Down – Enter key
    • Sheet movement from left to right — Ctrl + Page down
    • Sheet movement from right to left – Ctrl + Page up
    • Go to one workbook to other workbook – Ctrl+ Tab  or Alt + tab
    • Fast movement ( up side) – Page up
    • Fast movement ( Down side) – Page down

5. Data entry shortcut key:

  1. How to edit data:
    • Double click then edit
    • Click on formula bar then edit
    • Click on F2 key then edit

6. Selection with Shortcut key:

  1. Select all- Ctrl+ A
  2. Single click selection- Ctrl+Shift+A
  3. Single Cell selection- Shift + A

7. Adjustment of Cell, Column & Rows:

  1. Double click on Row or Column.
  2. Manually drag & drop process for Row or column adjustment.
  3. Ctrl+A – > Alt + HOI for only column adjustment
  4. Ctrl+A – > Alt+HOA for only row adjustment

8. Basic Formatting with shortcut key:

  1. Alignment – Center- >Alt+ HAC
  2. Bold-> CTRL+ B
  3. Font- Calibri
  4. Size- 12 for heading
  5. Highlight Cell colour-> ALT+HH
  6. Font colour-> ALT+HFC
  7. Border- all borders->Alt+HBA
  8. All thick border- select area- more border -> ALT+ HBM
  9. Thick outside border-> Alt +HBT
  10. No border -> Alt +HBN
  11. Insert Row->Select row-> Ctrl + +
  12. Insert Column->Select column-> Ctrl + +
  13. Insert cell-> Ctrl+ + -> shift cells right
  1. Delete Row-> Select Row -> Ctrl+ –
  2. Delete Column -> Select Column -> Ctrl+ –
  3. Delete Cell -> Ctrl+ –

9. Advance formating:

  1. Merge & center – Alt + HMC
  2. Merge across with both rows – > Alt + HMA
  3. Unmerge-> Alt + HMU

4. Shrink to fit -> Home-> Alignment settings-> Click shrink to fit.

5. Write text then Alt+enter for next line

10. Clipboard group

  1. Ctrl +C for Copy
  2. Ctrl + V for Paste
  3. Ctrl + X for Cut

How to work Clipboard:

Click clipboard option> select your text > copy > copy > copy Then select your paste area then paste all.

How to work Format painter:

Select area then click format painter option then select your area.

11. Miscellaneous features:

Content delete: Alt + H + E + C
Format delete: Alt + H + E + F
All delete: Alt + H + E + A

Undo: Ctrl + Z
Redo: Ctrl + Y

Leave a Comment