Using Basic Formulas in Excel 2019 for Windows

Put formulas to work with Excel 2019 for Windows. In this 12-video course learners will observe how to work with formulas including built-in formulas such as SUM and COUNT. You will begin by discovering how to insert a formula by using the function library and then perform simple calculations within an individual cell. Explore how to use automated formulas in a table; create automated cumulative tools; and insert subtotals. Following on from this you will learn how to count cells in a range by using different formulas and then rank values which is extremely useful if you want to find out where a particular value places on a list of data entries. The course also explores how to examine rounding a number to round up or down your data values; use replacement formulas when you need to make changes; convert number types and factorize the results of a division. Conclude the course by observing how to create random values. In order to practice what you have learned you will find the Word document named Excel 2019 for Windows: Using Basic Formulas Exercise as well as the associated materials in the Resources section.