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
SIGN Function in Excel: Positive, Negative or Zero?

26 Jun 2018 · Excel Functions A–Z · 1 min read

SIGN Function in Excel: Positive, Negative or Zero?

SIGN returns 1 for positive, −1 for negative and 0 for zero — neat for direction arrows and counting gains vs losses.

Read article →
ISEVEN Function in Excel: Is the Number Even?

19 Jun 2018 · Excel Functions A–Z · 1 min read

ISEVEN Function in Excel: Is the Number Even?

ISEVEN returns TRUE for even numbers; ISODD for odd ones. Decimals are truncated first.

Read article →
XOR Function in Excel: Exactly One Condition True

5 Jun 2018 · Excel Functions A–Z · 1 min read

XOR Function in Excel: Exactly One Condition True

XOR returns TRUE when an odd number of conditions are TRUE — with two conditions, “one or the other but not both”.

Read article →
FORMULATEXT Function in Excel: Show a Formula as Text

8 May 2018 · Excel Functions A–Z · 1 min read

FORMULATEXT Function in Excel: Show a Formula as Text

FORMULATEXT displays the formula of another cell — perfect for documenting models and training sheets.

Read article →
Read and Write Excel Files in Java with Apache POI

21 Apr 2018 · Java · 2 min read

Read and Write Excel Files in Java with Apache POI

A beginner-friendly guide to reading and writing .xlsx files in Java using Apache POI — with complete, working examples and common pitfalls.

Read article →
EFFECT Function in Excel: Real Annual Rate With Compounding

7 Apr 2018 · Excel Functions A–Z · 1 min read

EFFECT Function in Excel: Real Annual Rate With Compounding

EFFECT converts a nominal annual rate into the effective rate after compounding. NOMINAL does the reverse.

Read article →
RATE Function in Excel: The Interest Rate Hidden in a Loan

20 Mar 2018 · Excel Functions A–Z · 1 min read

RATE Function in Excel: The Interest Rate Hidden in a Loan

RATE works out the interest rate from the loan amount, EMI and term — useful for checking “0% EMI” and flat-rate offers.

Read article →
Notepad++ Tricks for Cleaning Data Before Excel

18 Mar 2018 · Work Smarter · 2 min read

Notepad++ Tricks for Cleaning Data Before Excel

Column mode editing, regex find and replace, removing blank lines and comparing files — Notepad++ tricks that clean messy exports before they reach Excel.

Read article →
Regex for Office Users: Find and Replace Like a Pro

13 Mar 2018 · Dev Tools · 3 min read

Regex for Office Users: Find and Replace Like a Pro

Learn regex step by step with ten practical patterns — emails, phone numbers, PAN, dates, invoice numbers — usable in Notepad++, VBA, Python, SQL and Excel 365.

Read article →
Back Up Your Phone Photos Properly (the 3-2-1 Way)

7 Mar 2018 · Phone · 2 min read

Back Up Your Phone Photos Properly (the 3-2-1 Way)

A simple, reliable way to protect years of phone photos: cloud backup, a local copy and a second place — the 3-2-1 rule explained for normal people.

Read article →
R Lesson 6: Project — A Sales Analysis Report

20 Feb 2018 · R · 1 min read

R Lesson 6: Project — A Sales Analysis Report

Combine reading, dplyr and ggplot2 into a repeatable analysis: KPIs, product summary, charts and output files, plus a pointer to R Markdown/Quarto reports.

Read article →
R Lesson 3: Reading CSV and Excel

17 Feb 2018 · R · 1 min read

R Lesson 3: Reading CSV and Excel

Load data into R with readr::read_csv and readxl::read_excel, check columns and types, handle dates and missing values, and write results back out.

Read article →
Older posts
Newer posts
← Previous Page1 … Page96 Page97 Page98 … 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? →