1. Basic mathematics formulas and functions We’re going to group these formulas together since they are very simple and have similar syntax. All formulas in Excel start with the equal sign ...

This formula pulls all rows where the value in column A is ... Get ready to change how you work These overlooked Excel ...

Excel's logical functions test whether a statement or data ... When creating logical arguments, all text needs to go inside ...

Master Excel's IF, AND, and OR functions to automate decisions, reduce errors, and simplify workflows. Learn practical tips ...

The first function anyone should know tells Excel to carry out basic arithmetic. Let’s say you wanted the numbers in cell A2 and cell B2 to be added together in cell C2. All you’d do is enter ...

Excel groups functions into 12 categories ... There is an additional category for user-defined functions installed with add-ins. Functions in all categories share a common set of data types ...

The SUMIF function in Excel is used to add all the cell values and return the results on the basis of one criterion. On the other hand, the SUMIFS formula enables you to sum up all cell values on ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work. Image: PixieMe ...

You might receive data with names all in the same cell. To parse them into autonomous entities using functions requires complex expressions — until now. Fortunately, Excel now offers easy-to-use ...

Fortunately, the time devoted to figuring all of that out can be cut dramatically with one of the most popular and useful functions in Excel, the IF function. Once you master the IF function, you will ...