Excel functions are the building blocks; formulas are how you bring them to life. Here's the breakdown.

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 and alterations.

Because there are hundreds of functions to choose from, Excel groups functions into categories to make it easier to find the right function for a particular calculation.

However, the Filter function can be placed anywhere in the workbook. The function also can be used along with other functions and formulas, which makes it capable of performing some amazing feats. So ...

But on Excel, you’ll see the program will copy and display hidden columns—because even though you can’t see them, they’re still there.