MS Excel Formula PDF

by

In this digital era MS Excel Formula PDF is a very beneficial resource to augment your skill in MS Excel. Read this full article and get the comprehensive PDF of all the MS Excel formulas in the bottom section below.

MS Excel Formula PDF

MS Excel Formula PDF Free Download

Details of the PDF

PDF Name MS Excel Formula PDF
Size 02 MB
Number of Pages 44
Language English
Credit www.bc.edu
Categories Jobs & Education, Science & Technology

About the PDF

MS Excel is a spreadsheet software program, which is used to organize, analyze, and calculate various data. It makes easier to arrange and calculate an enormous amount of data. It is used for multiple purposes such as preparing budget and balance sheets, filtering and sorting data, analyzing financial data impeccably, and creating various charts and graphs. Billions of people around the world use this software for personal and official purposes.

Basic of MS Excel and formulas

  • Row and columns are the basic units of MS Excel.
  • The intersection of row and column is called a cell.
  • Equals to sign(=) is used to be a formula.
  • Mathematical operators such as plus(+), minus(-), asterisk(), front slash(/), caret symbol(^), open and close parentheses(()), are used for easy calculation.
  • Type of formula: Using constant values: 32+6
    Using reference values: (A3+B2)-D1
    Combination of constant and reference values: A2*3-B4
  • You can also enter the formula by selecting a cell and typing the formula in the formula bar.
  • The cell range is written in ratio format such as in column A the range of rows from 1 to 10 is written as A1:A10
  • Some of the functions are
    SUM: addition of cells
    AVERAGE: average of cells
    MAX: finding maximum values among the cells
    MIN: finding minimum values among the cells
    COUNT: count the number of entries
    AutoSum: A quick sum without typing any function
    DATE: it is used to calculate dates.
    UPPER: change the all text to uppercase
    LOWER: change the all text to lowercase
    PROPER: change text to title case
    CONCATENATE: to combine the text of multiple cells
    IF: to compare the values
    PMT: for calculating the loan payment.
    etc.

Go through this PDF thoroughly to utilize this in your everyday work. We hope that you will find this helpful.

Download MS Excel Formula PDF

MS-Excel-Formula.pdf

×

Please share your feedback with us.

Share

Leave a Comment