Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...

Microsoft Excel's form controls let you add buttons to your spreadsheet to perform functions. For example, if a spreadsheet invites coworkers to enter sales predictions, they might press a button ...

How to Program a "Save As" Button in Excel VBA. Offices and small businesses all over the world create countless numbers of Excel spreadsheets every day. Many small businesses create the ...

The Excel ISEVEN function aims to return True if the number is even. This tutorial will show you how to use the ISEVEN function in Excel.

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

In part 1 of this series on Excel for search engine marketers, I started off by applauding the tool and pointing out how important it is to our industry.

Microsoft Excel’s Subtotal feature is a great tool, but you can make the results even better by customizing the format.

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.