Basic Formulas in Excel 2010 for Windows

Excel 2010 (Windows)    |    Beginner
  • 12 videos | 51m 3s
  • Earns a Badge
Likes 88 Likes 88
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.

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
    round numbers in Excel 2010
    use replacement formulas in Excel 2010
    convert number types in Excel 2010
    factorize the results of a division in Excel 2010
    use formulas to generate random values in Excel 2010

IN THIS COURSE

  • Playable
    1.  Inserting a formula using the function library in Excel 2010 for Windows
    5m 39s
    Excel 2010'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… FREE ACCESS
  • Playable
    2.  Performing simple calculations in Excel 2010 for Windows
    4m 38s
    The cells in your Excel 2010 worksheet can be thought of as little calculator spaces. You can these individual cells to perform simple and complex calculations. Once you have inserted a calculation, any data updates that… FREE ACCESS
  • Locked
    3.  Using automated formulas in a table in Excel 2010 for Windows
    3m 51s
    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… FREE ACCESS
  • Locked
    4.  Creating automated cumulative totals in Excel 2010 for Windows
    2m 48s
    If you have organized your data entries into chronological order, a cumulative total can very quickly be created. In Excel 2010, you can create the calculation once and then apply it automatically to the rest of your data… FREE ACCESS
  • Locked
    5.  Inserting subtotals in Excel 2010 for Windows
    4m 1s
    When your Excel 2010 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… FREE ACCESS
  • Locked
    6.  Counting cells in a range in Excel 2010 for Windows
    4m 50s
    The COUNTA formula is used in Excel 2010 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… FREE ACCESS
  • Locked
    7.  Ranking a value in Excel 2010 for Windows
    5m 25s
    Excel 2010'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… FREE ACCESS
  • Locked
    8.  Rounding a number in Excel 2010 for Windows
    6m 6s
    In Excel 2010, 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… FREE ACCESS
  • Locked
    9.  Using replacement formulas in Excel 2010 for Windows
    3m 17s
    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 2010's formulas, SUBSTITUTE, TRIM and REPLACE. FREE ACCESS
  • Locked
    10.  Converting number types in Excel 2010 for Windows
    2m 43s
    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 2010, you can quickly convert a number that you have inserted into and out of a… FREE ACCESS
  • Locked
    11.  Factorizing the results of a division in Excel 2010 for Windows
    2m 11s
    If you want to perform a division in Excel 2010, 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… FREE ACCESS
  • Locked
    12.  Generating random values in Excel 2010 for Windows
    5m 33s
    Creating randomized numbers if often very useful if you need a randomly-generated code, are holding a lottery, or are drawing lots. In Excel 2010, there are lots of formulas and calculations that you can use to generate… FREE ACCESS

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 742 Likes 742  
Likes 1346 Likes 1346  
Likes 18 Likes 18