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 →Markets today
- 1 USD₹95.16
- 1 EUR₹106.53
- 1 GBP₹126.25
- 1 JPY₹0.601
- 1 CNY₹14.22
- 1 CHF₹114.18
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
India has one of the world’s largest dinosaur egg sites.
Hundreds of titanosaur nests with fossil eggs have been found in the Narmada valley in Madhya Pradesh.
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
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 →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 QWERTY? The Real Story of the Keyboard Layout
Why QWERTY? The Real Story of the Keyboard Layout
Why the letters on your keyboard are in such a strange order: typewriter jams, telegraph operators, a famous patent and why nobody switched even…
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 →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 →Refresh Oracle Smart View Sheets Automatically with VBA
Refresh Oracle Smart View Sheets Automatically with VBA
Use the Smart View VBA functions HypConnect, HypRetrieve and HypDisconnect to refresh every Essbase/EPM sheet in a workbook with one click.
Read article →How Does a Microwave Heat Food? (And Why It Doesn’t Cook From the Inside)
How Does a Microwave Heat Food? (And Why It Doesn’t Cook From the Inside)
Microwaves make water molecules spin and jostle, turning wave energy into heat in the outer few centimetres of food. How it works, why some…
Read article →