Impress your coworkers with these nifty tricks.

A check box may be integral to an Excel form, but you should still be able to edit it. However, if you've inherited a form from a co-worker or another source, removing a form field or even moving it ...

I like to think I’m pretty decent with Excel. I know my way around a pivot table, I love automating anything and everything with formulas and conditional formatting, and I am as skilled with a vlookup ...

Whether you want to restrict data inputs, ensure consistency, or avoid errors, data validation in Microsoft Excel is the tool for you. It can also serve as a vital safety net if you plan to share your ...

To check if a value exists in an array, we can loop through its elements. However there is another solution! You can use the INDEX () function, native to Excel and in the case of two-dimensional ...