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.

Excel Tutorial: Mastering MS Excel Tips and Tricks

Check out this great video on data analysis, where you'll discover useful Excel functions and helpful Excel tips.

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.