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

Microsoft Excel 2016 Tips and Tricks and Shortcuts

Click a link below to get started

Lesson 1: Excel 2016 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 chart data quickly - use simple copy and paste
  11. Format painter - to copy formatting from one place
  12. Move a chart
  13. Change default chart type
  14. Quick Access Toolbar trick
  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 2016 Tips and Tricks Vol. 2

 

 

  1. Show the formulas
  2. Repeat months
  3. Repeat days
  4. Repeat years
  5. Excel templates by Microsoft
  6. Find duplicates
  7. Find duplicates in multiple columns
  8. Sort duplicates by color
  9. Find unique values
  10. Remove duplicates
  11. Upper case formula
  12. Lower case formula
  13. Proper case formula
  14. Text to columns - put text from one column into tw
  15. Text to columns with a /
  16. Join two columns - concatenate - with no space
  17. Join two columns - concatenate - with space
  18. Join 3 columns - concatenate - and change the orde
  19. Paste as a value
  20. Create a data form
  21. Create a drop down list
  22. Find the top 3
  23. Phone number auto format
  24. Zip code plus 4 auto format
  25. Soc. Security # auto format

(click to go back)