Productivity & Collaboration Tools     Microsoft Office 2016     Excel 2016     Microsoft Office 2016: Intermediate Excel

---

The power of Excel 2016 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers.

---

---

Objectives
Excel 2016: Basic Formulas Inserting a formula using the function library Performing simple calculations Using automated formulas in a table Creating automated cumulative totals Inserting subtotals Counting cells in a range Ranking a value Rounding a number Using replacement formulas Converting number types Factorizing the results of a division Creating random values