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

 


Microsoft Excel 2013 Advanced Course

Click a link below to get started

(click to go back)

 

 

 

 

Lesson 1: 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 2: 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 3: Formulas - 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

 

Lesson 4: New Features

 

 

  1. Excel - opening screen
  2. Open new blank workbook
  3. Ribbon - explained
  4. Quick access toolbar
  5. Protect your workbook
  6. Check for issues
  7. Microsoft - view the Microsoft provided Templates
  8. The "open" menu and its options
  9. Save vs. Save As
  10. Print - how and where and options
  11. Share Export
  12. Account options
  13. Screen shot and clipping
  14. Tables
  15. Sparklines
  16. Pivot Table Slicers
  17. Smart Art

 

 

Lesson 5: Excel 2013 Tips and Tricks Vol. 1

 

 

  1. Copy a formula on a worksheet to multiple columns
  2. Microsoft Excel golden rule - type numbers first a
  3. Navigational arrow - right click the arrows to sho
  4. Alt+= to add
  5. Copy a sheet - use the CTRL key and right drag to
  6. Trim - remove extra spaces from the left side of t
  7. Multiple lines of text in one cell
  8. F11 - to create a chart on the same worksheet
  9. Put chart on same page - ALT+F1 to create chart on
  10. Add data quickly to pre-existing chart
  11. Format painter - to copy formatting from one place
  12. Move a chart
  13. Change default chart type
  14. Quick Access Toolbar - add remove icons
  15. Hide the ribbon
  16. Create a custom list
  17. Make it larger with the wheel
  18. Zoom in
  19. Switch between windows
  20. Use the Watch Window
  21. View side by side
  22. Trace precendent
  23. Now formula
  24. Today formula
  25. Transpose the data

 

Lesson 6: Excel 2013 Tips and Tricks Vol. 2

 

 

  1. Show the formulas - how to show formulas
  2. Months - make months repeat automatically
  3. Days - make the days repeat automatically
  4. Years- make the days repeat automatically
  5. Templates - save massive time
  6. Duplicates - find duplicates on one column
  7. Duplicates - find them (more than 1 column)
  8. Duplicates - sort your duplicates by color
  9. Unique values - find them
  10. Duplicates - find and remove duplicates
  11. UPPER case formula
  12. LOWER case formula
  13. PROPER case formula
  14. Text to columns - separate text into 2 colums
  15. Text to columns (again)
  16. CONCATENATE - join text of 2 columns no space
  17. CONCATENATE join text of 2 columns with a space
  18. CONCATENATE with 3 words
  19. PASTE AS A VALUE - turn formulas into text
  20. DATA FORM - create a form for easy data entry
  21. Drop down list - no more typing!
  22. Find the top 3 figures
  23. Phone number - auto format
  24. ZIP CODE- auto format
  25. Social Sec. #'s - auto format