IMCOS function returns the cosine of a complex number. Learn how to use the IMCOS function in Microsoft Excel the right way.

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred ...

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

This is the fifth list of shortcuts to use in Excel that deal with data, functions and the formula bar. I have highlighted for you some that I find very ...

A volatile function is a function that recalculates every time a change is made to an Excel worksheet, or whenever an existing workbook is reopened. Going one step further, when a volatile function is ...

Isolating values in an Excel 2007/2010 worksheet or workbook is common in both error-checking and data analysis tasks. While appropriate even for a small worksheet, the functions that isolate a ...

The TREND function analyzes past data and observes a series' past performance. On the other hand, the FORECAST function predicts a series' future performance. However, both use similar algorithms, ...

The Image Function tool will let users resize cells, sort, and filter, and work with images within an Excel table. According to a blog post by Microsoft, Formula Suggestions, and Formula by Example ...

At the Build 2018 developer conference that's taking place these days in Seattle, USA, Microsoft announced support for custom JavaScript functions in Excel.

Discover how Excel's LAMBDA function transforms complex formulas into reusable tools, saving time and enhancing collaboration.