PHONETIC Function in Excel: Furigana Reading of Japanese Text
PHONETIC returns the phonetic (furigana) characters stored with Japanese text typed on a Japanese input method. Text without stored furigana (anything typed in English,…
Read article →Atul Vij
SQRTPI Function in Excel: Square Root of x Times Pi
SQRTPI Function in Excel: Square Root of x Times Pi
Maths & trigLevel: ExpertAvailable in: Excel 2007+SQRTPI returns SQRT(x*PI()), which turns up in statistics and physics.
Read article →ASC Function in Excel: Full-Width to Half-Width Characters
ASC Function in Excel: Full-Width to Half-Width Characters
ASC converts full-width (double-byte) letters and katakana to half-width. In English text there is nothing to convert, so text comes back unchanged.
Read article →Back Up a WordPress Site Automatically: The 3-2-1 Way
Back Up a WordPress Site Automatically: The 3-2-1 Way
A practical backup plan for a self-hosted WordPress site: database and files every night, a copy off the server, retention, and — most importantly…
Read article →Website Not Logging In? Clear Cookies for Just That Site
Website Not Logging In? Clear Cookies for Just That Site
Fix "keeps logging me out", endless login loops and stale pages by clearing cookies and cache for one website only — without signing out…
Read article →Windows Search Not Finding Your Files? Fix the Search Index
Windows Search Not Finding Your Files? Fix the Search Index
When Windows search can't find a file you know exists: switch to Enhanced indexing, add folders, rebuild the index and search inside file contents…
Read article →Why Do Clocks Go Clockwise?
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…
Read article →Excel Lesson 16: Conditional Formatting
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…
Read article →Was Your Email in a Data Breach? How to Check and What to Do
Was Your Email in a Data Breach? How to Check and What to Do
Check whether your email address appeared in a known data breach, understand what was exposed, and the four steps to take afterwards — passwords,…
Read article →JavaScript Lesson 5: Arrays — map, filter, reduce
JavaScript Lesson 5: Arrays — map, filter, reduce
Work with lists of data: create and index arrays, filter rows, map to new values, reduce to totals and groups, sort, and the spread…
Read article →Partial Match and Wildcard Lookups in Excel (Contains, Starts With, Ends With)
Partial Match and Wildcard Lookups in Excel (Contains, Starts With, Ends With)
Find "Raj Traders Pvt Ltd" when you only typed "Raj", look up codes that start with a prefix, and sum or count rows that…
Read article →Excel for Finance Lesson 2: TDS Register and Quarterly Summary
Excel for Finance Lesson 2: TDS Register and Quarterly Summary
Maintain a TDS register in Excel: section-wise rates, the higher rate without PAN, TDS per payment, monthly deposit totals and due dates, and a…
Read article →