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
TEXTSPLIT, TEXTBEFORE and TEXTAFTER: Splitting Text Without the Headache

17 Jan 2023 · Excel Formulas · 2 min read

TEXTSPLIT, TEXTBEFORE and TEXTAFTER: Splitting Text Without the Headache

Split codes, names, addresses and emails in Excel 365 with TEXTSPLIT, TEXTBEFORE and TEXTAFTER: delimiters, instance numbers, multiple delimiters, rows vs columns, missing values and older-Excel alternatives.

Read article →
FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe)

12 Jan 2023 · Excel Functions A–Z · 1 min read

FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe)

FLOOR.PRECISE rounds down to a multiple regardless of signs; negatives round away from zero.

Read article →
REPLACEB Function in Excel: Replace by Bytes

8 Jan 2023 · Excel Functions A–Z · 1 min read

REPLACEB Function in Excel: Replace by Bytes

TextLevel: ExpertAvailable in: Excel 2007+REPLACEB is the byte-based version of REPLACE.Syntax=REPLACEB(text,1,2,"**")ArgumentWhat it meanstextText to.

Read article →
How to Spot a Phishing Email in 30 Seconds (7 Checks)

5 Jan 2023 · Security & Privacy · 1 min read

How to Spot a Phishing Email in 30 Seconds (7 Checks)

Seven quick checks — sender domain, link preview, urgency, attachments, requests for OTP — to recognise phishing emails and messages at work and at home.

Read article →
Passwords, Passkeys and 2FA: A Practical Setup for Normal People

26 Dec 2022 · Security & Privacy · 2 min read

Passwords, Passkeys and 2FA: A Practical Setup for Normal People

A simple, realistic plan to protect your email, bank and work accounts: a password manager, passkeys where available, and the right kind of two-factor authentication.

Read article →
ROWS Function in Excel: How Many Rows in a Range

21 Dec 2022 · Excel Functions A–Z · 1 min read

ROWS Function in Excel: How Many Rows in a Range

ROWS counts the rows in a range or array — the classic helper for top-N lists that fill down.

Read article →
Count Unique Values With Criteria in Excel (365 and Older Versions)

13 Nov 2022 · Formula Combos · 2 min read

Count Unique Values With Criteria in Excel (365 and Older Versions)

How many different customers bought in North? How many distinct products did Asha sell? Count unique values with UNIQUE+FILTER, SUMPRODUCT+COUNTIFS for older Excel, and pivot tables — with the blank-cell traps.

Read article →
LOGINV Function in Excel: Inverse Lognormal (Older Name)

11 Nov 2022 · Excel Functions A–Z · 1 min read

LOGINV Function in Excel: Inverse Lognormal (Older Name)

LOGINV returns the value at a lognormal probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends LOGNORM.INV for new work. Both give the same result.

Read article →
Python for Office Automation: The Complete Starter Guide

15 Oct 2022 · Python · 3 min read

Python for Office Automation: The Complete Starter Guide

Use Python to automate everyday office work: set up Python, handle files and folders, read and write Excel, create Word reports, send emails safely, and schedule scripts — with complete examples.

Read article →
Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English

7 Oct 2022 · Excel Formulas · 2 min read

Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English

Understand Excel 365 dynamic arrays: spilling results, the # spill reference, FILTER with AND/OR, SORT and SORTBY, UNIQUE counts, SEQUENCE, LET, and fixing #SPILL! errors.

Read article →
Conditional Formatting with Formulas: 10 Rules Worth Knowing

29 Aug 2022 · Excel Formulas · 2 min read

Conditional Formatting with Formulas: 10 Rules Worth Knowing

Ten formula-based conditional formatting rules for real reports: highlight whole rows, overdue dates, duplicates, top N, weekends, missing values and differences between lists.

Read article →
Power Automate Intermediate Lesson 8: Project – Invoice Processing From Email

19 Aug 2022 · Power Automate · 1 min read

Power Automate Intermediate Lesson 8: Project – Invoice Processing From Email

Final project: save invoice attachments from email to dated OneDrive folders, log them in Excel, route big invoices for approval and alert on failures.

Read article →
Older posts
Newer posts
← Previous Page1 … Page67 Page68 Page69 … 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? →