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
Basics of VBA / Macros Chapter – 46 (Time and Date Part-3)

12 Jan 2017 · Excel VBA · 1 min read

Basics of VBA / Macros Chapter – 46 (Time and Date Part-3)

The DateDiff function in VBA can be used to get the number of days between two dates. Place a command button on your worksheet…

Read article →
Basics of VBA / Macros Chapter – 45 (Time and Date Part-2)

10 Jan 2017 · Excel VBA · 3 min read

Basics of VBA / Macros Chapter – 45 (Time and Date Part-2)

How to compare dates and times in VBA. Dates and times are stored as numbers in Excel and count the number of days since…

Read article →
Basics of VBA / Macros Chapter – 29 (Loop Part-6)

9 Jan 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 29 (Loop Part-6)

 Below we will look at a program in Excel VBA that creates a pattern. Situation: Place a command button on your worksheet and add…

Read article →
Basics of VBA / Macros Chapter – 44 (Time and Date Part-1)

7 Jan 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 44 (Time and Date Part-1)

Learn how to work with dates and times in VBA. Place a command button on your worksheet and add the code lines below. To execute…

Read article →
📊Basics of VBA / Macros Chapter – 42 (String Manipulation Part-4)Excel VBA

2 Jan 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 42 (String Manipulation Part-4)

Below we will look at a program in Excel VBA that converts text to proper case. That is, the first letter in each word…

Read article →
Basics of VBA / Macros Chapter – 28 (Loop Part-5)

1 Jan 2017 · Excel VBA · 2 min read

Basics of VBA / Macros Chapter – 28 (Loop Part-5)

You can use the Step keyword in VBA to specify a different increment for the counter variable of a loop. Place a command button on…

Read article →
MOD Function in Excel: Remainder After Division

15 Nov 2016 · Excel Functions A–Z · 2 min read

MOD Function in Excel: Remainder After Division

Calculate the remainder after dividing a number by a divisor, powering alternating row formatting, time calculations, and cyclic patterns.

Read article →
MROUND Function in Excel: Round to the Nearest Multiple

8 Nov 2016 · Excel Functions A–Z · 1 min read

MROUND Function in Excel: Round to the Nearest Multiple

MROUND rounds to the nearest multiple you choose — prices to ₹5, times to 15 minutes.

Read article →
Word Styles and an Automatic Table of Contents (Step by Step)

4 Oct 2016 · Word · 2 min read

Word Styles and an Automatic Table of Contents (Step by Step)

Use Word’s Heading styles to format long documents consistently, build an automatic table of contents, number headings and navigate with the Navigation Pane.

Read article →
SUMIF Function in Excel: Sum Values That Meet One Condition

12 Jul 2016 · Excel Functions A–Z · 2 min read

SUMIF Function in Excel: Sum Values That Meet One Condition

Calculate the total of numbers in a range that meet a specific condition, text match, date criteria, or logical comparison.

Read article →
Stop Crossing Oceans for People

3 Jul 2016 · Fun Facts · 1 min read

Stop Crossing Oceans for People

There comes a time when you have to stop crossing oceans for people who would not even jump puddles for you.

Read article →
Laughter is Panic Response to Tickling

18 Jun 2016 · Fun Facts · 4 min read

Laughter is Panic Response to Tickling

Most of us have a ticklish spot somewhere on our bodies, and it is usually pretty easy to find. Laughing when another person tickles you is a natural reaction linked to a panic response.

Read article →
Older posts
Newer posts
← Previous Page1 … Page104 Page105 Page106 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? →