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

AVERAGEA Function in Excel: Average Counting Text as Zero

AVERAGEA Function in Excel: Average Counting Text as Zero featured illustration

27 Jul 2020 Β· Excel Functions A–Z Β· 1 min read

AVERAGEA Function in Excel: Average Counting Text as Zero

AVERAGEA treats text as 0 and TRUE as 1. Use it when β€œabsent” should drag the average down rather than be ignored.

Read article β†’
27 July 2020 by Atul Vij Excel Functions A–Z, Statistical

INFO Function in Excel: About Your Excel Environment

INFO Function in Excel: About Your Excel Environment featured illustration

22 Jul 2020 Β· Excel Functions A–Z Β· 1 min read

INFO Function in Excel: About Your Excel Environment

INFO returns details like the Excel version, operating system or current folder.

Read article β†’
22 July 2020 by Atul Vij Excel Functions A–Z, Information

SUMPRODUCT: The Excel Formula That Does (Almost) Everything

SUMPRODUCT: The Excel Formula That Does (Almost) Everything

20 Jul 2020 Β· Formula Combos Β· 1 min read

SUMPRODUCT: The Excel Formula That Does (Almost) Everything

SUMPRODUCT multiplies arrays and adds the result β€” which makes it a multi-condition counter, a weighted average, a case-sensitive lookup and more, in every…

Read article β†’
20 July 2020 by Atul Vij Formula Combos

SHEETS Function in Excel: How Many Sheets?

SHEETS Function in Excel: How Many Sheets? featured illustration

2 Jul 2020 Β· Excel Functions A–Z Β· 1 min read

SHEETS Function in Excel: How Many Sheets?

SHEETS counts sheets in a reference or the whole workbook β€” including hidden ones.

Read article β†’
2 July 2020 by Atul Vij Excel Functions A–Z, Information

SAP ERP Modules

SAP ERP Modules

28 Jun 2020 Β· SAP Β· 2 min read

SAP ERP Modules

SAP Modules can be categorized into Functional Modules and Technical Modules. Key modules include FI, CO, and many others for enterprise operations.

Read article β†’
28 June 2020 by Atul Vij SAP

What Is an API? A Plain-English Guide With a Real Example

What Is an API? A Plain-English Guide With a Real Example featured illustration

23 Jun 2020 Β· Dev Tools Β· 1 min read

What Is an API? A Plain-English Guide With a Real Example

APIs explained with a restaurant analogy, then a real example: fetch exchange rates with a URL, read the JSON, and pull it into Excel…

Read article β†’
23 June 2020 by Atul Vij Dev Tools

RTD Function in Excel: Real-Time Data From a COM Server

RTD Function in Excel: Real-Time Data From a COM Server featured illustration

18 Jun 2020 Β· Excel Functions A–Z Β· 1 min read

RTD Function in Excel: Real-Time Data From a COM Server

RTD pulls live values from a real-time data server, e.g. stock prices from a broker's trading terminal add-in. You need the provider's RTD server…

Read article β†’
18 June 2020 by Atul Vij Excel Functions A–Z, Lookup & Reference

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

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

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

REGISTER.ID Function in Excel: ID of a Registered DLL Function

REGISTER.ID Function in Excel: ID of a Registered DLL Function featured illustration

15 Jun 2020 Β· Excel Functions A–Z Β· 1 min read

REGISTER.ID Function in Excel: ID of a Registered DLL Function

REGISTER.ID returns the register ID of a DLL function for CALL. Same legacy, same security restrictions.

Read article β†’
15 June 2020 by Atul Vij Excel Functions A–Z, Web, AI & Add-ins

WEBSERVICE Function in Excel: Read Data From a URL

WEBSERVICE Function in Excel: Read Data From a URL featured illustration

2 Jun 2020 Β· Excel Functions A–Z Β· 1 min read

WEBSERVICE Function in Excel: Read Data From a URL

WEBSERVICE downloads text from a web address (Windows desktop only). Combined with FILTERXML or TEXTAFTER it can read simple APIs.

Read article β†’
2 June 2020 by Atul Vij Excel Functions A–Z, Web, AI & Add-ins

SWITCH Function in Excel: Match One Value Against a List

SWITCH Function in Excel: Match One Value Against a List featured illustration

17 May 2020 Β· Excel Functions A–Z Β· 1 min read

SWITCH Function in Excel: Match One Value Against a List

SWITCH compares one value with a list and returns the matching result β€” cleaner than nested IFs for exact matches.

Read article β†’
17 May 2020 by Atul Vij Excel Functions A–Z, Logical

R Lesson 4: dplyr β€” filter, mutate, summarise

R Lesson 4: dplyr β€” filter, mutate, summarise featured illustration

16 May 2020 Β· R Β· 1 min read

R Lesson 4: dplyr β€” filter, mutate, summarise

Analyse data with dplyr verbs: filter rows, mutate new columns, arrange, group_by and summarise β€” the R equivalent of filters, formulas and pivot tables.

Read article β†’
16 May 2020 by Atul Vij R

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? β†’