# Basic Formulas in Excel 2016 for Windows

Excel 2016 (Windows)    |    Beginner
• 12 videos | 48m 21s
• Includes Assessment
Likes 335
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.

## WHAT YOU WILL LEARN

• 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

## IN THIS COURSE

• Excel 2016's Function Library can help you to locate and insert the formula you need. These formulas are grouped according to category. If you are unable to find the formula you want, you can also launch a search query. Once you have selected the formula you wish to use, Excel 2016 can guide you through the arguments that you need to specify.
• The cells in your Excel 2016 worksheet can be thought of as little calculator spaces. You can use these individual cells to perform simple and complex calculations. Once you have inserted a calculation, any data updates that you make will, by default, be included in any dependent calculations.
• 3.  Using automated formulas in a table in Excel 2016 for Windows
If you are going to be applying your formulas to a large number of data entries in your worksheet, it is important to know how to use the Fill Down function. When a formula is copied and pasted into a new cell in Excel 2016, it will - by default - be automatically adjusted to fit its new location. You can however change the way in which these adjustments are applied.
• 4.  Creating automated cumulative totals in Excel 2016 for Windows
If you have organized your data entries into chronological order, a cumulative total can very quickly be created. In Excel 2016, you can create the calculation once and then apply it automatically to the rest of your data entries, thereby saving yourself a lot of time and effort.
• 5.  Inserting subtotals in Excel 2016 for Windows
When your Excel 2016 data table has become rather long, adding subtotals for individual subgroups within that table can be very useful. You can use these subtotals to perform various different calculations, all of which can be activated and deactivated at the touch of a button.
• 6.  Counting cells in a range in Excel 2016 for Windows
The COUNTA formula is used in Excel 2016 to count up the number of cells that contain values. The COUNTIF formula can be used to perform a count of certain values that meet your conditions. You can even use the SUMPRODUCT and COUNTIF formulas together to perform complex but exceedingly useful calculations.
• 7.  Ranking a value in Excel 2016 for Windows
Excel 2016's RANK function is extremely useful if you want to find out where a particular value places in a list of data entries. You can also visualize the smallest and largest values in a list by using the SMALL and LARGE formulas.
• 8.  Rounding a number in Excel 2016 for Windows
In Excel 2016, there are many different formulas that you can use to round up or down your data values. Which one you choose will depend on how you want to perform the calculation. You can, for example, round a value up to the nearest multiple, round it down to the nearest fraction, and even truncate a value.
• 9.  Using replacement formulas in Excel 2016 for Windows
If you have inserted text data into your spreadsheet and you need to make some changes, you may find that you can perform these modifications with the help of some Excel 2016's formulas, SUBSTITUTE, TRIM and REPLACE.
• 10.  Converting number types in Excel 2016 for Windows
We generally use a base-10 number system in everyday life. You will occasionally find it useful to work in binary and hexadecimal. In Excel 2016, you can quickly convert a number that you have inserted into and out of a variety of different number formats, including binary, decimal and hexadecimal.
• 11.  Factorizing the results of a division in Excel 2016 for Windows
If you want to perform a division in Excel 2016, and you want to obtain a whole number answer, you are going to need to use the QUOTIENT formula. You can also visualize the remainder of the equation by using the MOD formula.
• 12.  Creating random values in Excel 2016 for Windows
Creating randomized numbers if often very useful if you need a randomly-generated code, are holding a lottery, or are drawing lots. In Excel 2016, there are lots of formulas and calculations that you can use to generate your random numbers.

## EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

Likes 50

Likes 502
Likes 28
Likes 29