How-To Geek on MSN

How to use the LET function in Microsoft Excel

If you're tired of repeated calculations, hard-to-read formulas, and sluggish Excel worksheets, the LET function is your ...
TechRepublic

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been sent LAMBDA functions are new to Microsoft Excel. With LAMBDA functions, you can turn a ...
Computerworld

How to use Excel formulas and functions

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...
TechRepublic

How to use VBA’s InputBox function to select a range on the fly in Excel

How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way.
JournalofAccountancy

Using Excel’s GROUPBY function as a PivotTable alternative

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...