Microsoft Excel

Short cut for Deleting Column

• CTRL 9

• CTRL H D C

• ALT 0

• CTRL -

Short cut key for Filter

• Shift + Alt + F

• Ctrl + Shift + F

• Ctrl + Shift + L

• Alt + Ctrl + L

Shortcut key for highlight rows

• Alt + Shift + <>

• Ctrl + Shift + <>

• Ctrl + Shift + ^

• Alt + Ctrl + ^

Quickest way to hide row

• Alt + Shift + 9

• Shift + Ctrl + 0

• Alt + Ctrl + 9

• Ctrl + 9

Shortcut key for creating Table

• Ctrl T

• Alt T

• Shift T

• Maar - T

The most popular tool in Excel for performing more advanced lookups. A lookups based on multiple criteria

• vlookups

• index match

• index finger

• xlookups

An Excel function to get data from a table organized vertically.

• vlookups

• index match

• index finger

• xlookups

One of the excel functions to join two or more text strings into one string.

• Merge

• Concatenate

• Paste

• Vlookups

To separate the contents of one Excel cell into separate columns.

• Concatenate

• Separate

• Consolidate data

• Text to Columns

A powerful feature in excel that calculates, summarizes,, analyze data and lets you see comparisons, patterns, and trends in your data.

• Visual Basic

• Pivot Table

• Consolidate Data

• Index Match