Showing posts with label Learning. Show all posts
Showing posts with label Learning. Show all posts

Thursday, January 31, 2019

Word 30 Tips in 30 Minutes Instructor Guide

http://www.amazon.com/dp/B07N62P3KH

The world of Word 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 Word – 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 Word.

Viewing document
1. Zoom.
2. Alt + Tab keys.
3. Go to Start of a Document.
4. Go to End of a Document.
5. Ruler Tab Markings and Justification.
Shortcut keys
6. Start a New Document.
7. Close a Document.
8. Open a Document.
9. Insert an Endnote.
10. Access and Add Borders.
Formatting
11. Insert Equation.
12. Remove Page Border.
13. Page Colors.
14. Text Headings.
15. Switch Show/Hide Formatting Items.
Editing
16. Ctrl + Z (Undo).
17. Select All.
18. Find and Replace.
19. Horizontal Line.
20. Font Kerning.
Calculating
21. Table Formula.
22. Add Calculator to Toolbar.
23. Tables to Graphs.
24. Change Formula.
25. Select Paragraph.
Document Utilization
26. Outline View.
27. Navigation Pane.
28. Change Default Font.
29. Change Line Spacing.
30. Move Rows of Text in Table.

Excel 30 Tips in 30 Minutes Instructor Guide

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.

Tuesday, January 22, 2019

MS-DOS – 30 Tips in 30 Minutes Instructor Guide

http://www.amazon.com/dp/B07MXRMQT9

The following instructor guide is meant for one to review pertinent tips and tricks in regard to MS-DOS (Microsoft Disk Operating System). MS-DOS famously became the foundation of the personal computer revolution. It has stood the test of time and still holds value as the backbone of the personal computers operating system. 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 MS-DOS – 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 MS-DOS. 
Core tips reviewed are:

Basic Fundamentals
1.Ver
2.Ver > ver.txt
3.Dir
4.Dir /w /p
5.Type ver.txt
6.* Wildcard symbol
7.Cls
8.Dir |Find "ver"
9.Print
10.Help | more
Core Commands
11./? Switch
12.Dir /s /b > files.txt
13.Notepad files.txt
14.Dir *ver*. * /s
15.CD..
16.Tree /a > tree.txt
17.Dir /o:-n
18.Fn – F7
Networking Commands
19.Ipconfig /all | more
20.Start
21.Ping
22.Systeminfo | more
23.Driverquery | more
24.Netstat
25.Net accounts
Directory Commands
26. Dir /a:d
27. Dir | find /v
28. Dir /s /q /a:sh /p
29. Dir /s *.txt;*.xls
30. Dir /o:d /t:w /a:-d