Skip to content

Popular topics

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

Recent posts

  • Basics of VBA / Macros Chapter – 81 (Userform Part-2)
  • 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

🤯 Wacky fact of the day · Human Body

You blink around 15–20 times a minute.

Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry…

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

Machine Learning Lesson 2: Preparing Data (Missing Values and Text Columns)

Machine Learning Lesson 2: Preparing Data (Missing Values and Text Columns) featured illustration

18 Feb 2021 · Machine Learning · 2 min read

Machine Learning Lesson 2: Preparing Data (Missing Values and Text Columns)

Models only accept complete, numeric tables. Find and fill missing values with the median and turn text columns like city into 0/1 columns with…

Read article →
18 February 2021 by Atul Vij Machine Learning

Machine Learning Lesson 1: What ML Is and Your First Model

Machine Learning Lesson 1: What ML Is and Your First Model featured illustration

17 Feb 2021 · Machine Learning · 3 min read

Machine Learning Lesson 1: What ML Is and Your First Model

What machine learning actually is, the words you need (features, target, training), installing scikit-learn, and a first model that predicts flat prices from area.

Read article →
17 February 2021 by Atul Vij Machine Learning

STOCKHISTORY Function in Excel: Historical Share Prices

STOCKHISTORY Function in Excel: Historical Share Prices featured illustration

9 Feb 2021 · Excel Functions A–Z · 1 min read

STOCKHISTORY Function in Excel: Historical Share Prices

STOCKHISTORY fetches daily, weekly or monthly prices for a stock or currency pair into a spill range.

Read article →
9 February 2021 by Atul Vij Excel Functions A–Z, Financial

Google Workspace Lesson 4: Google Forms Into Sheets

Google Workspace Lesson 4: Google Forms Into Sheets featured illustration

20 Jan 2021 · Google Workspace · 2 min read

Google Workspace Lesson 4: Google Forms Into Sheets

Collect data without retyping: build a Google Form with the right question types and validation, send responses to a Sheet, summarise them with formulas…

Read article →
20 January 2021 by Atul Vij Google Workspace

Google Workspace Lesson 6: Apps Script — Your First Automation

Google Workspace Lesson 6: Apps Script — Your First Automation featured illustration

19 Jan 2021 · Google Workspace · 3 min read

Google Workspace Lesson 6: Apps Script — Your First Automation

Write your first Google Apps Script: open the editor, read a sheet, total by region, email yourself a summary, add a custom menu, schedule…

Read article →
19 January 2021 by Atul Vij Google Workspace

Google Workspace Lesson 5: Sheets Formulas Excel Doesn’t Have

Google Workspace Lesson 5: Sheets Formulas Excel Doesn’t Have featured illustration

12 Jan 2021 · Google Workspace · 2 min read

Google Workspace Lesson 5: Sheets Formulas Excel Doesn’t Have

The Google Sheets functions that make it special: QUERY, ARRAYFORMULA, IMPORTRANGE, GOOGLETRANSLATE, SPARKLINE, SPLIT, IMAGE, GOOGLEFINANCE and checkboxes, with practical examples.

Read article →
12 January 2021 by Atul Vij Google Workspace

Compare Two Lists in Excel: Find Matches, Missing Items and Differences

Compare Two Lists in Excel: Find Matches, Missing Items and Differences featured illustration

9 Jan 2021 · Formula Combos · 2 min read

Compare Two Lists in Excel: Find Matches, Missing Items and Differences

Which customers are in this month’s list but not last month’s? Compare two lists with COUNTIF, MATCH/XMATCH, FILTER and conditional formatting — in old…

Read article →
9 January 2021 by Atul Vij Formula Combos

INDEX and MATCH Explained: The Lookup That Beats VLOOKUP

INDEX and MATCH Explained: The Lookup That Beats VLOOKUP featured illustration

4 Jan 2021 · Excel Formulas · 2 min read

INDEX and MATCH Explained: The Lookup That Beats VLOOKUP

Understand INDEX and MATCH separately, combine them for flexible lookups in any Excel version, look left, do two-way and multiple-criteria lookups, approximate matches, and…

Read article →
4 January 2021 by Atul Vij Excel Formulas

Weighted Average in Excel: SUMPRODUCT / SUM (Prices, Marks, Interest Rates)

Weighted Average in Excel: SUMPRODUCT / SUM (Prices, Marks, Interest Rates) featured illustration

28 Dec 2020 · Formula Combos · 2 min read

Weighted Average in Excel: SUMPRODUCT / SUM (Prices, Marks, Interest Rates)

Calculate weighted averages correctly — average price by quantity, weighted marks, blended interest rates — with SUMPRODUCT/SUM, weighted averages with conditions, and why plain…

Read article →
28 December 2020 by Atul Vij Formula Combos

VAR Function in Excel: Sample Variance (Older Name)

VAR Function in Excel: Sample Variance (Older Name) featured illustration

25 Dec 2020 · Excel Functions A–Z · 1 min read

VAR Function in Excel: Sample Variance (Older Name)

VAR estimates variance from a sample. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…

Read article →
25 December 2020 by Atul Vij Excel Functions A–Z, Statistical

Two-Way Lookup in Excel: INDEX + MATCH + MATCH (and the XLOOKUP Version)

Two-Way Lookup in Excel: INDEX + MATCH + MATCH (and the XLOOKUP Version) featured illustration

17 Dec 2020 · Formula Combos · 3 min read

Two-Way Lookup in Excel: INDEX + MATCH + MATCH (and the XLOOKUP Version)

Look up a value at the crossing of a row and a column — target for South in August, price for size L in…

Read article →
17 December 2020 by Atul Vij Formula Combos

Google Workspace Lesson 3: Drive — Folders, Sharing and Permissions

Google Workspace Lesson 3: Drive — Folders, Sharing and Permissions featured illustration

10 Dec 2020 · Google Workspace · 2 min read

Google Workspace Lesson 3: Drive — Folders, Sharing and Permissions

Organise Google Drive with shared drives and folders, share safely with Viewer/Commenter/Editor, avoid “anyone with the link” leaks, transfer ownership, use filter views, and…

Read article →
10 December 2020 by Atul Vij Google Workspace

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