Microsoft Excel 2016 Tips and Tricks and Shortcuts

Click a link below to get started

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

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