How-To Geek on MSN

How to use the MAP function in Microsoft Excel

Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...
Geeky Gadgets

How to use Excel TREND and FORECAST functions in data analysis

When you dive into Excel, you quickly realize the power it holds for data analysis and prediction. Two of the most potent tools at your disposal are the TREND and FORECAST functions. These functions ...
TechRepublic

How to use the new TEXTSPLIT() function in Microsoft Excel

How to use the new TEXTSPLIT() function in Microsoft Excel Your email has been sent Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a character ...
Geeky Gadgets

How to use Excel FILES a secret, powerful hidden function

The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder. MyOnlineTrainingHub takes you through how to enable ...
TechRepublic

How to use the FILTER() dynamic array function in Excel

How to use the FILTER() dynamic array function in Excel Your email has been sent Filtering is a huge part of many Microsoft Excel sheets, and fortunately, there are ...
Hosted 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 solution. It assigns simple names to complex calculations, making formulas ...