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

Microsoft Excel 2010 Formulas

 

Click a link below to begin

 

 

 

Lesson 1: Formulas: Basics / Logic/ # of days / %

 

 

  1. Formula - addition
  2. Formula - subtraction
  3. Formula - multiplication
  4. Formula - division
  5. Formula - IF = 1 variable true
  6. Formula - AND (2 variables true)
  7. Formula - OR (1 of 2 variables must be true)
  8. Formula - NOW (date and time)
  9. Formula - TODAY (date)
  10. Formula - # of days between 2 dates
  11. Formula - insert current date
  12. Formula - current date plus # of days
  13. Formula - # of working days
  14. Formula - Percent of change
  15. Formula - Percent = grade change
  16. Formula - percent = total price with discount

 

Lesson 2: Formulas - Count, Sum and Average

 

 

  1. COUNT - counts cells with numbers
  2. COUNTIF - one condition
  3. COUNTIFS - two conditions
  4. SUM - add numbers
  5. SUMIF - one condition
  6. SUMIFS - two condition
  7. COUNT - second example
  8. SUM - second example
  9. SUM - find subtotal
  10. COUNTBLANK - empty cells
  11. COUNTA - NON-EMPTY cells
  12. COUNT - cells with numbers
  13. AVERAGE - find the average
  14. AVERAGEIF - one condition
  15. AVERAGEIFS - two conditions
  16. SUMIF - scenario
  17. SUMIFS - scenario
  18. COUNTIF - scenarios
  19. COUNTIFS - scenario
  20. ISERROR

     

 

Lesson 3: Rounding / Average / Error Messages

 

 

  1. Round - rounding to the nearest dollar amount
  2. Round up - how to round your numbers up
  3. Round - problem
  4. Round - problem #2
  5. Round - down - how to round your numbers down
  6. Round - stop rounding
  7. Average if
  8. Average if(s)
  9. Average if(s) #2
  10. Minimum - find it
  11. Maximum - find it
  12. Error Message - Division
  13. Error Message - #### signs
  14. Error Message - reference message
  15. Error Message - value error
  16. Error Message - name error message
  17. Add / Remove decimal points
  18. Decimal point shows incorrect number
  19. Amortization table the easy way
  20. IFERROR- make your own error message

 

Lesson 4: Formulas - Text

 

 

  1. Join 2 columns - join 2 columns of text with no sp
  2. LEFT formula - separate characters from the left
  3. RIGHT - formula - separate characters from the rig
  4. MID - formula - separate characters from the middl
  5. LEN - formula shows you how many characters are in
  6. FIND
  7. SUBSTITUTE - replace existing text with new text
  8. TRIM - remove empty spaces from before words
  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
  18. CLEAN or TRIM
  19. CONCATENATE with space
  20. CONCATENATE no space

 

 

Lesson 5: Formulas Vlookup / Hlookup / Match / Index

 

 

  1. Vlookup - False
  2. Vlookup - False Example #2
  3. Vlookup - False Example #3
  4. Vlookup - False Example #4
  5. Vlookup - True - Example #1
  6. Hlookup - False
  7. Hlookup - False #2
  8. Hlookup - False #3
  9. Hlookup - True
  10. Data Validation - example 1
  11. Data Validation - remove it
  12. Data Validation - example 2
  13. Data Validation - remove it
  14. Drop down list
  15. Drop down list - remove
  16. Export data to a CSV
  17. Export data to a comma delimited
  18. Import a CSV
  19. Index formula
  20. MATCH formula

 

 

Lesson 6: Formulas - Financial

 

 

  1. PMT - find pmt of a loan
  2. PPMT - find principal of a loan
  3. IPMT - find interest of a loan
  4. Balance - find balance of loan
  5. RATE - find rate of interest
  6. PV - Present value
  7. NPER - total # of payments
  8. Investment - find future value
  9. Annuity - present value
  10. Total Paid on Loan
  11. Loan Amortization Table
  12. Compound Interest
  13. Loan Payments - diff. durations
  14. NPV - net present value
  15. IRR - Internal rate of return
  16. Future value (2nd example)
  17. FV - future value
  18. Percentage - school grades
  19. Price with percentage discount
  20. Earnings difference in percent
  21. Array Formula

 

Lesson 7: Formulas / Advanced Formulas

 

 

  1. Order of operations
  2. Relative cell reference
  3. SUMIF formula
  4. Text to columns
  5. Text to columns 2
  6. TODAY formula
  7. Insert Function box
  8. Function Box insert
  9. Formulas - multiple worksheet
  10. NOW
  11. OR formula
  12. IF formula
  13. Formula - mulitple workbook
  14. COUNTIF Formula
  15. AND formula
  16. NPV
  17. IRR
  18. FV
  19. FV (2nd example)
  20. PV
  21. NPER
  22. RATE
  23. PPMT
  24. Subtotal Formula while filtering
  25. Network Days - how many work days

 

Lesson 8: Formulas Why use them? Function Library Explained

 

 

  1. Formulas - why use them
  2. SUM
  3. Multiplication
  4. DIVISION
  5. AutoSum
  6. Add numbers to find total
  7. Addition
  8. Formula complex
  9. NOW
  10. Function Library
  11. Function Library 2
  12. Formula bar explained
  13. Absolute cell reference
  14. Formulas hide
  15. Unhide formulas
  16. # of work days in month
  17. Subtotal while filtering
  18. DDB
  19. ISPMT
  20. PMT (Payments)
  21. PMT (2nd example)
  22. VDB
  23. Average
  24. Largest number
  25. RIGHT
  26. Alt+=
  27. Separate text into multiple columns
  28. MATCH (with Text using zero)

 

 

Lesson 9: More Financial formulas

 

  1. Calculate monthly payment
  2. Monthly payment
  3. Monthly payment (example)
  4. Amount of interest paid
  5. Double declining balance
  6. Variable declining balance
  7. Net present Value
  8. Internal Rate of Return
  9. Future Value
  10. Future value (2nd example)
  11. Present Value
  12. Balance owed on a loan
  13. NPER - total # of payments
  14. Rate
  15. PPMT
  16. Accrued Interest
  17. IPMT
  18. Concatenate
  19. PMT
  20. PPMT
  21. IPMT
  22. Compound Interest
  23. Loan Payments - diff. durations
  24. Investment
  25. PV of annuity
  26. Total Paid - principal and interest