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.

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...

One key area of focus is Excel’s formulas and functions. 25 Must-Know Formulas and Functions highlight crucial functions like VLOOKUP, IF, and INDEX. Understanding and applying these formulas is ...

10 Excel Functions Everyone Should Know They’re easy to learn, and they’ll make you a lot more productive. by Adam Lacey and Deborah Ashby October 8, 2018 , Updated October 10, 2018 ...

Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.

W hile I'll always argue that SUM is my favorite and most-used Excel formula, there are plenty of other powerful functions included in the software. These features go far past using Excel as a ...

At Microsoft's Ignite 2017 conference today, the company announced a range of new features that will be coming to its Excel application, such as JavaScript Custom Functions and more.

Excel data analysis. Beyond basic functions, this bundle shows users how to use Excel’s advanced data analysis capabilities.