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

Why Is the Sea Salty but Rivers Are Fresh?

Why Is the Sea Salty but Rivers Are Fresh? featured illustration

27 Dec 2025 · Science · 2 min read

Why Is the Sea Salty but Rivers Are Fresh?

Rain slowly dissolves minerals from rocks, rivers carry them to the sea, and evaporation leaves the salt behind — for hundreds of millions of…

Read article →
27 December 2025 by Atul Vij Science Leave a comment

Python: Rename Hundreds of Files From an Excel List

Python: Rename Hundreds of Files From an Excel List featured illustration

9 Dec 2025 · Python Automation · 2 min read

Python: Rename Hundreds of Files From an Excel List

Rename scanned invoices, photos or reports in bulk using an Excel sheet of old and new names — with a dry run, a log,…

Read article →
9 December 2025 by Atul Vij Python Automation

The Complete Guide to Excel Lookups: VLOOKUP, XLOOKUP, INDEX-MATCH and Beyond

The Complete Guide to Excel Lookups: VLOOKUP, XLOOKUP, INDEX-MATCH and Beyond

9 Dec 2025 · Excel Formulas · 6 min read

The Complete Guide to Excel Lookups: VLOOKUP, XLOOKUP, INDEX-MATCH and Beyond

Everything about looking up data in Excel in one place: exact and approximate matches, left lookups, two-way lookups, multiple criteria, last match, returning all…

Read article →
9 December 2025 by Atul Vij Excel Formulas Leave a comment

Build Your Own LLM, Lesson 12: Quantize and Run Your Model Locally

Build Your Own LLM, Lesson 12: Quantize and Run Your Model Locally featured illustration

8 Dec 2025 · Build Your Own LLM · 2 min read

Build Your Own LLM, Lesson 12: Quantize and Run Your Model Locally

Shrink models with quantization: fp32 to int8 with PyTorch dynamic quantization, size and speed trade-offs, GGUF and 4-bit formats, and running open models locally…

Read article →
8 December 2025 by Atul Vij Build Your Own LLM Leave a comment

Build Your Own LLM, Lesson 11: Instruction Tuning and Chat Templates

Build Your Own LLM, Lesson 11: Instruction Tuning and Chat Templates featured illustration

7 Dec 2025 · Build Your Own LLM · 2 min read

Build Your Own LLM, Lesson 11: Instruction Tuning and Chat Templates

Turn a text predictor into an assistant: instruction-response data, chat templates with role tokens, masking the loss on prompts, and why each model needs…

Read article →
7 December 2025 by Atul Vij Build Your Own LLM Leave a comment

Build Your Own LLM, Lesson 10: Fine-Tuning a Pre-Trained Model With LoRA

Build Your Own LLM, Lesson 10: Fine-Tuning a Pre-Trained Model With LoRA featured illustration

6 Dec 2025 · Build Your Own LLM · 2 min read

Build Your Own LLM, Lesson 10: Fine-Tuning a Pre-Trained Model With LoRA

Fine-tune efficiently with LoRA: freeze the base model, add low-rank adapter matrices to attention layers, train under 2% of the parameters, and how the…

Read article →
6 December 2025 by Atul Vij Build Your Own LLM Leave a comment

Build Your Own LLM, Lesson 9: Evaluating a Model — Loss, Perplexity and Test Prompts

Build Your Own LLM, Lesson 9: Evaluating a Model — Loss, Perplexity and Test Prompts featured illustration

5 Dec 2025 · Build Your Own LLM · 2 min read

Build Your Own LLM, Lesson 9: Evaluating a Model — Loss, Perplexity and Test Prompts

Measure a language model: cross-entropy loss, perplexity and what it means, validation sets, fixed test prompts, and why benchmarks and human checks are both…

Read article →
5 December 2025 by Atul Vij Build Your Own LLM Leave a comment

Build Your Own LLM, Lesson 8: Sampling — Temperature, Top-k and Top-p

Build Your Own LLM, Lesson 8: Sampling — Temperature, Top-k and Top-p featured illustration

4 Dec 2025 · Build Your Own LLM · 2 min read

Build Your Own LLM, Lesson 8: Sampling — Temperature, Top-k and Top-p

How a language model picks the next token: greedy decoding, temperature, top-k and nucleus (top-p) sampling, implemented in a dozen lines and compared side…

Read article →
4 December 2025 by Atul Vij Build Your Own LLM Leave a comment

Public Wi-Fi Safety: What Is Actually Risky (and What Isn’t)

Public Wi-Fi Safety: What Is Actually Risky (and What Isn’t) featured illustration

3 Dec 2025 · Security & Privacy · 2 min read

Public Wi-Fi Safety: What Is Actually Risky (and What Isn’t)

Airport, café and hotel Wi-Fi explained honestly: why HTTPS protects most browsing, the real risks (fake hotspots, login-page phishing, file sharing) and simple habits…

Read article →
3 December 2025 by Atul Vij Security & Privacy Leave a comment

Build Your Own LLM, Lesson 7: Train a Tiny GPT on Your Own Text

Build Your Own LLM, Lesson 7: Train a Tiny GPT on Your Own Text featured illustration

3 Dec 2025 · Build Your Own LLM · 2 min read

Build Your Own LLM, Lesson 7: Train a Tiny GPT on Your Own Text

Stack transformer blocks into a GPT, add token and position embeddings, train it on a text file with AdamW on a laptop CPU, watch…

Read article →
3 December 2025 by Atul Vij Build Your Own LLM Leave a comment

Build Your Own LLM, Lesson 6: Multi-Head Attention and the Transformer Block

Build Your Own LLM, Lesson 6: Multi-Head Attention and the Transformer Block featured illustration

2 Dec 2025 · Build Your Own LLM · 2 min read

Build Your Own LLM, Lesson 6: Multi-Head Attention and the Transformer Block

Extend single-head self-attention to multi-head attention, add the feed-forward network, layer norm and residual connections, and test the causal mask — the full transformer…

Read article →
2 December 2025 by Atul Vij Build Your Own LLM Leave a comment

Build Your Own LLM, Lesson 5: Self-Attention From Scratch

Build Your Own LLM, Lesson 5: Self-Attention From Scratch featured illustration

1 Dec 2025 · Build Your Own LLM · 4 min read

Build Your Own LLM, Lesson 5: Self-Attention From Scratch

Understand and code the attention mechanism behind transformers: queries, keys, values, the causal mask and softmax — first with NumPy on four tokens, then…

Read article →
1 December 2025 by Atul Vij Build Your Own LLM Leave a comment

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? →