The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms ...

While Excel's charts are excellent tools for displaying complex data in more understandable ways, sometimes, you might want ...

If you've used Excel's Merge And Center tool for a long time (like I had), you could be forgiven for thinking there's no ...