Computer Fundamentals The Ultimate Cheat Sheet

 

Introduction

In today's digital world, knowing your way around a computer is not just a skill — it is a competitive advantage. Whether you type 10 words per minute or consider yourself a power user, there are layers of computer knowledge that most people never discover. This guide fixes that.

From keyboard shortcuts that cut your workday in half, to understanding what RAM actually does, to knowing why your Wi-Fi sometimes drops — this comprehensive cheat sheet covers everything that actually matters in real daily computing.

Bookmark this page, print it out, or share it with a friend. Every section is written in plain English with real-world examples so you can apply it immediately.


💡

Pro Tip: Studies show that learning keyboard shortcuts alone saves an average office worker 8 full days of work per year. That's time you could spend on literally anything else.

 

⌨️  Essential Keyboard Shortcuts

Using a mouse for everything is like driving with the handbrake on. Keyboard shortcuts are one of the fastest, easiest ways to boost your computer speed — no extra software needed. Here is every shortcut you genuinely need, organised by category.

 


General System Shortcuts — The Absolute Essentials

These work in almost every application on Windows, macOS, and even most Linux distributions. Learn these first.

 

Shortcut / Key

What It Does

Ctrl + C

Copy the selected text, file, or object

Ctrl + V

Paste whatever is in your clipboard

Ctrl + X

Cut (copy + delete the original)

Ctrl + Z

Undo the last action — your safety net

Ctrl + Y

Redo — reverse an undo

Ctrl + A

Select All — highlights everything in the current window

Ctrl + S

Save the current file (do this constantly!)

Ctrl + P

Print — opens the print dialog

Ctrl + F

Find — search for any word on the page or in a document

Ctrl + N

New file or new window

Ctrl + W

Close current tab or window

Ctrl + T

Open a new browser tab

Ctrl + Shift + T

Reopen the last closed browser tab (lifesaver!)

Alt + Tab

Switch between open applications

Alt + F4

Close the active window or application

Win + D

Show or hide the Desktop instantly

Win + L

Lock your screen (important for office security)

Win + E

Open File Explorer

Win + I

Open Windows Settings

Win + PrtScn

Take a screenshot and save it automatically to Pictures

Win + Shift + S

Open Snip & Sketch for a custom screenshot

Ctrl + Shift + Esc

Open Task Manager directly — no right-click needed

Win + R

Open the Run dialog (type commands directly)

Win + V

Open Clipboard History — see everything you have copied

 

💡

Real-Life Tip: Win + V (Clipboard History) is one of Windows' most underused features. It stores your last 25 copied items. Enable it once in Settings > System > Clipboard, and you will wonder how you lived without it.

 

Browser Shortcuts — For Chrome, Edge, Firefox & Safari

You spend a huge portion of your computing life in a browser. These shortcuts work across all major browsers.

 

Shortcut / Key

What It Does

Ctrl + L

Jump to the address bar (then type and press Enter to navigate)

Ctrl + Tab

Switch to the next tab on the right

Ctrl + Shift + Tab

Switch to the previous tab on the left

Ctrl + 1 to 9

Jump directly to tab number 1 through 9

Ctrl + D

Bookmark the current page

Ctrl + Shift + B

Show or hide the bookmarks bar

Ctrl + H

Open Browsing History

Ctrl + J

Open Downloads page

Ctrl + Shift + Delete

Open Clear Browsing Data / Cache settings

F5 or Ctrl + R

Refresh the page

Ctrl + Shift + R

Hard refresh — ignores cached data (fixes broken pages)

Ctrl + + / Ctrl + -

Zoom in or out on the page

Ctrl + 0

Reset zoom to 100%

Ctrl + U

View Page Source (see the raw HTML code)

F12

Open Developer Tools — inspect elements, debug, check network

Ctrl + Shift + N

Open a new Incognito / Private window

Space / Shift + Space

Scroll down / Scroll up one screen at a time

 

Function Keys — The Row Most People Ignore

The F1–F12 row at the top of your keyboard has dedicated purposes. Here is what each one actually does in real-world use.

 

Shortcut / Key

What It Does

F1

Open Help menu for any active application

F2

Rename a selected file or folder in Windows Explorer

F3

Open the Search bar in Windows Explorer or many apps

F4

Opens the address bar in File Explorer; used with Alt (Alt+F4) to close windows

F5

Refresh / Reload the current window, browser tab, or document view

F6

Move cursor to the browser address bar (same as Ctrl+L in most browsers)

