Run Long SAP Reports in the Background (SM36 and SM37 for Business Users)
Stop SAP reports timing out: run them in the background with a variant, schedule them daily or monthly, check status and spool output in…
Read article →Markets today
- 1 USD₹94.93
- 1 EUR₹106.56
- 1 GBP₹126.55
- 1 JPY₹0.600
- 1 CNY₹14.21
- 1 CHF₹115.06
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
<span class="aj-year">1842</span>The word “dinosaur” means “terrible lizard”.
Richard Owen coined the name in 1842 from Greek deinos (terrible) and sauros (lizard).
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
Office Scripts: Highlight Duplicates in a Table With One Button
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 →IMDIV Function in Excel: Divide Complex Numbers
IMDIV Function in Excel: Divide Complex Numbers
IMDIV divides one complex number by another, e.g. current = voltage / impedance.
Read article →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 →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 →Context Windows Explained: How Much Can an AI Read at Once?
Context Windows Explained: How Much Can an AI Read at Once?
What an AI model's context window is, why long chats get worse, what happens when you hit the limit, and practical ways to work…
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 →How Data Gets From Your ERP Into Oracle EPM Planning
How Data Gets From Your ERP Into Oracle EPM Planning
Source system, locations, import formats, mappings and data rules: a plain-English walk through Oracle EPM Cloud data integration and where loads usually go wrong.
Read article →Document a Process Before You Automate It: A One-Page Template
Document a Process Before You Automate It: A One-Page Template
A one-page template to write down any office process — trigger, inputs, steps, rules, exceptions, outputs and checks — so automation projects start from…
Read article →IMCOT Function in Excel: Cotangent of a Complex Number
IMCOT Function in Excel: Cotangent of a Complex Number
IMCOT returns 1/tan(z). Complex numbers are text like 3+4i; build them with COMPLEX.
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 →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 →