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 →Atul Vij
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 →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 →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 →IMDIV Function in Excel: Divide Complex Numbers
IMDIV Function in Excel: Divide Complex Numbers
Calculate the quotient of two complex numbers in rectangular form (x+yi or x+yj), widely used in AC circuit impedance and phasor calculations.
Read article →IMCOS Function in Excel: Cosine of a Complex Number
IMCOS Function in Excel: Cosine of a Complex Number
Determine the cosine of a complex number in rectangular coordinates (x+yi or x+yj) for sinusoidal frequency response modeling.
Read article →IMEXP Function in Excel: e to a Complex Power
IMEXP Function in Excel: e to a Complex Power
Calculate the exponential of a complex number (e^z) in Excel using Euler's formula for rotating phasors and transient oscillations.
Read article →IMREAL Function in Excel: Real Part
IMREAL Function in Excel: Real Part
Extract the real coefficient a from a complex number formatted as text (a+bi or a+bj) as a numeric value.
Read article →IMCOT Function in Excel: Cotangent of a Complex Number
IMCOT Function in Excel: Cotangent of a Complex Number
Calculate the cotangent of a complex number in x+yi or x+yj format for advanced wave mechanics, fluid dynamics, and transmission line equations.
Read article →