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: AI & ML

Artificial intelligence explained by building it: machine learning, neural networks, LLMs, RAG and agents — plus how to build your own language model.

7 Prompt Patterns That Get Better Answers from ChatGPT and Claude

11 Apr 2023 · Prompt Engineering · 2 min read

7 Prompt Patterns That Get Better Answers from ChatGPT and Claude

Seven practical prompt patterns — context, examples, format, steps, constraints, delimiters and questions first — with before-and-after prompts you can reuse.

Read article →
11 April 2023 by Atul Vij Prompt Engineering

A Neural Network From Scratch in 30 Lines of NumPy

11 May 2021 · Deep Learning · 3 min read

A Neural Network From Scratch in 30 Lines of NumPy

Build and train a two-layer neural network in plain NumPy to solve XOR — forward pass, backpropagation and gradient descent explained line by line.

Read article →
11 May 2021 by Atul Vij Deep Learning

Group Customers Automatically with K-Means in Python (From an Excel File)

17 Jun 2020 · Machine Learning · 2 min read

Group Customers Automatically with K-Means in Python (From an Excel File)

Use k-means clustering to split customers into segments by orders, spend and recency — reading from and writing back to Excel with pandas and…

Read article →
17 June 2020 by Atul Vij Machine Learning

Decision Trees in Python: A Model You Can Actually Read

18 Feb 2020 · Machine Learning · 2 min read

Decision Trees in Python: A Model You Can Actually Read

Train a decision tree classifier with scikit-learn, print its rules as plain if/else text, measure accuracy honestly with a test split, and avoid overfitting…

Read article →
18 February 2020 by Atul Vij Machine Learning

Linear Regression From Scratch in Python: How a Model Actually Learns

5 Nov 2019 · Machine Learning · 3 min read

Linear Regression From Scratch in Python: How a Model Actually Learns

Code linear regression with gradient descent in plain NumPy, watch the model learn slope and intercept, then check it against NumPy and scikit-learn. The…

Read article →
5 November 2019 by Atul Vij Machine Learning

Linear Regression in Excel with LINEST, SLOPE and FORECAST — No Add-ins

21 Aug 2019 · Machine Learning · 2 min read

Linear Regression in Excel with LINEST, SLOPE and FORECAST — No Add-ins

Machine learning starts with a straight line. Fit a regression in Excel with SLOPE, INTERCEPT, RSQ, LINEST and FORECAST.LINEAR, and learn how to read…

Read article →
21 August 2019 by Atul Vij Machine Learning

AI vs Machine Learning vs Deep Learning vs LLM: The Difference in 5 Minutes

12 Mar 2019 · Machine Learning · 2 min read

AI vs Machine Learning vs Deep Learning vs LLM: The Difference in 5 Minutes

AI, machine learning, deep learning and LLMs are nested ideas, not rivals. A short, jargon-free explanation with everyday examples of each.

Read article →
12 March 2019 by Atul Vij Machine Learning

Using AI to Write Excel Formulas — and How to Check Its Work

Using AI to Write Excel Formulas — and How to Check Its Work

4 May 2018 · AI Tools · 2 min read

Using AI to Write Excel Formulas — and How to Check Its Work

AI assistants can draft Excel formulas and VBA in seconds, but they also make confident mistakes. How to prompt them well and a 5-step…

Read article →
4 May 2018 by Atul Vij AI Tools, Excel Formulas

Post navigation

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