Skip to content

Popular topics

ExcelExcel VBAPower Query & PivotsExcel for FinanceAutomationSAP & OracleCodingAI & MLTech tipsWacky World

Recent posts

  • Basics of VBA / Macros Chapter – 80 (Userform Part-1)
  • Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
  • Basics of VBA / Macros Chapter – 68 (Application Object Part-1)
  • Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
  • Loan Amortization Schedule in Excel with Extra Payments: Step-by-Step Template & Formulas
  • Excel Month-End Financial Close: Step-by-Step Checklist, Reconciliation Formulas & Template

🤯 Wacky fact of the day · Human Body

The brain uses about 20% of the body’s energy.

Although it is only around 2% of body weight, the brain consumes roughly a fifth of the body’s energy at rest.

Why? How? →Source ↗

AJ's Techie & Wacky World

Excel, SAP, Oracle & automation tips — plus wacky facts

Skip to content
  • ✨ 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

Atul Vij

Prompt Engineering Lesson 4: Step-by-Step Reasoning and Checking

Prompt Engineering Lesson 4: Step-by-Step Reasoning and Checking featured illustration

7 Apr 2025 · Prompt Engineering · 2 min read

Prompt Engineering Lesson 4: Step-by-Step Reasoning and Checking

Get better answers on calculations and decisions: ask for steps, break big tasks into stages, have the model check its own work, and verify…

Read article →
7 April 2025 by Atul Vij Prompt Engineering

Prompt Engineering Lesson 3: Examples and Templates (Few-Shot)

Prompt Engineering Lesson 3: Examples and Templates (Few-Shot) featured illustration

6 Apr 2025 · Prompt Engineering · 1 min read

Prompt Engineering Lesson 3: Examples and Templates (Few-Shot)

Show, don’t tell: give the model one to five examples to copy tone, structure or classification rules, and build reusable prompt templates with placeholders.

Read article →
6 April 2025 by Atul Vij Prompt Engineering

Prompt Engineering Lesson 2: Clear Instructions — Role, Task, Context, Format

Prompt Engineering Lesson 2: Clear Instructions — Role, Task, Context, Format featured illustration

5 Apr 2025 · Prompt Engineering · 1 min read

Prompt Engineering Lesson 2: Clear Instructions — Role, Task, Context, Format

Write prompts that work first time with the role-task-context-format pattern, constraints, audience and length, plus before/after examples for office tasks.

Read article →
5 April 2025 by Atul Vij Prompt Engineering

Prompt Engineering Lesson 1: How Chat AI Reads Your Prompt

Prompt Engineering Lesson 1: How Chat AI Reads Your Prompt featured illustration

4 Apr 2025 · Prompt Engineering · 2 min read

Prompt Engineering Lesson 1: How Chat AI Reads Your Prompt

What happens when you send a prompt: tokens, context windows, next-word prediction, why wording matters, why answers vary, and what the model does and…

Read article →
4 April 2025 by Atul Vij Prompt Engineering

Why AI Chatbots Make Things Up (and 6 Ways to Catch It)

Why AI Chatbots Make Things Up (and 6 Ways to Catch It) featured illustration

20 Mar 2025 · LLMs · 2 min read

Why AI Chatbots Make Things Up (and 6 Ways to Catch It)

LLM "hallucinations" explained simply: why a next-token predictor can sound confident and still be wrong, and six practical habits to catch fabricated facts, formulas…

Read article →
20 March 2025 by Atul Vij LLMs

Run an LLM on Your Own Laptop with Ollama (Private, Free, Offline)

Run an LLM on Your Own Laptop with Ollama (Private, Free, Offline) featured illustration

19 Mar 2025 · LLMs · 2 min read

Run an LLM on Your Own Laptop with Ollama (Private, Free, Offline)

Install Ollama, run open models like Llama and Qwen locally, call them from Python and Excel-friendly scripts, and create a custom model with a…

Read article →
19 March 2025 by Atul Vij LLMs

AutoHotkey String Manipulation and Text Processing

AutoHotkey String Manipulation and Text Processing featured illustration

19 Mar 2025 · AutoHotkey · 3 min read

AutoHotkey String Manipulation and Text Processing

Combine everything into one always-on script: text snippets, app launchers, Excel helpers, clipboard cleaners, a tray menu and start-with-Windows setup.

Read article →
19 March 2025 by Atul Vij AutoHotkey

10 Useful AutoHotkey Scripts for Office Work (Copy and Use)

10 Useful AutoHotkey Scripts for Office Work (Copy and Use) featured illustration

14 Mar 2025 · AutoHotkey · 2 min read

10 Useful AutoHotkey Scripts for Office Work (Copy and Use)

Ten ready-to-use AutoHotkey v2 scripts: text expansion for emails and GSTINs, today’s date, always-on-top windows, clipboard cleanup, Excel shortcuts, window snapping and more —…

Read article →
14 March 2025 by Atul Vij AutoHotkey

LoRA Fine-Tuning Explained: Teach an LLM New Tricks on One GPU

LoRA Fine-Tuning Explained: Teach an LLM New Tricks on One GPU featured illustration

7 Mar 2025 · Build Your Own LLM · 3 min read

LoRA Fine-Tuning Explained: Teach an LLM New Tricks on One GPU

How LoRA fine-tuning works, why it trains less than 1% of a model’s parameters, when fine-tuning beats prompting or RAG, and a minimal Hugging…

Read article →
7 March 2025 by Atul Vij Build Your Own LLM, LLMs

Build a RAG Chatbot That Answers From Your Own PDFs and Excel Files (Complete Guide)

Build a RAG Chatbot That Answers From Your Own PDFs and Excel Files (Complete Guide) featured illustration

4 Mar 2025 · AI Agents & RAG · 6 min read

Build a RAG Chatbot That Answers From Your Own PDFs and Excel Files (Complete Guide)

Step-by-step guide to retrieval-augmented generation in Python: load PDFs and Excel sheets, chunk them, create embeddings, search by meaning, and answer with a local…

Read article →
4 March 2025 by Atul Vij AI Agents & RAG

REGEXTEST Function in Excel: Does Text Match a Pattern?

REGEXTEST Function in Excel: Does Text Match a Pattern? featured illustration

2 Mar 2025 · Excel Functions A–Z · 1 min read

REGEXTEST Function in Excel: Does Text Match a Pattern?

REGEXTEST returns TRUE if text matches a regular expression — validate PAN numbers, emails or codes in one formula.

Read article →
2 March 2025 by Atul Vij Excel Functions A–Z, Text

DETECTLANGUAGE Function in Excel: Which Language Is This?

DETECTLANGUAGE Function in Excel: Which Language Is This? featured illustration

18 Feb 2025 · Excel Functions A–Z · 1 min read

DETECTLANGUAGE Function in Excel: Which Language Is This?

DETECTLANGUAGE returns the language code of a text — useful for sorting customer feedback before translating it.

Read article →
18 February 2025 by Atul Vij Excel Functions A–Z, Web, AI & Add-ins

Post navigation

← Older posts
Newer posts →
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
© 2026 Atul Vij · AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? →