Excel isn't hard, just learn the right tricks early enough.

Excel’s data validation feature offers an efficient way to perform a variety of tasks. This collection of techniques demonstrates several handy ways to put data validation to work. From the ebook: ...

Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.