Send Emails from Excel with VBA and Outlook (With Attachments)
A tested Excel VBA macro that sends personalised Outlook emails from a list — with attachments, CC, a preview mode and a log column.
Read article →Author Archives: Atul Vij
Excel Tables (Ctrl+T): 10 Reasons to Use Them for Every List
Excel Tables (Ctrl+T): 10 Reasons to Use Them for Every List
Formatting a range as an Excel Table gives you auto-expanding formulas, readable references, slicers, totals and pivot sources that never miss new rows. Ten…
Read article →Excel Date Formulas Cheat Sheet: 25 Formulas You Will Actually Use
Excel Date Formulas Cheat Sheet: 25 Formulas You Will Actually Use
A cheat sheet of Excel date formulas: first and last day of the month, quarters, Indian financial year, working days, age, week numbers, adding…
Read article →7 Prompt Patterns That Get Better Answers from ChatGPT and Claude
7 Prompt Patterns That Get Better Answers from ChatGPT and Claude
Seven practical prompt patterns — context, examples, format, steps, constraints, delimiters and questions first — with before-and-after prompts you can reuse.
Read article →PowerPoint Presenter View: 7 Tricks for Calmer Presentations
PowerPoint Presenter View: 7 Tricks for Calmer Presentations
Use PowerPoint’s Presenter View to see notes, the next slide and a timer while the audience sees only your slides — plus shortcuts to…
Read article →Java Streams for Beginners: filter, map and collect Explained
Java Streams for Beginners: filter, map and collect Explained
Java Streams let you process lists in a clear, declarative style. Learn filter, map, sorted, collect and groupingBy with a small sales example.
Read article →Python for Office Automation: The Complete Starter Guide
Python for Office Automation: The Complete Starter Guide
Use Python to automate everyday office work: set up Python, handle files and folders, read and write Excel, create Word reports, send emails safely,…
Read article →Why Is the “Save” Icon a Floppy Disk? A Short History
Why Is the “Save” Icon a Floppy Disk? A Short History
The floppy disk save icon outlived the floppy disk by decades. Where the 3.5-inch disk came from, why it became the save symbol, and…
Read article →In-Cell Bar Charts in Excel: REPT, Data Bars and Sparklines
In-Cell Bar Charts in Excel: REPT, Data Bars and Sparklines
Three ways to show charts inside cells — the REPT formula trick, conditional-formatting Data Bars and Sparklines — for compact dashboards that update automatically.
Read article →Excel Shortcut of the Week: Ctrl+E Flash Fill
Excel Shortcut of the Week: Ctrl+E Flash Fill
Flash Fill (Ctrl+E) splits, joins and reformats text by example — no formulas. How to use it, five real examples, and when to use…
Read article →Merge 100 Excel Files into One with Python (in 10 Lines)
Merge 100 Excel Files into One with Python (in 10 Lines)
Combine every Excel file in a folder into one sheet with Python and pandas — with a source column, header checks and a summary.
Read article →8 Android Features Most People Never Find
8 Android Features Most People Never Find
Share Wi-Fi with a QR code, pin an app before lending your phone, live captions, Quick Share and more — useful Android features available…
Read article →