MS Excel Tips and Tricks

ChooseCols

To capture the specific columns from data table.

Drop Down and D-Get Function

This is similar to search function, to easily capture the needed information only by entering one data.

If (Countif) Function

Use this to determine the number of unique data points.

MS Excel Tips and Tricks

Control-G

This is a shortcut to fill out the blank cells automatically instead of copy paste function.

Drop Down and D-Get Function

This is similar to search function, to easily capture the needed information only by entering one data.

If (Countif) Function

Use this to determine the number of unique data points.

WRAPROWS TRICK

Check out this great video

Powered by

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept