Mastering Practical Computer Skills for Professionals with Google: 45 Tips for Windows, Excel, PowerPoint, Word, and Email Usage for High Performers

Author Masahiro Inoue · Publisher JPub · Published 2020-06-15 · ISBN 9791190665193

Table of Contents

[CHAPTER 1 Windows 10 Basic Settings to Create a Clean Working Environment]
01 Keep your Windows desktop tidy 14
_ Why you should only leave the Recycle Bin on your desktop 14
_ Put everything on your desktop into a folder "for now" 15
02 Quickly open frequently used programs and folders 16
_ Pin programs to the taskbar 16
_ Find programs in the search bar 18
_ Pin programs to 'Quick access' in File Explorer 19
03 Remove unnecessary features for an optimized screen 21
_ Do not display start screen icons 21
_ Delete unnecessary programs 23
_ Delete unnecessary programs that start automatically when you start your computer 24
04 Remove unnecessary notifications for work focus 26
_ Turn off Windows notifications 26
_ Turn off notifications during presentations 27
05 Assign a default program to open files 28
_ Assign a program to open files 28
_ Open a file with a different program just this once 30
06 Increase mouse movement and text input response speed 31
_ Set mouse pointer movement speed 31
_ Set text input response speed 33
07 Always lock your screen when you leave your desk 34
_ Lock computer screen 34
_ Assign screen lock shortcut 35
_ Assign power saving shortcut 36

[CHAPTER 2 Keyboard and Mouse Operation Techniques You Never Knew About]
08 The quick worker's main weapon is the keyboard 40
_ Keep your fingers in the 'home position' on the keyboard 40
_ Quickly move between lines, sentences, and words 41
09 5 techniques to freely control windows 44
_ Switch between open windows: Alt+Tab 44
_ Close unnecessary windows: Ctrl+W 46
_ Minimize all windows: +M 47
_ Maximize/restore the current window: +↑/↓ 48
_ Arrange windows side-by-side: +←/→ 49
10 Increase work efficiency with shortcuts instead of the mouse 50
11 Select multiple folders and files at once 52
_ Select consecutive files or folders: Shift 52
_ Select non-consecutive files or folders: Ctrl 53
_ Select all files or folders and then exclude some: Ctrl 54

[CHAPTER 3 Quickly Search for Information in Edge and Chrome]
12 6 techniques to quickly search for desired information with Google 56
_ AND search 56
_ Exact match search 57
_ NOT search 57
_ OR search 57
_ Wildcard search 57
_ Date range search 58
_ Search for similar images 58
13 Reduce keyword input time with Google search suggestions 60
14 Delete web page visit history to protect privacy and security 62
_ Browse in Edge without saving visit history 62
_ Show guest mode in Chrome 63
_ Manually delete visit history 65
15 Manage web page favorites (bookmarks) 67
_ Add favorites in Edge 67
_ Add favorites in Chrome 70
_ Manage favorites folders in Edge 71
_ Manage favorites folders in Chrome 73
16 Set start page in web browser 75
_ Set previous page as start page 75
_ Change default search engine in Edge 76
_ Change default search engine in Chrome 78
17 Easy Google search features 80
18 Strong password saving and management methods 83
_ Create and save strong passwords in Chrome 83
_ Manage passwords in Edge 86

[CHAPTER 4 Lifetime Techniques You Can Use Right Away]
19 Keep folders simple, find files by searching 90
20 Print only the necessary parts of a web page 95
_ Specify print range 95
_ Print multiple pages on one A4 sheet 98
21 Easily process images and capture screens 101
_ Edit and correct images with photo programs 101
_ Easily capture screens 103

[CHAPTER 5 Creating Persuasive PowerPoint Slides]
22 Slides should convey the core message 106
23 7 principles for creating easy-to-understand slides 109
24 Decorate fonts with size, boldness, and color 113
25 Align neatly and leave ample white space 117
_ Arrange using smart guides 117
_ Align objects 118

[CHAPTER 6 Organizing Excel Data at a Glance]
26 How to format complex data into easy-to-read tables 122
_ Bold important numbers 122
_ Distinguish content by cell color 123
_ Left-align text, right-align numbers 124
_ Set row height and column width 125
27 Data entry methods that are 10 times faster 128
_ Minimum Excel shortcuts to master 128
_ Quickly copy and paste 129
_ Automatically enter sequential data 132
28 You only need to know four Excel functions 134
_ SUM function 134
_ IF function 136
_ COUNTIF function 139
_ SUMIF function 140
29 Process repetitive tasks in batches 142
_ Find and Replace 142
_ Filter and sort data 143
_ Batch delete line breaks within cells 145
_ Batch delete blank cells and blank rows 146
30 How to create the easiest-to-read chart 148
_ Refer to Microsoft Office official chart guide 149
_ Briefly display data characteristics 149

[CHAPTER 7 Efficient Email Usage You Can Apply Right Away]
31 Principles are also needed when writing emails 152
_ Write emails according to your own established principles 152
_ Distinguish recipient groups TO, CC, BCC 154
32 Register frequently used content in your signature 156
33 Categorize bulk emails with flags and process them quickly with shortcuts 158
_ Process emails quickly with shortcuts instead of clicks 158
_ Increase email management efficiency with flags 159
34 Quickly find past emails in Outlook 161
35 Share large files via the cloud 166
36 Appropriately distinguish between meetings and emails 169

[CHAPTER 8 How to Keep Your Computer in Optimal Condition]
37 First, check your computer's current status 172
_ Check operating system version and memory capacity 172
_ Check web browser version 174
_ Check for unnecessary running programs 176
38 Speed up computer operation by cleaning the disk 179
39 Reliably protect data with automatic file recovery and auto-save 181
_ Use automatic recovery function 181
_ Change auto-save interval 184
_ Recover files that have never been saved 185
40 If your computer suddenly slows down, check for Windows updates 186

[CHAPTER 9 5 Ways to Achieve Maximum Efficiency]
41 Handle simple discussions via messenger 188
42 Use video conferencing instead of long-distance travel 190
43 Always share the latest files with Google G Suite 192
44 Thoroughly manage your schedule with Google Calendar 196
45 Handle email tasks with Gmail, utilizing the cloud 198

[APPENDIX Shortcuts for the Efficient Worker]