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
Build Your Own LLM, Lesson 6: Multi-Head Attention and the Transformer Block

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 block in PyTorch.

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

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 as a PyTorch module.

Read article →
The Indian Mathematician Who Measured Everest: Radhanath Sikdar

22 Nov 2025 · History · 2 min read

The Indian Mathematician Who Measured Everest: Radhanath Sikdar

In 1852 Radhanath Sikdar, a mathematician with the Great Trigonometrical Survey, worked out that "Peak XV" was the highest mountain on Earth. The story of the calculation.

Read article →
Monthly Totals From Daily Data in Excel (SUMIFS + EOMONTH, Pivot and GROUPBY)

21 Nov 2025 · Formula Combos · 2 min read

Monthly Totals From Daily Data in Excel (SUMIFS + EOMONTH, Pivot and GROUPBY)

Turn a daily sales list into month-wise totals: SUMIFS with EOMONTH date bounds, a month-by-region grid, TEXT month keys, pivot grouping and the new GROUPBY — plus why "=MONTH()" alone mixes years.

Read article →
Excel LAMBDA Lesson 8: Package and Share Your Function Library

20 Nov 2025 · Excel · 2 min read

Excel LAMBDA Lesson 8: Package and Share Your Function Library

Collect your LAMBDA functions in one library workbook, copy them to other files, use the Advanced Formula Environment and keep versions under control.

Read article →
Excel LAMBDA Lesson 7: Optional Arguments and Error Handling

19 Nov 2025 · Excel · 1 min read

Excel LAMBDA Lesson 7: Optional Arguments and Error Handling

Make LAMBDA functions friendly: optional parameters with ISOMITTED, sensible defaults, SAFEDIV and clear messages for bad input.

Read article →
Excel LAMBDA Lesson 6: MAP, BYROW, BYCOL and MAKEARRAY

18 Nov 2025 · Excel · 1 min read

Excel LAMBDA Lesson 6: MAP, BYROW, BYCOL and MAKEARRAY

Apply your functions across whole ranges: MAP for every cell, BYROW and BYCOL for row and column totals, MAKEARRAY to generate grids.

Read article →
Excel LAMBDA Lesson 5: REDUCE and SCAN (Running Balances, Multi-Replace)

17 Nov 2025 · Excel · 2 min read

Excel LAMBDA Lesson 5: REDUCE and SCAN (Running Balances, Multi-Replace)

Use REDUCE to fold a list into one answer and SCAN to keep every step: running bank balances, compound growth and a MULTIREPLACE function.

Read article →
Build Your Own LLM, Lesson 4: Embeddings and Your First Neural Language Model

17 Nov 2025 · Build Your Own LLM · 4 min read

Build Your Own LLM, Lesson 4: Embeddings and Your First Neural Language Model

Rebuild the bigram model as a neural network in PyTorch, train it with gradient descent, and add embeddings — the vectors that let language models generalise.

Read article →
Rolling Totals in Excel: Last 7 Days, Last 30 Days and Moving Averages

16 Nov 2025 · Formula Combos · 2 min read

Rolling Totals in Excel: Last 7 Days, Last 30 Days and Moving Averages

Sum or count the last 7 or 30 days with SUMIFS and TODAY(), build a 7-day moving average, a trailing-12-month total, and a rolling sum in 365 with SCAN or OFFSET-free formulas.

Read article →
Excel LAMBDA Lesson 4: Financial-Year Date Functions

16 Nov 2025 · Excel · 1 min read

Excel LAMBDA Lesson 4: Financial-Year Date Functions

FYSTART, FYLABEL, FYQTR, DAYSLEFT and AGEYEARS as LAMBDA functions for the Indian April-March financial year.

Read article →
Excel LAMBDA Lesson 3: Text Cleaning Functions

15 Nov 2025 · Excel · 1 min read

Excel LAMBDA Lesson 3: Text Cleaning Functions

CLEANNAME, INITIALS, DIGITSONLY, WORDCOUNT and MASK: custom LAMBDA functions for messy names, phone numbers and sensitive data.

Read article →
Older posts
Newer posts
← Previous Page1 … Page38 Page39 Page40 … 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? →