· Excel Functions A–Z · 1 min read

JIS Function in Excel: Half-Width to Full-Width Characters

JIS converts half-width characters to full-width (double-byte), mainly for Japanese documents. It is available only when Japanese is enabled as an editing language (File > Options > Language); otherwise Excel shows #NAME?. DBCS does the same job and exists in every version.

Read article →

· Fun Facts · 2 min read

Why Do Clocks Go Clockwise?

Clocks turn "clockwise" because of sundials: in the northern hemisphere a sundial's shadow sweeps left to right. The short history of why every clock copied it.

Read article →

· Excel Formulas · 3 min read

Excel Lesson 16: Conditional Formatting

Make important cells stand out automatically: highlight rules, top/bottom, data bars, colour scales and icon sets, formula rules that colour whole rows, managing rule order, and keeping it readable.

Read article →