SOME COMPUTER BASE PRODUCTIVITY TIPS FOR YOU
Computer Optimization & Productivity Tips
1. Speed Up Your Computer
Step 1: Click on Windows Start → Settings → Apps → Turn off all unnecessary apps (especially Windows Security if not needed)
Step 2: Press Windows + R, type sysdm.cpl
and press Enter
Step 3: Go to the "Advanced" tab → Performance "Settings"
Step 4: Select "Adjust for best performance"
Step 5: Press Windows + R, type msconfig
and press Enter
Step 6: Go to the "Boot" tab → "Advanced options"
Step 7: Check "Number of processors" and select the highest number available
Step 8: Click OK and restart your computer
2. Extract Text from Images
Prerequisite: Install Microsoft PowerToys (free from Microsoft Store)
Step 1: Open the image containing text
Step 2: Press Windows + Shift + T to activate Text Extractor
Step 3: Select the area containing text
Step 4: The text will be copied to clipboard automatically
Step 5: Paste (Ctrl + V) into Microsoft Word
3. Remove Spaces Between Words in Word
Step 1: Select the text where you want to remove spaces
Step 2: Press Ctrl + H to open Find and Replace
Step 3: In "Find what:" type ^w
(this represents any whitespace)
Step 4: In "Replace with:" leave it empty (or type a single space if you want single spaces)
Step 5: Click "Replace All"
4. Separate Data in Excel Cells
Example: When name, address, and contact number are in one cell
Step 1: In a new cell, type: =TEXTSPLIT(
Step 2: Click on the cell containing the combined data
Step 3: Type comma separator: , ","
Step 4: Close the bracket: )
and press Enter
Result: The data will split into separate columns at each comma
5. Excel Data Sorting Shortcuts
Ascending Order:
Select a cell in the column you want to sort → Press Alt + A + S + A
Descending Order:
Select a cell in the column you want to sort → Press Alt + A + S + D