Topics

  • AI Tools (2)
  • AutoHotkey (1)
  • Automation (3)
  • Build Your Own LLM (5)
  • Charts & Dashboards (2)
  • Deep Learning (1)
  • Essbase (3)
  • Excel Formulas (11)
  • Excel VBA (104)
  • Formula Combos (5)
  • Fun Facts (8)
  • Google Workspace (1)
  • History (3)
  • Internet & Browser (2)
  • Java (2)
  • JavaScript (2)
  • LLMs (4)
  • Machine Learning (5)
  • Office Scripts (1)
  • Oracle EPM Cloud (1)
  • Oracle Smart View (3)
  • Outlook (4)
  • Phone (2)
  • Power Automate (2)
  • Power Query & Pivots (3)
  • PowerPoint (3)
  • PowerShell (1)
  • Productivity (3)
  • Prompt Engineering (1)
  • Python (4)
  • Python Automation (2)
  • R (2)
  • RAG & Agents (2)
  • Rust (1)
  • SAP (6)
  • SAP GUI Scripting (3)
  • Science (3)
  • Security & Privacy (2)
  • SQL (3)
  • Tech Tips (1)
  • Windows (3)
  • Word (3)

Recent posts

  • Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
  • 5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
  • SAP SE16N and SQVI: Pull Table Data Without ABAP
  • Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
  • LET and LAMBDA: Write Your Own Excel Functions (No VBA)
  • Why Do We Have Leap Years? (And Why 1900 Was Not One)

AJ's Techie & Wacky World

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

Menu

Skip to content
  • Excel
    • Charts & Dashboards
    • Excel Formulas
    • Excel VBA
    • Formula Combos
    • Power Query & Pivots
    • Excel VBA Course
  • Office
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
  • AI & ML
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • RAG & Agents
    • Build Your Own LLM Course
  • SAP & Oracle
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
  • Automation
    • AutoHotkey
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • Tech Tips
    • Internet & Browser
    • Phone
    • Productivity
    • Security & Privacy
    • Windows
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • VBA Playground
    • Formula Lab
    • VBA Bug Hunt
    • Macro Recorder
    • SQL Playground
    • Date & Workday Calculator
    • Excel Shortcut Trainer
    • VBA Quiz
    • Formula Explainer
    • EMI & SIP Calculator
    • Regex Tester
    • CSV to SQL Converter
    • VBA Code Formatter
    • Office Shortcut Finder
  • About
  • Projects

Category Archives: Science

Weird and wonderful science explained.

Why Do We Have Leap Years? (And Why 1900 Was Not One)

Why Do We Have Leap Years? (And Why 1900 Was Not One)

29 Mar 2026 · History · 2 min read

Why Do We Have Leap Years? (And Why 1900 Was Not One)

A year is about 365.2422 days, not 365. How leap years fix the drift, why century years are usually skipped, and how this affects…

Read article →
29 March 2026 by Atul Vij History, Science Leave a comment

Why Is the Sky Blue (and Sunsets Red)? Explained in Two Minutes

Why Is the Sky Blue (and Sunsets Red)? Explained in Two Minutes

25 Oct 2025 · Science · 2 min read

Why Is the Sky Blue (and Sunsets Red)? Explained in Two Minutes

The sky is blue because air scatters short (blue) wavelengths of sunlight much more than long (red) ones — Rayleigh scattering. Why it is…

Read article →
25 October 2025 by Atul Vij Science Leave a comment

Why 0.1 + 0.2 Is Not Exactly 0.3 (and Why Excel Sometimes Agrees)

Why 0.1 + 0.2 Is Not Exactly 0.3 (and Why Excel Sometimes Agrees)

15 Mar 2024 · Excel Formulas · 2 min read

Why 0.1 + 0.2 Is Not Exactly 0.3 (and Why Excel Sometimes Agrees)

Computers store numbers in binary, so 0.1 cannot be stored exactly. Why that makes 0.1+0.2 ≠ 0.3, how it shows up in Excel, Python…

Read article →
15 March 2024 by Atul Vij Excel Formulas, Science
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
© 2026 Atul Vij · AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? →