10 The Basic Formula Of Excel And Its Functions

in #busy8 years ago

my post tonight i just give 5 basic formula in excel for easy for friend to learn step by step first.

  1. Filter
    As the name suggests this filter is useful for filtering data that has been visited by us Categorizing can also group the data as you see fit.
  2. Conditional Formatting
    Conditional Formatting in Excel is to give the color according to what we want based on the value of the cell we choose, conditional formatting used for presenting the data we want.
  3. Format Painter
    Format Painter is the equation of the format and cell or table without mennyalin contents.
  4. Validation of Data in Excel
    Validation of Data in Excel has function intuk enable you to input data, validation of data useful to prevent invalid or unwanted data into cell.apabila wrong you enter data eat you will be warned that your data wrong.
  5. IFS function
    IFS function is to check whether there is one or several conditions that are met, which then produces a value that is true. IFS can also be replaced with some ifs that have been stacked with some conditions.
Sort:  

Congratulations! This post has been upvoted from the communal account, @minnowsupport, by khalid from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, someguy123, neoxian, followbtcnews, and netuoso. The goal is to help Steemit grow by supporting Minnows. Please find us at the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.

If you would like to delegate to the Minnow Support Project you can do so by clicking on the following links: 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP.
Be sure to leave at least 50SP undelegated on your account.