Office Scripts: Highlight Duplicates in a Table With One Button
A short Office Script for Excel on the web that highlights duplicate values in a chosen column, clears old highlights and runs from a…
Read article →Markets today
- 1 USD₹94.96
- 1 EUR₹106.86
- 1 GBP₹126.63
- 1 JPY₹0.601
- 1 CNY₹14.20
- 1 CHF₹115.25
Since 2016 · Atul Vij →
Automate your Excel reports
Free tutorials, tested files and tools that run in your browser.
Explore topics
Pick a pocket of knowledge🤯 Wacky fact
People confided in a 1960s chatbot that was only matching patterns.
Joseph Weizenbaum’s ELIZA (1966) mostly turned users’ sentences back into questions. Even so, some users became emotionally attached — Weizenbaum wrote that his secretary asked him to leave the room so she could talk to it privately. Treating a program…
Free course
Excel VBA in 15 lessons
From your first variable to UserForms, with a practice workbook that has every macro on a button.
15 of 15 lessons published
Start lesson 1 →Latest articles
Why Do We Yawn — and Why Is It Contagious?
Why Do We Yawn — and Why Is It Contagious?
The old "yawning brings in oxygen" idea doesn't hold up. What scientists think yawning is for — brain cooling, alertness — and why seeing…
Read article →Excel Sparklines: Tiny Trend Charts Inside Cells
Excel Sparklines: Tiny Trend Charts Inside Cells
Add line, column and win/loss sparklines next to each row of a report, highlight highs and lows, fix the axis so rows compare fairly,…
Read article →Smart View Lesson 2: Connecting and Your First Ad Hoc Grid
Smart View Lesson 2: Connecting and Your First Ad Hoc Grid
Connect Smart View to Essbase or EPM Cloud with a private or shared connection, open an ad hoc grid, refresh, and set the most…
Read article →Lost Your Android Phone? Find, Lock or Erase It Remotely
Lost Your Android Phone? Find, Lock or Erase It Remotely
Use Google's Find Hub (earlier called Find My Device) to ring, locate, lock or erase a lost Android phone, what to set up today…
Read article →Ship It Safely: Secrets, Data and Maintenance
Ship It Safely: Secrets, Data and Maintenance
Share your AI-built tool responsibly: keep API keys out of code, protect personal data, write a README, version it with Git and plan for…
Read article →PowerShell for Office Work: 10 Small Scripts That Save Real Time
PowerShell for Office Work: 10 Small Scripts That Save Real Time
Practical PowerShell for non-programmers: rename hundreds of files, find duplicates, combine CSVs, clean old downloads, check disk space and more — each script explained…
Read article →What to Automate First: Picking Office Tasks That Are Worth It
What to Automate First: Picking Office Tasks That Are Worth It
A simple way to decide which repetitive task to automate first: frequency, time, error cost and stability — with a scoring sheet and examples…
Read article →Why Does Ice Float? (And Why Life Depends on It)
Why Does Ice Float? (And Why Life Depends on It)
Most solids sink in their own liquid, but ice floats because frozen water molecules lock into an open crystal that is about 9% less…
Read article →COMPLEX Function in Excel: Build a Complex Number
COMPLEX Function in Excel: Build a Complex Number
COMPLEX builds a complex number like 3+4i from its real and imaginary parts, as text that the IM… functions understand. Used in AC circuits…
Read article →Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Learn Oracle Smart View ad hoc analysis step by step — connect, zoom, pivot, keep only, POV and suppression options — explained for Excel…
Read article →Is This Shopping Website Safe? 7 Checks Before You Pay
Is This Shopping Website Safe? 7 Checks Before You Pay
Seven quick checks before paying on an unfamiliar shopping site: the real domain, too-good prices, contact details, reviews, return policy, payment options and site…
Read article →