Skip to content

AJ's Techie & Wacky World

  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact
  • 📲 Get App
Mail Merge from Excel to Word: Letters, Emails and Labels (Step by Step)

1 Oct 2023 · Word · 3 min read

Mail Merge from Excel to Word: Letters, Emails and Labels (Step by Step)

Send personalised letters, emails or labels from an Excel list with Word Mail Merge — including number and date formatting fixes that trip everyone up.

Read article →
Build a Monthly MIS Report in Excel From Scratch (Complete Guide)

1 Oct 2023 · Charts & Dashboards · 4 min read

Build a Monthly MIS Report in Excel From Scratch (Complete Guide)

A complete, reusable monthly MIS workbook: raw data sheets, a mapping table, SUMIFS-driven P&L and KPI pages, variance vs budget and last year, conditional formatting, charts, and a one-click monthly refresh.

Read article →
BESSELI Function in Excel: Modified Bessel Function In(x)

24 Sep 2023 · Engineering · 1 min read

BESSELI Function in Excel: Modified Bessel Function In(x)

BESSELI returns the modified Bessel function In(x), used in heat transfer, signal processing and vibration problems.

Read article →
Outlook Calendar Tricks for Busy Weeks

21 Sep 2023 · Outlook · 2 min read

Outlook Calendar Tricks for Busy Weeks

Practical Outlook calendar features: Scheduling Assistant, shorter meetings by default, a second time zone, focus blocks, propose new time, sharing and quick keyboard shortcuts.

Read article →
Temperature and Top-p Explained: Why the Same Prompt Gives Different Answers

19 Sep 2023 · LLMs · 2 min read

Temperature and Top-p Explained: Why the Same Prompt Gives Different Answers

What the temperature and top-p settings in AI models actually do, with a worked numeric example, and which values to use for code, data extraction and creative writing.

Read article →
Outlook Rules and Quick Steps That Actually Clean Your Inbox

17 Sep 2023 · Outlook · 2 min read

Outlook Rules and Quick Steps That Actually Clean Your Inbox

Set up Outlook rules, Quick Steps, search folders and a few smart habits so your inbox sorts itself — with real examples for reports, alerts and follow-ups.

Read article →
BESSELK Function in Excel: Modified Bessel Function Kn(x)

15 Sep 2023 · Engineering · 1 min read

BESSELK Function in Excel: Modified Bessel Function Kn(x)

EngineeringLevel: ExpertAvailable in: Excel 2007+BESSELK returns the modified Bessel function of the second kind, Kn(x).Syntax=BESSELK(x, n)ArgumentWhat.

Read article →
AutoHotkey Lesson 5: Variables, Input Boxes and Message Boxes

15 Sep 2023 · AutoHotkey · 1 min read

AutoHotkey Lesson 5: Variables, Input Boxes and Message Boxes

Make scripts interactive: variables and expressions, InputBox to ask for a value, MsgBox with Yes/No, simple calculations like GST, and reading the clipboard.

Read article →
AutoHotkey Lesson 4: Send Keys and Mouse Clicks Safely

14 Sep 2023 · AutoHotkey · 2 min read

AutoHotkey Lesson 4: Send Keys and Mouse Clicks Safely

Automate repetitive typing with Send, SendText and SetKeyDelay, use waits instead of guesses, click with coordinates relative to the window, and stop runaway scripts.

Read article →
AutoHotkey Lesson 3: Hotkeys for Apps and Windows

13 Sep 2023 · AutoHotkey · 1 min read

AutoHotkey Lesson 3: Hotkeys for Apps and Windows

Make hotkeys that work only in certain apps with #HotIf WinActive, switch to or launch apps with one key, and control window size and position.

Read article →
AutoHotkey Basics: Your First Script

12 Sep 2023 · AutoHotkey · 3 min read

AutoHotkey Basics: Your First Script

Type short codes that expand into full text: hotstrings, options for instant expansion and case, multi-line replies, dates, and a personal snippet library.

Read article →
Send Emails from Excel with VBA and Outlook (With Attachments)

11 Sep 2023 · Excel VBA · 3 min read

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 →
Older posts
Newer posts
← Previous Page1 … Page60 Page61 Page62 … Page107 Next →

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →