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

Microsoft Excel 2013 Tips and Tricks and Shortcuts

Click a link below to get started

 

 

(click to go back)

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