http://www.amazon.com/dp/B07JYFT23Z
The world of Excel is one that many users utilize but also need guidance on. Therefore, this guide is meant to be utilized by an individual whom will be reviewing via a demonstration format some cool tips that a general user who will be using Excel – can utilize in order to save time. The guide can also be utilized by any individual interested in self-study learning some core and key aspects of Excel.
Viewing worksheet
1. Zoom.
2. Namebox.
3. Ctrl + D.
4. Ctrl +` Accent Key.
5. Freeze Panes.
Shortcut keys
6. Close a Workbook.
7. Open a Workbook.
8. Go to the Data Tab.
9. Go to the View Tab.
10. Go to Insert Tab.
11. Access and Add Borders.
Formatting
12. Format Painter.
13. Clear Formats.
14. Page Borders.
Editing
15. Ctrl + Z (Undo).
16. Esc.
17. Fn + F2 to Edit.
18. Fn + F2 while Typing.
19. One Click to Select All.
20. Enter #’s as Text.
21. Paste Special Values.
22. Quick Fill Handle for Months & Days.
Calculating
23. Status Bar - Average, Count and Sum.
24. AutoSum.
25. Text to Columns.
26. Using Formulas to combine text.
Multiple Worksheets
27. Ctrl + Drag a Worksheet.
28. Rename a Sheet.
29. Edit the Same Cell on Multiple Worksheets.
30. Delete Multiple Worksheets.
The world of Excel is one that many users utilize but also need guidance on. Therefore, this guide is meant to be utilized by an individual whom will be reviewing via a demonstration format some cool tips that a general user who will be using Excel – can utilize in order to save time. The guide can also be utilized by any individual interested in self-study learning some core and key aspects of Excel.
Viewing worksheet
1. Zoom.
2. Namebox.
3. Ctrl + D.
4. Ctrl +` Accent Key.
5. Freeze Panes.
Shortcut keys
6. Close a Workbook.
7. Open a Workbook.
8. Go to the Data Tab.
9. Go to the View Tab.
10. Go to Insert Tab.
11. Access and Add Borders.
Formatting
12. Format Painter.
13. Clear Formats.
14. Page Borders.
Editing
15. Ctrl + Z (Undo).
16. Esc.
17. Fn + F2 to Edit.
18. Fn + F2 while Typing.
19. One Click to Select All.
20. Enter #’s as Text.
21. Paste Special Values.
22. Quick Fill Handle for Months & Days.
Calculating
23. Status Bar - Average, Count and Sum.
24. AutoSum.
25. Text to Columns.
26. Using Formulas to combine text.
Multiple Worksheets
27. Ctrl + Drag a Worksheet.
28. Rename a Sheet.
29. Edit the Same Cell on Multiple Worksheets.
30. Delete Multiple Worksheets.
Comments