Quick Reference clips for Word, Excel, Outlook and PowerPoint.
Welcome Guest (.|Sign Up)
 

Microsoft Excel 2013 Formulas

Click a link below to get started

(click to go back)

 

Lesson 1: Formulas

 

 

  1. Formulas explained
  2. Formulas - using them
  3. Addition
  4. Addition WARNING
  5. SUM - explained
  6. Addition Subtraction Multiplication Division
  7. Order of operations
  8. Auto sum
  9. Average
  10. Now
  11. Today
  12. Auto name
  13. Function Library
  14. Insert Function box
  15. Insert Function box #2
  16. Copy a formula
  17. Concatenation
  18. Text to columns
  19. Relative cell reference
  20. Absolute cell reference
  21. Evaluate a Formula
  22. Export Excel to a Text File
  23. Goal Seek
  24. Group Outline Structure

 

Lesson 2: Advanced Formulas

 

 

  1. Multiple worksheet formula
  2. Multiple workbook formula
  3. Insert Function box explained
  4. Insert Function box
  5. Average
  6. Minimum
  7. IF formula
  8. AND formula
  9. Tip and Trick
  10. OR Formula
  11. SUMIF Formula
  12. COUNTIF Formula
  13. NOW TODAY Formula
  14. AVERAGEIF
  15. IFERROR
  16. SUMIFS
  17. COUNTIFS
  18. AVERAGEIFS

 

 

Lesson 3: Formulas - Count, Sum and Average

 

 

  1. COUNT - counts cells with numbers
  2. COUNTIF - count the numbers if one condition
  3. COUNTIFS - count the numbers if two conditions
  4. SUM - add numbers
  5. SUMIF - one condition
  6. SUMIFS - two conditions
  7. COUNT - second example
  8. SUM - second example
  9. Sum - find subtotal
  10. COUNTBLANK - count the number of empty cells
  11. COUNTA - count non-empty cells
  12. COUNT - counts cells with numbers
  13. AVERAGE - find the average answer of your data
  14. AVERAGEIF - find answer if one condition
  15. AVERAGEIFS - find the average of two criteria
  16. SUMIF - sum your data using only one criteria
  17. SUMIFS - sum your data using multiple criteria
  18. COUNTIF - count data using once criteria
  19. COUNTIFS - count data using multiple criteria

 

 

Lesson 4: Financial Formulas

 

 

  1. NPV - net present value
  2. IRR - Internal rate of return
  3. FV - future value
  4. Future Value (2nd example)
  5. PV - Present value
  6. DDB - double declining balance
  7. ISPMT - interest paid for an investment
  8. PMT - find pmt of a loan
  9. PMT - find pmt of loan (example 2)
  10. VDB - variable declining balance
  11. NPER - find total number of payments
  12. RATE - find rate of interest
  13. PPMT - find principal of a loan
  14. IPMT - find interest of a loan
  15. Accrued Interest Function
  16. Import txt file into Excel
  17. PMT - find pmt of a loan
  18. PPMT - find principal of a loan
  19. IPMT - find interest of a loan
  20. Balance - find balance of loan
  21. Compound Interest - how to find
  22. Loan Payments - different durations
  23. Investment - find future value
  24. Annuity - present value
  25. Total Paid on Loan

 

 

Lesson 5: Formulas - Logic / Basics /

Understanding Error Messages / Array Formula

 

 

  1. IF formula (one variable must be true)
  2. AND formula (two variables must be true)
  3. OR formula (one of two variables must be true)
  4. Addition formula (add numbers)
  5. Division (divide your numbers)
  6. Multiplication (multiply numbers)
  7. Subtraction
  8. NOW formula (current time on your sheet)
  9. TODAY formula ( current date on your sheet)
  10. # OF DAYS between 2 dates
  11. Keystroke to insert current date
  12. Current date plus ? days
  13. NETWORK days (how many work days)
  14. Minimum - find it
  15. Maximum - find it
  16. Average
  17. Average if
  18. Average if(s)
  19. Error Message - Division
  20. Error Message - #### signs
  21. Error Message - name error message
  22. Error Message - reference message
  23. Error Message - value error
  24. Array Formula

 

 

Lesson 6: Financial Formulas

 

 

  1. NPV - find the net present value
  2. IRR - find internal rate of return
  3. FV - future value
  4. FV - future value - example # 2
  5. Loan Balance owed
  6. Compound Interest
  7. Earning - percent of change
  8. School grades - % of change
  9. Investment
  10. IPMT
  11. Amortization table
  12. NPER
  13. Loan Payments - diff. durations
  14. PMT
  15. PPMT
  16. PV (present value)
  17. PV of annuity
  18. Rate
  19. Total Paid - principal and interest
  20. Total price WITH discount

 

Lesson 7: Formulas - Text

 

 

  1. Join 2 columns - no space
  2. LEFT formula - extract data from the left
  3. RIGHT - formula - extract data from the right
  4. MID - formula - extract data from the middle
  5. LEN - formula
  6. FIND formula - find specific data
  7. SUBSTITUTE
  8. TRIM - remove spaces
  9. Text to columns - last first
  10. Text to columns - first last
  11. Join 2 columns - with a space
  12. Text to columns - / slash
  13. Text to columns - @
  14. LOWER case
  15. UPPER case
  16. PROPER case
  17. EXACT - compare for exact
  18. CLEAN or TRIM
  19. Join 2 columns with a space
  20. Join 2 columns without a space

 

 

Lesson 8: Formulas -

VLookup (Vertical Lookup)

HLookup (Horizontal Lookup) / Reference / Rounding

 

 

  1. Vertical - VLookup - false
  2. Vertical - VLookup - false 2nd example
  3. Vertical - VLookup - false 3rd example
  4. Vertical - VLookup - false 4th example
  5. Vertical - VLookup - true
  6. Horizontal - HLookup - false
  7. Horizontal - HLookup - false 2nd example
  8. Horizontal - HLookup - false 4th example
  9. Horizontal - HLookup - true
  10. MATCH - look up a value; return the answer
  11. INDEX - look up a value; return the answer
  12. LOOKUP - look up a value; return the answer
  13. Rounding
  14. ROUNDUP
  15. ROUNDING problem
  16. ROUNDING - stop rounding
  17. Round - problem #2
  18. ROUND DOWN
  19. Decimal points - add / remove them
  20. Decimal point shows incorrect number