Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

FORECAST.ETS applies an exponential triple smoothing (ETS) algorithm to create forecasts that can include trend and seasonal ...

With the functions I'll discuss here, you can make data cleanup much easier in Excel. They allow you to extract, style, split, and join text to get what you need without wasting hours doing it ...

Although there are many functions in the base package of R, sometimes there may not be a function that does exactly what you want. In this case, R allows users to create their own functions and call ...

Sean Ross is a strategic adviser at 1031x.com, Investopedia contributor, and the founder and manager of Free Lances Ltd. Gordon Scott has been an active investor and technical analyst or 20+ years. He ...

Custom functions enable you to add new functions to Excel by defining those functions in JavaScript as part of an add-in. Users within Excel can access custom functions just as they would any native ...