F7

Run Spelling & Grammar check in Microsoft Word / Outlook

F8

Access Windows Safe Mode at startup (hold during boot)

F9

Refresh fields in Word; Calculate worksheets in Excel

F10

Activate the menu bar in most Windows applications

F11

Toggle Fullscreen mode in browsers and many applications

F12

Save As in Microsoft Office apps; Open Developer Tools in browsers

Fn + F1-F12

On laptops: switches between function key and media key (volume, brightness) actions

 

Microsoft Word Power Shortcuts

If you write documents regularly, these shortcuts eliminate most of the time you spend hunting through menus.

 

Shortcut / Key

What It Does

Ctrl + B

Bold the selected text

Ctrl + I

Italicize the selected text

Ctrl + U

Underline the selected text

Ctrl + E

Centre-align the selected paragraph

Ctrl + L / R / J

Left / Right / Justify alignment

Ctrl + 1 / 2 / 5

Set line spacing to Single / Double / 1.5

Ctrl + [ or ]

Decrease or increase font size by 1 point

Ctrl + Shift + > or <

Increase or decrease font size in larger jumps

Ctrl + K

Insert a hyperlink

Ctrl + Alt + 1/2/3

Apply Heading 1, Heading 2, or Heading 3 style

Ctrl + Home / End

Jump to the very beginning or end of the document

Ctrl + G

Go To — jump to a specific page number

Shift + F3

Toggle text between UPPERCASE, lowercase, and Title Case

Ctrl + Shift + C / V

Copy formatting / Paste formatting (Format Painter shortcut)

Ctrl + Enter

Insert a Page Break

Alt + Shift + D

Insert today's date as a field

 

Microsoft Excel Pro Shortcuts

Excel is where many people lose the most time to manual actions. These shortcuts are the difference between a beginner and a power user.

 

Shortcut / Key

What It Does

Ctrl + ;

Insert today's date in the selected cell

Ctrl + Shift + :

Insert the current time in the selected cell

Ctrl + Shift + L

Toggle AutoFilter on/off for the selected table range

Ctrl + T

Convert selected range into a formatted Table

Ctrl + Shift + $

Apply Currency number format

Ctrl + Shift + %

Apply Percentage format

Ctrl + Shift + #

Apply Date format

Ctrl + Arrow Key

Jump to the last non-empty cell in a row or column

Ctrl + Shift + Arrow

Select from current cell to the last non-empty cell

Ctrl + Shift + +

Insert a new row or column

Ctrl + -

Delete selected row or column

Alt + =

AutoSum — instantly SUM the cells above

