Excel Useful tips
35 Excel Tips That Could Save You from Working All Night
1. Split windows and freeze panes
2. Hide and Unhide command
3. Moving around a spreadsheet with Ctrl, Shift, and Arrow keys
4. Name cells/ranges
5. Sort command
6. Toggling among relational and absolute references
7. Fill down and fill right commands
8. IF function
9. AND and OR functions
10. SUM and SUMIF functions
11. Subtotals and Totals
12. SUMPRODUCT function
13. NPV function
14. COUNT functions
15. ROUND, ROUNDUP and ROUNDDOWN functions
16. VLOOKUP and HLOOKUP functions
17. Insert Function command
18. Paste Special command
19. Auditing features
20. Goal Seek add-in
21. Solver add-in
22. Data tables
23. Scenarios add-in
24. Pivot Tables
25. Protecting cells and worksheets
26. Editing multiple worksheets simultaneously
27. Conditional formatting
28. Autofilter command
29. Customize tool bars
30. Changing default workbook
31. Group and Ungroup your spreadsheet
32. Switch off the Microsoft Actors
33. Clean up text
34. Keyboard shortcuts
