One Slicer for Several Pivot Tables (Plus Timelines for Dates)
Connect a single slicer to multiple pivot tables and charts with Report Connections, add a timeline for months and quarters, and fix the "not…
Read article →Markets today
- 1 USD₹94.94
- 1 EUR₹106.27
- 1 GBP₹126.92
- 1 JPY₹0.605
- 1 CNY₹14.23
- 1 CHF₹115.17
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
Water expands by about 9% when it freezes.
Most substances shrink when they solidify, but water molecules lock into an open hexagonal crystal as ice. That is why ice floats, pipes burst in winter and lakes freeze from the top down, protecting the life below.
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 Does Popcorn Pop?
Why Does Popcorn Pop?
Each popcorn kernel is a tiny pressure cooker: water inside turns to steam behind a tough hull until it bursts at around 180°C and…
Read article →Google Lens on Your Computer: Search With an Image
Google Lens on Your Computer: Search With an Image
Right-click any image in Chrome to search with Google Lens: identify products and plants, copy text from pictures, translate signs and find where a…
Read article →Run Long SAP Reports in the Background (SM36 and SM37 for Business Users)
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 →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 →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 →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 →What Do the Colours of Milestones on Indian Roads Mean?
What Do the Colours of Milestones on Indian Roads Mean?
Yellow, green, black-and-white and orange milestones tell you what kind of road you are on in India — national highway, state highway, district road…
Read article →Use Your Android Phone From Windows With Phone Link
Use Your Android Phone From Windows With Phone Link
Read and reply to messages, see notifications, make calls and copy photos from your Android phone on a Windows PC with Microsoft Phone Link…
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 →