9 Secret Tips & Tricks in MS Excel?

Go to Insert tab

Alt+N

Bold

Ctrl+B

Center align cell contents

Alt+H, A, then C

Go to Page Layout tab

Alt+P

Go to Data tab

Alt+A

Go to View tab

Alt+W

Open context menu

Shift+F10, or

Context key

Add borders

Alt+H, B

Delete column

Alt+H,D, then C

Go to Formula tab

Alt+M

Hide the selected rows

Ctrl+9

Hide the selected columns

Ctrl+0

 Secret Tips & Tricks in MS Excel?

•  

  1. Time Ctrl+Shift+;
  2. Date Ctrl+;
  3. Select Column Ctrl+Space
  4. Select Rows Shift+Space
  5. Delete Columns Ctrl+0
  6. Underline Row Ctrl+9
  7. Merger Two Column Alt+Enter
  8. Center Text Ctrl+`
  9. Calculate some Columns  First select some columns then press Alt+=

   

   

Bold.....Ctrl+B

Copy.....Ctrl+C

 

1. One Click to Select All 2. Open Excel Files in Bulk 3. Shift Between Different Excel Files 4. Create a New Shortcut Menu 5. Add a Diagonal Line to a Cell 6. Add More Than One New Row or Column 7. Speedily Move and Copy Data in Cells 8. Speedily Delete Blank Cells 9. Vague Search with Wild Card

His body language. his personality. public relation

1. Knowledge in Excel short cut keys 2. Working with Excel. 3. Use Equations, VLookup etc.

Making of Pivot Table and its Filter

MS Office 2007 or Higher 2016, have made it very easy for us to go to the shortcuts.

1) First press Alt Key.

2) Then the continuation keys of the shortcut on the menubar are displayed.

3) We need to just keep along the shortcuts even into the submenus.

4) Practice makes perfcet. As you keep on practicing, based on your usage you will start remebering them.

Thats all. No Tricks - No Memorization!

 

Excel weel user not using the Mouse while doing the excercise

Everything depends on practice

1. Know basic formula for computation. 2. know how to link cell for massive computation 3. knowledge in using filters for coding, classification, category 4.VOOKUP for searching massive files. 5.Hide cell when you dont' want to disclose part of report 6. Unhide when you want to disclose info you hide. 7. Hyperlink when you want to link part of your work without tracing manually 8. Basic Draft, Pie, Chart which is essential in reporting 9. The rest are basic for layout and format