← Home

Guides

Practical knowledge behind our tools: short, clear and actionable guides. Each one ends with a quick link to the related tool.

CSV encoding problems in Excel

When a CSV file shows broken letters in Excel, encoding is the cause. Why it happens, three ways to fix it and what a BOM does.

Reducing image size: JPG vs PNG vs WebP

Which image format to pick, how large an image really needs to be, and how to shrink a file without visible quality loss. A short, practical guide.

What is a JWT?

A JWT (JSON Web Token) has three parts. What is inside, what the signature does, how to read exp and the common security mistakes.

How to work out VAT

The easy way to work out VAT: add or remove VAT from a price, VAT fractions for 20% and 5%, Excel formulas and worked examples.

What is Base64?

Base64 is an encoding that turns binary data into text. How it works, why it adds 33%, where it is used and why it is not encryption.

How to create a QR code

What to watch for when creating a QR code: error correction level, size, color, printing and testing before you publish. Examples for Wi-Fi, WhatsApp and contact cards.

File naming best practices

Practical rules for spaces, dates, sequence numbers and special characters in file names, with examples of bulk renaming.

Percentage calculation guide

Finding a percentage, percentage increase and decrease, discount math and the difference between percent and percentage points. The four basic formulas with examples.

Loan payment formula

The monthly loan payment formula explained step by step, with a worked example, the loan amount formula, the remaining balance formula and the Excel PMT function.

What is JSON and common errors

The rules of the JSON format, common mistakes (trailing commas, single quotes, comments) and what to watch for with large numbers.

How Turkish ID numbers are validated

The 11-digit rule, the first-digit rule and the two check digits of a Turkish ID number, a worked example and what a format check does not show.

What is an IBAN and how to validate it

The parts of an IBAN, the structure of a Turkish IBAN, a step-by-step mod 97 checksum example and what validation does not show about the account.

How to create a strong password

How long and random a strong password should be, what entropy means and why a password manager matters.

How to find the difference between two texts

How the difference between two texts is found line by line, the longest common sequence idea, how whitespace and case differences are handled and practical tips.

What are HEX, RGB and HSL color codes

What HEX, RGB and HSL color codes mean, how they differ, a step-by-step HEX to RGB conversion and when to use which.

What is color contrast (WCAG)

What the color contrast ratio is, how it is calculated, the ratios WCAG AA and AAA require and why gray text so often fails.

How to write numbers in words

How to write numbers in words in English: hyphens from twenty-one to ninety-nine, when to use "and", decimals, large numbers and how to write an amount on a check.