Ctrl + `

Toggle showing formulas vs. their calculated values

F4 (inside formula)

Toggle between relative/absolute cell references ($A$1, A$1, etc.)

Ctrl + D

Fill Down — copy the top cell's value/formula into selected cells below

Ctrl + 1

Open Format Cells dialog (the most important formatting window)

Ctrl + Scroll Wheel

Zoom in or out of the spreadsheet view

Ctrl + Page Up/Down

Switch between worksheet tabs

Alt + H + O + I

AutoFit column width — fits content perfectly

 

💡

Real-Life Excel Tip: Alt + = (AutoSum) is the single most time-saving Excel shortcut. Select any cell below a column of numbers and hit Alt + = — it writes the SUM formula for you instantly.

 

macOS Equivalent Shortcuts

Mac users: most Windows Ctrl commands use the Command (Cmd) key instead. Here are the key differences.

 

Action

Windows

macOS

Copy

Ctrl + C

Cmd + C

Paste

Ctrl + V

Cmd + V

Undo

Ctrl + Z

Cmd + Z

Select All

Ctrl + A

Cmd + A

Save

Ctrl + S

Cmd + S

Find

Ctrl + F

Cmd + F

Switch Apps

Alt + Tab

Cmd + Tab

Screenshot

Win + PrtScn

Cmd + Shift + 3 (full), Cmd + Shift + 4 (crop)

Force Quit

Ctrl + Shift + Esc

Cmd + Option + Esc

Lock Screen

Win + L

Cmd + Ctrl + Q

New Incognito Tab

Ctrl + Shift + N

Cmd + Shift + N

Close Tab

Ctrl + W

Cmd + W

 



🌐  Computer Networking — Explained Simply

Every time you send a message, stream a video, or visit a website, a network is doing the work behind the scenes. Understanding networks helps you troubleshoot problems, make smarter tech decisions, and feel less helpless when your internet cuts out.

 


Types of Networks — From Your Pocket to the Planet

 

Acronym

Full Name

Real-World Meaning

PAN

Personal Area Network

Connects devices within ~10 metres — Bluetooth earbuds, smartwatch, phone hotspot. Your personal tech bubble.

LAN

Local Area Network

Connects devices in one building — home Wi-Fi, office network. Fast, private, controlled by you or your IT team.

MAN

Metropolitan Area Network

Covers a city or campus — university networks, city-wide Wi-Fi. Managed by ISPs or local governments.

WAN

Wide Area Network

Spans countries or the entire globe — the Internet itself is the world's largest WAN.

VPN

Virtual Private Network

Creates an encrypted private tunnel over a public network. Used for remote work security and privacy.

SAN

Storage Area Network

Dedicated high-speed network just for storage devices — used in data centres and enterprises.

WLAN

Wireless LAN

A LAN that runs over Wi-Fi rather than cables — what most home and office networks are today.

VLAN

Virtual LAN

Divides one physical network into multiple logical networks — used in offices to separate guest Wi-Fi from company data.

 

Wi-Fi Standards — What Those Letters Actually Mean

Every router box says something like 'Wi-Fi 6' or '802.11ax'. Here is what those mean in terms of real-world speed and range.

 

Standard

Common Name

Max Speed

Status

802.11b

Wi-Fi 1 (1999)

11 Mbps

Old, basically unused

802.11g

Wi-Fi 3 (2003)

54 Mbps

Old home routers

802.11n

Wi-Fi 4 (2009)

600 Mbps

Many older devices still use this

802.11ac

Wi-Fi 5 (2013)

3.5 Gbps

Still widely used today

802.11ax

Wi-Fi 6 (2019)

9.6 Gbps

Current standard, handles many devices better

802.11be

Wi-Fi 7 (2024)

46 Gbps

Newest — in premium routers and devices

 

💡

Real-Life Tip: If your home has 10+ devices (phones, laptops, smart TVs, tablets), upgrade to a Wi-Fi 6 router. It handles multiple simultaneous connections far more efficiently — you will notice fewer dropouts during video calls.

 

Key Networking Terms — Plain English Definitions

 

Shortcut / Key

What It Does

IP Address

Your device's unique address on a network. Like a home address for data packets. Example: 192.168.1.1

Router

The device that directs traffic between your home network and the internet. Your gateway to the web.

Modem

Converts your ISP's signal (cable/fibre/DSL) into data your router can use. Often combined with routers.

DNS

Domain Name System — translates website names (google.com) into IP addresses your computer understands.

DHCP

Automatically assigns IP addresses to devices on a network so you do not have to do it manually.

Gateway

The node (usually your router) that connects your local network to the wider internet.

MAC Address

A permanent unique ID burned into every network adapter. Used to identify specific devices on a network.

Firewall

A security system that monitors and filters incoming/outgoing network traffic based on security rules.

Bandwidth

The maximum amount of data that can be transferred per second — your internet pipe's size.

Latency / Ping

The delay (in milliseconds) before data starts travelling. Low ping = fast response. Critical for gaming and video calls.

Packet

A small chunk of data sent across a network. All internet communication is broken into packets.

Protocol

A set of rules for communication. Examples: HTTP (web), FTP (file transfer), SMTP (email), HTTPS (secure web).

Subnet Mask

Defines which part of an IP address identifies the network vs. the individual device.

NAT

Network Address Translation — lets multiple devices share one public IP address (how home networks work).

Port

A numbered channel for network communication. Web traffic uses port 80 (HTTP) or 443 (HTTPS).

 

Troubleshooting Your Internet — Step by Step

Before calling your ISP, run through this checklist. 90% of internet problems can be fixed in under 5 minutes.

 

        Step 1: Check if it is just one device or all devices. If only one device, the problem is local to that device.

        Step 2: Restart your router. Unplug it from power, wait 30 seconds, plug it back in. Wait 2 minutes for it to reconnect.

        Step 3: Check cables. A loose ethernet cable is a surprisingly common cause of 'my internet is broken'.

        Step 4: Open Command Prompt and type: ping 8.8.8.8 and press Enter. If you get replies, your connection is working. If not, the problem is between your device and the internet.

        Step 5: Type ipconfig /release then ipconfig /renew in Command Prompt to refresh your IP address.

        Step 6: Change your DNS to Google's (8.8.8.8) or Cloudflare's (1.1.1.1) — this often fixes slow browsing that is not a speed issue.

        Step 7: Check your ISP's status page or Twitter/X account. Widespread outages are common.

 

Speed Test Tip: Use fast.com (Netflix's server) or speedtest.net to test your real download and upload speed. If you're getting less than 50% of your plan's advertised speed, call your ISP.

 



💾  Memory & Storage — Sizes, Types & What They Mean

People confuse RAM with storage constantly, and hardware manufacturers have not made it easier by using similar-sounding terms. This section clears everything up — from bits and bytes all the way to petabytes.

 


The Units of Digital Data — From Bit to Yottabyte

 

Size

Equals

Real-World Equivalent

1 Bit (b)

Smallest unit

A single 0 or 1. All digital data is made of bits.

8 Bits

= 1 Byte (B)

Enough to store one text character (letter, number, symbol).

1,024 Bytes

= 1 Kilobyte (KB)

A short text email or a very small file.

1,024 KB

= 1 Megabyte (MB)

A typical MP3 song (3-5 MB), or a standard web image.

1,024 MB

= 1 Gigabyte (GB)

A full HD movie (~4 GB), or ~200 MP3 songs.

1,024 GB

= 1 Terabyte (TB)

Most laptop hard drives today. Holds ~250,000 photos.

1,024 TB

= 1 Petabyte (PB)

Used by large data centres. All Google processes ~100 PB/day.

1,024 PB

= 1 Exabyte (EB)

The total amount of data humans created before 2003.

1,024 EB

= 1 Zettabyte (ZB)

Global internet traffic in 2022 exceeded 4.7 ZB per year.

1,024 ZB

= 1 Yottabyte (YB)

No single storage device of this size exists yet.

 

💡

Key distinction: ISPs and manufacturers use MB/s (megabytes per second) for storage and Mbps (megabits per second) for internet speed. 100 Mbps internet = 12.5 MB/s actual download speed. Divide Mbps by 8 to get real MB/s.

 

RAM vs. Storage — The Most Misunderstood Difference

This confusion leads people to buy the wrong upgrades and misunderstand why their computer is slow. Here is the clearest possible explanation.

 

 

RAM

Storage

What it is

RAM (Random Access Memory)

Storage (HDD / SSD)

Purpose

Holds data the CPU is actively using right now

Holds ALL your data permanently — files, OS, apps

Speed

Extremely fast (nanoseconds)

Fast (SSD) to slow (HDD) — measured in milliseconds

Volatility

Temporary — data is LOST when power is cut

Permanent — data survives shutdowns and reboots

Typical sizes

8 GB, 16 GB, 32 GB, 64 GB

256 GB, 512 GB, 1 TB, 2 TB, 4 TB

Analogy

Your work desk — only what you are actively using fits here

Your filing cabinet — everything you own is stored here

What happens when full

Computer slows down dramatically, starts using Virtual Memory (swap)

Cannot save new files, system may become unstable

Upgrade impact

More RAM = can run more apps simultaneously without slowing

More storage = can keep more files; SSD upgrade makes entire system faster

 

💡

Upgrade Priority: If your PC feels slow overall — upgrade to an SSD. If your PC is slow when you have many apps open — add more RAM. These are different problems with different solutions.

 

Types of Storage — HDD vs SSD vs NVMe

 

Type

Full Name

Speed Range

Best For

HDD

Hard Disk Drive

80–160 MB/s

Cheap per GB, slow, mechanical, fragile, loud

SATA SSD

Solid State Drive

500–550 MB/s

3-4x faster than HDD, no moving parts, very reliable

NVMe SSD

PCIe NVMe Drive

3,000–7,000 MB/s

10-15x faster than SATA SSD. Best for gaming, video editing

eMMC

Embedded MultiMedia Controller

150–400 MB/s

Soldered storage in budget laptops and tablets — not upgradeable

USB Flash Drive

Portable USB Storage

20–400 MB/s

Portable data transfer. Speed varies massively by quality

MicroSD Card

Removable Flash Card

10–280 MB/s

Used in phones, cameras, drones. Class 10 minimum for video

 

Understanding CPU Cache Memory

Cache is a type of memory you rarely hear about but constantly benefit from. It sits directly on the CPU chip and stores the most frequently used data for instant access.

 

Level

Typical Size

What It Does

L1 Cache

4–64 KB per core

Fastest possible — ~1 nanosecond access. Stores instructions currently executing.

L2 Cache

256 KB – 2 MB per core

Slightly slower than L1. Stores data likely to be needed next.

L3 Cache

4 MB – 96 MB shared

Shared between all CPU cores. Acts as a buffer before going to RAM.

RAM

8 GB – 128 GB

10-50x slower than cache but holds everything the running programs need.

Virtual Memory

Set by OS, uses storage

Emergency overflow when RAM is full. Extremely slow — avoid reaching this.

 

Cloud Storage — Your Data Without a Physical Device

Cloud storage keeps your files on servers accessible over the internet. Here is how the major services compare.

 

Service

Free Storage

Best For

 

Google Drive

15 GB free

Works seamlessly with Google Docs, Sheets, Gmail. Best for collaboration.

 

OneDrive

5 GB free

Built into Windows 11. Integrates with Microsoft Office perfectly.

 

iCloud

5 GB free

Essential for Apple devices. Syncs photos, contacts, app data across iPhone/Mac.

 

Dropbox

2 GB free

Pioneer of cloud sync. Excellent third-party app integrations.

 

Amazon Drive

5 GB free

Unlimited photo storage with Prime. Good for AWS ecosystem users.

 

pCloud

10 GB free

Strong privacy, lifetime plans available. Good for sensitive documents.

 

 



🖥️  Computer Hardware — What's Actually Inside Your Machine

You do not need to be an engineer to understand what hardware does. Knowing the basics helps you make smarter buying decisions, diagnose problems, and have informed conversations with IT staff.

 


Core Components — The Big Six

 

Component

Full Name

What It Does

CPU

Central Processing Unit

The brain of the computer. Executes instructions. Speed measured in GHz (clock speed) and number of cores. Examples: Intel Core i7, AMD Ryzen 9.

GPU

Graphics Processing Unit

Handles visual rendering. Essential for gaming, video editing, 3D design, and now AI/ML workloads. Examples: NVIDIA RTX 4070, AMD RX 7800 XT.

RAM

Random Access Memory

Working memory for active tasks. 16 GB is the minimum for comfortable multitasking in 2025. 32 GB recommended for creators and developers.

Motherboard

Main Circuit Board

Connects all components together. Determines which CPUs and RAM types are compatible. Often overlooked but critical.

PSU

Power Supply Unit

Converts wall outlet AC power to DC power for components. Measured in Watts. Always buy 20% more than your system needs.

Cooling System

CPU Cooler / Case Fans

Prevents thermal throttling. Air cooling is sufficient for most users; liquid cooling for overclockers and high-performance builds.

 

CPU Terms You Need to Know

 

Shortcut / Key

What It Does

Clock Speed (GHz)

How many cycles per second the CPU executes. 3.5 GHz = 3.5 billion cycles/second. More is faster for single tasks.

Cores

Physical processing units within one CPU chip. More cores = better multitasking and parallel tasks (editing + rendering + gaming simultaneously).

Threads

Virtual cores — each physical core usually handles 2 threads (Hyper-Threading / SMT). A 6-core/12-thread CPU runs 12 tasks simultaneously.

TDP (Watts)

Thermal Design Power — how much heat (and power) the CPU generates under full load. Higher TDP = needs better cooling.

Integrated Graphics

GPU built into the CPU — good enough for everyday tasks, video, and light productivity. Cannot handle gaming or 3D rendering.

Cache (L3)

On-chip fast memory. Larger cache means fewer slow RAM lookups. Key for gaming and database workloads.

Boost / Turbo Clock

Maximum speed a single core can temporarily reach under load. Intel calls it Turbo Boost; AMD calls it Boost Clock.

Overclocking

Manually increasing CPU or GPU speed beyond factory settings. Requires unlocked chips (Intel K-series, AMD X/GX) and better cooling.

 

Understanding Resolution & Display

Monitor specs matter enormously for productivity and comfort. Here are the key numbers to understand.

 

Name

Resolution

Refresh Rate

Best For

HD / 720p

1280 × 720

60 Hz typical

Basic quality — acceptable on small screens only

Full HD / 1080p

1920 × 1080

60-240 Hz

Standard for most laptops and budget monitors

2K / 1440p

2560 × 1440

60-240 Hz

Sweet spot for gaming monitors and professional use

4K / UHD

3840 × 2160

60-144 Hz

Excellent for video editing, photo work, large screens

5K / 8K

5120 × 2880+

60 Hz typical

Niche use — high-end Mac displays, professional imaging

Ultrawide

3440 × 1440

60-175 Hz

Productivity power move — replaces dual monitors

 

💡

Refresh Rate Tip: For everyday office work, 60 Hz is fine. For gaming, aim for 144 Hz or higher — the difference in smoothness is immediately visible. If you do both, get a 144 Hz monitor.

 



💻  Operating Systems — Windows, macOS & Linux

The operating system is the software that manages all hardware and lets you run applications. Understanding the differences helps you choose the right tool for your work and troubleshoot problems faster.

 


Windows vs. macOS vs. Linux — Side by Side

 

 

Windows 11

macOS Sequoia

Linux (Ubuntu)

Market Share

~72% of desktop PCs

~15% (premium laptops)

~3% desktop, ~70% servers

Best For

Gaming, office work, general use, enterprise

Creative professionals, developers, Apple ecosystem users

Developers, servers, privacy advocates, tech enthusiasts

Software

Largest selection of any OS

Strong creative apps (Final Cut, Logic Pro)

Free and open-source, huge developer toolset

Gaming

Excellent — most games are Windows-first

Improving but behind Windows

Growing via Steam/Proton but limited AAA titles

Security

Most targeted by malware (due to market share)

Historically better, but increasingly targeted

Considered most secure for advanced users

Customisation

Moderate

Limited (Apple controls the ecosystem)

Unlimited — change everything about the UI and behaviour

Cost

Included with most PCs; ~$139 standalone

Included with Mac hardware

Free — always

Learning Curve

Familiar to most users

Easy for new users; learning curve from Windows

Steep for beginners, rewarding for learners

 

Essential Windows 11 Settings Everyone Should Configure

        Privacy > App Permissions — review which apps have access to your camera, microphone, and location. Disable anything unnecessary.

        System > Power & Battery — set your display sleep and PC sleep timers. 5 minutes display / 20 minutes sleep is a good balance.

        Windows Update > Advanced Options — enable 'Receive updates for other Microsoft products' to keep Office updated too.

        System > Storage > Storage Sense — enable this to automatically clean temp files. Set it to run every month.

        Accounts > Sign-in Options — set up Windows Hello (face recognition or fingerprint). 10x faster than typing a password.

        System > Clipboard > Clipboard History — enable this to store your clipboard history. Press Win+V to access it anytime.

        Personalisation > Taskbar — pin your most-used apps and remove the clutter from the taskbar for a cleaner workspace. 



🔒  Computer Security — Protecting Yourself Online

Cybercrime costs individuals and businesses over $8 trillion globally each year. Most attacks succeed not because of sophisticated hacking — but because of basic security mistakes that are completely preventable. This section covers what you actually need to do.

 


Password Security — The Foundation of Digital Safety

Weak passwords are responsible for over 80% of data breaches. Here is what strong password hygiene actually looks like in practice.

 

Shortcut / Key

What It Does

Password Length

Minimum 12 characters. Each extra character exponentially increases crack time. 20+ characters is ideal for critical accounts.

Character Mix

Use UPPERCASE + lowercase + numbers + symbols (!@#$%). A 12-character mixed password takes centuries to crack by brute force.

Uniqueness

Every account must have a different password. When one site is breached, hackers try those credentials everywhere else (credential stuffing).

Password Manager

Use one. LastPass, Bitwarden (free + open source), 1Password, or Dashlane. They generate and store complex passwords so you only remember one master password.

What NOT to Use

Your name, birthdate, pet's name, 'password', '123456', or any word in a dictionary. These are cracked in seconds.

Two-Factor Authentication (2FA)

Enable 2FA on every important account. Even if your password is stolen, the attacker cannot log in without your phone. Use an authenticator app (not SMS where possible).

Passphrase Alternative

Four random words strung together (e.g., 'correct-horse-battery-staple') is both strong AND memorable. Easier than random characters.

Have I Been Pwned

Check haveibeenpwned.com to see if your email or passwords have appeared in known data breaches. Free and trustworthy.

 

Recognising Phishing Attacks

Phishing is the most common cyberattack and it relies entirely on you clicking something you should not. Learning to spot it is the single most important security skill.

 

        Check the sender's actual email address — not just the display name. Attackers use addresses like 'support@paypa1.com' (note the '1' instead of 'l').

        Hover over links before clicking. The actual URL appears in the bottom left of your browser. If it does not match the claimed destination, do not click.

        Be suspicious of urgency — 'Your account will be suspended in 24 hours!' is a pressure tactic designed to stop you thinking clearly.

        Legitimate companies never ask for passwords, full credit card numbers, or PINs via email or text message.

        Check for generic greetings — 'Dear Customer' instead of your actual name suggests a bulk phishing campaign.

        Look for poor grammar and spelling — many phishing emails originate from non-native speakers or automated tools.

        Verify separately — if an email asks you to take action on your bank account, close the email and go directly to the bank's website by typing the URL yourself.

 

🚨

Real Attack Example: An email arrives saying your Netflix subscription failed. It links to 'netf1ix-billing.com'. The display name says Netflix. The urgency, the fake domain, and the password request are all classic phishing signals.

 

Essential Security Practices — Your Personal Checklist

 

        Keep your OS and browser updated. Most malware exploits known vulnerabilities that patches have already fixed.

        Use a reputable antivirus. Windows Defender (built into Windows 10/11) is genuinely good. Malwarebytes free version is excellent for periodic scans.

        Do not use public Wi-Fi for banking, shopping, or any sensitive login — use your phone's hotspot instead, or a VPN.

        Back up your data using the 3-2-1 rule: 3 copies, on 2 different media types, with 1 copy offsite (cloud counts).

        Enable full-disk encryption: BitLocker on Windows, FileVault on Mac. If your laptop is stolen, your data is unreadable.

        Review app permissions on your phone every few months. Revoke camera/location/microphone access from apps that do not need them.

        Use HTTPS everywhere — check for the padlock in your browser address bar. Avoid entering any data on HTTP sites.

 



📁  File Management & Organization — Work Smarter

A disorganised file system wastes time every single day. Finding the right document, managing file versions, and knowing where everything lives is a fundamental productivity skill.

 


File Naming Best Practices

        Use dates in ISO format at the start: 2025-03-15_ProjectReport_v2.docx — files then sort chronologically automatically.

        Be descriptive but brief — 'Q1_Marketing_Budget_Draft.xlsx' is better than 'budget2.xlsx' or 'final_FINAL_revised(2).xlsx'.

        Avoid spaces in file names for anything technical — use hyphens or underscores. 'My File.txt' can cause issues in code and command line.

        Version control: use v1, v2, v3 — never 'final', 'final2', 'ACTUAL_final'. You will always need another version.

        Use all lowercase for file names you share across systems — Windows is case-insensitive but Linux and macOS are not.

 

Useful File Extensions to Know

 

Extension

Type

What It Is / When You Use It

.exe

Executable

A program you can run. Be careful with .exe files from unknown sources — they can contain malware.

.dll

Dynamic Link Library

Shared code files used by multiple programs. Never delete unless you know exactly what it is.

.pdf

Portable Document Format

Universal read-only document format. Best for sharing final documents.

.docx

Word Document

Microsoft Word file. Editable, widely compatible.

.xlsx

Excel Spreadsheet

Microsoft Excel file. Standard for data, finance, and analysis.

.csv

Comma-Separated Values

Plain text spreadsheet data. Universally compatible with any spreadsheet app or database.

.zip / .rar / .7z

Compressed Archives

Multiple files compressed into one. Use 7-Zip (free) to open all formats on Windows.

.json

JSON Data File

Human-readable data exchange format. Used heavily in web development and APIs.

.log

Log File

Plain text records of system or application events. Useful for troubleshooting.

.iso

Disk Image

An exact copy of a CD/DVD/USB. Used to install operating systems or create bootable drives.

.svg

Scalable Vector Graphic

Image format that scales to any size without quality loss. Ideal for logos and icons.

.mp4

Video File

The most universal video format. Use this unless you have a specific reason to use another.

 

Command Prompt & Terminal — Powerful Tools for Every User

You do not need to be a programmer to use the command line. These commands solve real problems in seconds that would take minutes through a GUI.

 

Shortcut / Key

What It Does

ipconfig

Shows your IP address, default gateway (router IP), and DNS settings. First step in network troubleshooting.

ipconfig /flushdns

Clears the DNS cache — fixes websites that refuse to load even though your internet works.

ping google.com

Tests whether your internet connection is working and measures latency. If it fails, you have no internet.

tracert google.com

Traces the route data takes to reach a destination — shows exactly where a connection problem is occurring.

netstat -an

Shows all active network connections and which ports they use. Useful for spotting unusual connections.

tasklist

Lists all running processes — command line version of Task Manager.

taskkill /IM chrome.exe /F

Force-closes a frozen application. Replace chrome.exe with any process name from tasklist.

sfc /scannow

Scans and repairs corrupted Windows system files. Run as Administrator when things are acting strangely.

chkdsk C: /f /r

Checks your drive for errors and bad sectors. Run on problem drives.

dir

Lists all files and folders in the current directory.

cd foldername

Change Directory — navigate into a folder. cd .. goes back one level.

cls

Clear Screen — clears the terminal window of all previous output.

shutdown /s /t 60

Schedules a shutdown in 60 seconds. Change 60 to any number of seconds. /r for restart instead of /s.

 

💡

Safe Mode Tip: If Windows is behaving strangely, hold Shift while clicking Restart, then go to Troubleshoot > Advanced Options > Startup Settings > Restart > Press 4. This boots into Safe Mode where you can diagnose and fix issues without interference from third-party software.

 



⚡  Performance Optimization — Make Any PC Faster

You do not always need new hardware to get better performance. These are the most impactful things you can do right now, in order of effect.

 

📷 IMAGE: Before/after speedometer graphics showing PC performance improvement — or a checklist with checkmarks beside each completed optimization

Immediate Wins — Do These Today

 

        1. DISABLE STARTUP PROGRAMS — Open Task Manager > Startup tab. Disable everything that is not essential. This alone can cut 30-90 seconds from boot time.

        2. UPGRADE TO AN SSD — If you are still on a mechanical HDD, upgrading to a SATA SSD is the single biggest performance upgrade you can make on an older PC. Boot time drops from 60 seconds to under 10.

        3. ADD MORE RAM — Running out of RAM causes Windows to use your much-slower storage as virtual memory. 8 GB is the absolute minimum; 16 GB is the 2025 standard.

        4. CHECK DISK SPACE — Windows needs 15-20% free space on your C: drive to operate efficiently. Under 10% free causes significant slowdowns.

        5. RUN DISK CLEANUP — Search for 'Disk Cleanup' in Windows, select your C: drive, and check all boxes. Also click 'Clean up system files' for even more space.

        6. ADJUST VISUAL EFFECTS — Right-click on This PC > Properties > Advanced System Settings > Performance Settings. Choose 'Adjust for best performance' on older hardware.

        7. KEEP DRIVERS UPDATED — Especially GPU drivers. Go to NVIDIA or AMD's website directly rather than Windows Update for the latest GPU drivers.

        8. SCAN FOR MALWARE — Malware and adware constantly running in the background dramatically slow systems. Run Malwarebytes (free) monthly.

 

Long-Term Maintenance Schedule

 

Frequency

Hardware / System

Software / Security

Weekly

Clear browser cache and temp files

Run Disk Cleanup or Storage Sense; restart your PC at least once

Monthly

Check for and install Windows updates

Run Malwarebytes full scan; review and clear Downloads folder

Every 3 Months

Clean dust from vents and fans

Check disk health with CrystalDiskInfo (free); uninstall unused software

Every 6 Months

Back up important files to external drive or cloud

Review startup programs again; update all software and browsers

Yearly

Full factory reset consideration on very old machines

Reassess whether hardware upgrades are more cost-effective than repair

 

💡

Thermal Throttling Warning: Dust buildup in laptop vents is one of the most common causes of performance degradation over time. If your laptop feels hot and runs sluggishly, carefully cleaning the vents with compressed air can restore full performance — often dramatically.

 

🎯  Conclusion — Your Computer, Fully Unlocked

Computers are tools — and like any tool, you get dramatically more out of them when you understand how they work. The knowledge in this guide is not theoretical. Every section is something you can apply today, right now, to save time, solve problems, and work more effectively.

Start with the shortcuts. They cost nothing and the return on investment is immediate. Then secure your passwords and enable two-factor authentication on your important accounts — this single step protects you from the vast majority of online threats.

Next time your internet stops working, you will know what questions to ask. Next time someone asks whether they should buy more RAM or a bigger hard drive, you will know the answer. That is the point of this guide: not to turn you into a computer scientist, but to give you the practical knowledge that makes a real difference every day.

 

💡

Final Tip: Share this guide with someone who would benefit from it. Teaching something is the fastest way to make knowledge stick — and the best way to add value to the people around you.

 

Computer Fundamentals: The Ultimate Cheat Sheet — 2025 Edition

All shortcuts and specifications are current as of early 2025. Windows 11, macOS Sequoia, and major browser versions were 


Comments

Popular posts from this blog

TOP 10 MOST VISITED AI WEBSITES IN THE WORLD