Your ultimate collection of online tools for productivity and calculations
Drag & drop PDF files here or click to select files
=SUM(A1:A10)
Adds all numbers in a range
=AVERAGE(B1:B10)
Calculates the average of numbers
=COUNT(C1:C10)
Counts cells with numbers
=IF(D1>10, "Yes", "No")
Logical test and result
=VLOOKUP(E1,A:B,2,FALSE)
Search for value in table
=CONCATENATE(F1," ",G1)
Joins text from multiple cells
=MAX(H1:H10)
Finds the maximum value
=MIN(I1:I10)
Finds the minimum value
=ROUND(J1,2)
Rounds to specified decimal places
=LEFT(K1,3)
Extracts characters from left
=RIGHT(L1,3)
Extracts characters from right
=MID(M1,2,4)
Extracts characters from middle
=LEN(N1)
Returns length of text
=UPPER(O1)
Converts text to uppercase
=LOWER(P1)
Converts text to lowercase
=PROPER(Q1)
Capitalizes first letter of each word
=DATE(2023,12,25)
Creates a date
=TODAY()
Returns current date
=NOW()
Returns current date and time
=DAYS(R2,R1)
Calculates days between dates
=TEXT(S1,"mm/dd/yyyy")
Formats number as text
=VALUE(T1)
Converts text to number
=TRIM(U1)
Removes extra spaces
=SUBSTITUTE(V1,"old","new")
Replaces text
=FIND("text",W1)
Finds text position
=SEARCH("text",X1)
Searches for text
=REPLACE(Y1,1,3,"new")
Replaces characters
=INDEX(Z:Z,5)
Returns value at position
=MATCH("text",A:A,0)
Finds position of value
=OFFSET(A1,1,1)
Returns reference to range
=INDIRECT("A1")
Returns reference from text
=ADDRESS(1,1)
Returns cell address
=ROW()
Returns row number
=COLUMN()
Returns column number
=CHOOSE(2,"A","B","C")
Chooses value by index
=ISBLANK(A1)
Checks if blank
=ISNUMBER(A1)
Checks if number
=ISTEXT(A1)
Checks if text
=ISERROR(A1)
Checks if error
=IFERROR(A1,"Error")
Handles errors
=AND(A1>10,B1<20)
Logical AND
=OR(A1>10,B1<20)
Logical OR
=NOT(A1>10)
Logical NOT
- Item 1 - Item 2 - Item 3
1. First item 2. Second item 3. Third item
- [ ] Incomplete task - [x] Completed task - [ ] Another task
- Parent item - Child item 1 - Child item 2 - Grandchild item - Another parent item
Ctrl + S
Ctrl + C
Ctrl + V
Ctrl + X
Ctrl + Z
Ctrl + Y
Ctrl + B
Ctrl + I
Ctrl + U
Ctrl + F
Ctrl + H
Ctrl + A
Ctrl + P
Ctrl + N
Ctrl + O
Ctrl + T
Ctrl + K
Alt + Shift + D
Alt + Shift + T
Ctrl + Alt + 1
Ctrl + Alt + 2
Ctrl + Alt + 3
Ctrl + Shift + N
Ctrl + Shift + >
Ctrl + Shift + <
Ctrl + E
Ctrl + L
Ctrl + R
Ctrl + J
Ctrl + .
Ctrl + /
Ctrl + Enter
Ctrl + Shift + Enter
Ctrl + Home
Ctrl + End
Ctrl + Right Arrow
Ctrl + Left Arrow
Double Click
Triple Click
Ctrl + Click
Ctrl + Shift + =
Ctrl + =
Ctrl + Shift + X
Ctrl + Shift + 8
Shift + F3
F4
F7
Shift + F7
Ctrl + Alt + M
Ctrl + Shift + >
Ctrl + Shift + <
Ctrl + Alt + F
Ctrl + Alt + D
Ctrl + Shift + F5
Ctrl + Alt + F9
Ctrl + Shift + O
F9
Alt + Shift + P
Alt + Shift + H
Alt + Shift + F
Alt + Ctrl + S
Alt + =
Ctrl + Shift + F8
Alt + N, P
Alt + N, C
Alt + N, T
Ctrl + K
Ctrl + Alt + Shift + S
Alt + Ctrl + F9
Alt + Ctrl + Shift + R
Alt + Ctrl + Shift + G
Ctrl + Shift + E
Alt + Ctrl + L
Alt + Shift + F
Alt + Shift + L
Alt + Shift + K
Alt + Shift + F9
Alt + Shift + F7
Alt + Shift + F5
Alt + Shift + F8
Alt + Shift + F6
Alt + Shift + F4
Alt + Shift + F3
Alt + Shift + F2
Alt + Shift + F1
Alt + Shift + O
Alt + Shift + X
Markdown is a lightweight markup language that you can use to add formatting elements to plaintext text documents. Created by John Gruber in 2004, Markdown is now one of the world's most popular markup languages.
# H1 ## H2 ### H3 #### H4 ##### H5 ###### H6
**Bold text** *Italic text* ***Bold and Italic***
Ordered: 1. First item 2. Second item 3. Third item Unordered: - First item - Second item - Third item Nested: 1. First item - Sub-item - Another sub-item 2. Second item
[Link text](https://example.com)  Reference style: [Link text][1] [1]: https://example.com
Inline code: `code` Block code: ```javascript function hello() { console.log("Hello, World!"); } ```
> This is a blockquote >> Nested blockquote
| Column 1 | Column 2 | Column 3 | |----------|----------|----------| | Cell 1 | Cell 2 | Cell 3 | | Cell 4 | Cell 5 | Cell 6 |
--- *** ___
\* Escape asterisks \# Escape hash \[ Escape brackets
- [x] Completed task - [ ] Incomplete task
Here's a sentence with a footnote. [^1] [^1]: This is the footnote.
Term 1 : Definition 1 Term 2 : Definition 2
Ctrl + C
Ctrl + V
Ctrl + X
Ctrl + Z
Ctrl + Y
Ctrl + A
Ctrl + S
Ctrl + P
Ctrl + F
Ctrl + N
Ctrl + W
F5
Ctrl + Shift + Esc
Windows + L
Windows + R
Windows + S
Alt + Tab
Windows + M
Windows + Up Arrow
Windows + Down Arrow
Windows + Left Arrow
Windows + Right Arrow
Windows
Windows + A
Windows + I
Windows + E
Windows + V
Windows + Shift + S
Windows + Shift + S
Windows + Ctrl + Left/Right
Windows + Ctrl + D
Windows + Ctrl + F4
Windows + Tab
Windows + G
Windows + Ctrl + Enter
Windows + Plus (+)
Windows + Ctrl + O
Windows + U
Windows + P
Windows + Pause/Break
Windows + X, M
Windows + R, control
Windows + R, cmd
Windows + X, A
Ctrl + Shift + Esc
Windows + R, regedit
Windows + R, services.msc
Windows + R, eventvwr
Windows + R, diskmgmt.msc
Windows + R, ncpa.cpl
Windows + R, msinfo32
Windows + R, resmon
Windows + R, perfmon
Windows + X, G
Windows + I, Update & Security
Windows + I, Update & Security
Control Panel > System and Security
Windows + R, rstrui
Windows + R, msconfig
Windows + R, gpedit.msc
Windows + R, lusrmgr.msc
Windows + R, secpol.msc
Windows + R, firewall.cpl
Windows + I, Update & Security
Windows + R, optionalfeatures
Windows + R, appwiz.cpl
Windows + R, defaultprograms
Windows + R, rundll32 printui.dll,PrintUIEntry /il
Windows + R, hdwwiz.cpl
Windows + I, System > Display
Windows + I, System > Sound
Windows + R, powercfg.cpl
Windows + I, Time & Language
Windows + I, Time & Language
Windows + I, Time & Language
Windows + I, Time & Language
Windows + I, Gaming
Windows + I, Cortana
Windows + I, Privacy
Windows + I, Update & Security
Windows + I, Accounts
Windows + I, Personalization
Windows + I, Apps
Windows + I, Network & Internet
Windows + I, System
Windows + I, Ease of Access
Windows + I, Time & Language
Windows + I, Gaming
Windows + I, Cortana
Windows + I, then System
Windows + I, then System > Display
Windows + I, then System > Sound
Windows + I, then Network & Internet
Windows + I, then Personalization
Windows + I, then Apps
Windows + I, then Accounts
Windows + I, then Time & Language
Windows + I, then Gaming
Windows + I, then Cortana
ls
ls -a
ls -l
cd directory_name
pwd
mkdir directory_name
rmdir directory_name
rm -r directory_name
cp source destination
mv source destination
rm filename
rm -f filename
cat filename
less filename
head filename
tail filename
grep "text" filename
find /path -name "filename"
df -h
du -sh directory_name
ps aux
top
kill PID
kill -9 PID
uname -a
free -h
ifconfig
ip addr
ping hostname
ssh user@hostname
scp file user@host:/path
wget URL
curl URL
chmod 755 filename
chown user:group filename
tar -czf archive.tar.gz files
tar -xzf archive.tar.gz
sudo reboot
sudo shutdown -h now
sudo apt update
sudo apt upgrade
sudo apt install package_name
sudo apt remove package_name
apt search package_name
apt show package_name
dpkg -l
systemctl status service_name
sudo systemctl start service_name
sudo systemctl stop service_name
sudo systemctl restart service_name
sudo systemctl enable service_name
sudo systemctl disable service_name
journalctl
journalctl -f
journalctl -b
journalctl -u service_name
netstat -tulpn
ss -tulpn
netstat -s
nslookup domain
dig domain
ip route
ip link show
ip addr show
arp -a
sudo ufw status
sudo ufw enable
sudo ufw disable
sudo ufw allow port
sudo ufw deny port
sestatus
ls -Z
chcon context file
restorecon file
df -h
df -i
du -sh /*
mount
mount /dev/device /mount/point
umount /mount/point
smartctl -a /dev/device
cat /proc/mdstat
vgdisplay
lvdisplay
pvdisplay
vgcreate vg_name /dev/device
lvcreate -L size -n lv_name vg_name
lvextend -L +size /dev/vg_name/lv_name
lvreduce -L -size /dev/vg_name/lv_name
lvremove /dev/vg_name/lv_name
vgremove vg_name
pvremove /dev/device
swapon -s
dd if=/dev/zero of=/swapfile bs=1M count=size
swapon /swapfile
swapoff /swapfile
lscpu
lshw
lsusb
lspci
lsblk
sensors
upower -i /org/freedesktop/UPower/devices/battery_BAT0
uptime
w
who
finger username
id username
groups username
sudo adduser username
sudo deluser username
sudo usermod -aG group username
passwd username
sudo usermod -L username
sudo usermod -U username
crontab -l
crontab -e
ls /etc/cron.*
ls /etc/anacrontab
atq
echo "command" | at now + 1 hour
systemctl list-timers
systemctl list-unit-files
systemctl list-units --type=service --state=running
systemctl --failed
systemctl list-units --type=target
systemctl list-timers
systemctl list-sockets
systemctl list-units --type=path
systemctl list-units --type=device
systemctl list-units --type=mount
systemctl list-units --type=automount
systemctl list-units --type=swap
systemctl list-units --type=snapshot
systemctl list-units --type=slice
systemctl list-units --type=scope
Ctrl + L
Ctrl + C
Ctrl + Z
Ctrl + E
Ctrl + A
Ctrl + W
Ctrl + U
Ctrl + K
Up Arrow
Down Arrow
Tab
Ctrl + R
Ctrl + Left Arrow
Ctrl + Right Arrow
Ctrl + Backspace
Ctrl + Delete
Ctrl + T
Ctrl + Y
Ctrl + C
Ctrl + \
Ctrl + Z
Ctrl + D
Shift + Page Up
Shift + Page Down
Ctrl + Shift + T
Ctrl + Shift + W
Ctrl + Page Up
Ctrl + Page Down
Ctrl + Shift + C
Ctrl + Shift + V
Ctrl + Shift + F
Ctrl + ,
F11
Ctrl + +
Ctrl + -
Ctrl + 0
123 → One Hundred Twenty Three
1,234 → One Thousand Two Hundred Thirty Four
12,345 → Twelve Thousand Three Hundred Forty Five
123,456 → One Hundred Twenty Three Thousand Four Hundred Fifty Six
1,234,567 → One Million Two Hundred Thirty Four Thousand Five Hundred Sixty Seven
One Hundred Twenty Three → 123
One Thousand Two Hundred Thirty Four → 1,234
Twelve Thousand Three Hundred Forty Five → 12,345
One Hundred Twenty Three Thousand Four Hundred Fifty Six → 123,456
One Million Two Hundred Thirty Four Thousand Five Hundred Sixty Seven → 1,234,567
10 → 1010
255 → 11111111
1024 → 10000000000
65535 → 1111111111111111
1000000 → 11110100001001000000
1010 → 10
11111111 → 255
10000000000 → 1024
1111111111111111 → 65535
11110100001001000000 → 1000000
Hello → 01001000 01100101 01101100 01101100 01101111
World → 01010111 01101111 01110010 01101100 01100100
123 → 00110001 00110010 00110011
01001000 01100101 01101100 01101100 01101111 → Hello
01010111 01101111 01110010 01101100 01100100 → World
00110001 00110010 00110011 → 123
72,101,108,108,111 → Hello
87,111,114,108,100 → World
49,50,51 → 123
Hello → 72,101,108,108,111
World → 87,111,114,108,100
123 → 49,50,51
H → 72
e → 101
l → 108
o → 111
W → 87
r → 114
d → 100
1 → 49
2 → 50
3 → 51
72 → H
101 → e
108 → l
111 → o
87 → W
114 → r
100 → d
49 → 1
50 → 2
51 → 3
2001:0db8:85a3:0000:0000:8a2e:0370:7334 → Binary representation of IPv6 address
::1 → 0000000000000000000000000000000000000000000000000000000000000001
fe80::1 → 1111111010000000000000000000000000000000000000000000000000000001