Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

When a VBA solution falls short of your needs, there's probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work.