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

Smart View Lesson 4: Member Selection and Aliases

Smart View Lesson 4: Member Selection and Aliases featured illustration

14 Jul 2019 · Oracle Smart View · 1 min read

Smart View Lesson 4: Member Selection and Aliases

Choose exactly the members you need with the Member Selection dialog: hierarchy browsing, search, filters by level and generation, aliases vs member names, and…

Read article →
14 July 2019 by Atul Vij Oracle Smart View

Smart View Lesson 3: Zoom, Pivot, Keep Only and POV

Smart View Lesson 3: Zoom, Pivot, Keep Only and POV featured illustration

13 Jul 2019 · Oracle Smart View · 1 min read

Smart View Lesson 3: Zoom, Pivot, Keep Only and POV

Navigate cube data with the core ad hoc actions: zoom in and out, pivot dimensions between rows and columns, keep only and remove only,…

Read article →
13 July 2019 by Atul Vij Oracle Smart View

ODD Function in Excel: Round Up to an Odd Number

ODD Function in Excel: Round Up to an Odd Number featured illustration

17 Jun 2019 · Excel Functions A–Z · 1 min read

ODD Function in Excel: Round Up to an Odd Number

ODD rounds away from zero to the next odd integer — for example committee sizes that must avoid tied votes.

Read article →
17 June 2019 by Atul Vij Excel Functions A–Z, Math & Trig

Python: Sort a Messy Downloads Folder by Year and Month

Python: Sort a Messy Downloads Folder by Year and Month featured illustration

11 Jun 2019 · Python Automation · 1 min read

Python: Sort a Messy Downloads Folder by Year and Month

A 25-line Python script that moves files into Year/Month folders based on their modified date, with a dry-run mode so you can check before…

Read article →
11 June 2019 by Atul Vij Python Automation

GCD Function in Excel: Greatest Common Divisor

GCD Function in Excel: Greatest Common Divisor featured illustration

9 Jun 2019 · Excel Functions A–Z · 1 min read

GCD Function in Excel: Greatest Common Divisor

GCD returns the largest number that divides all inputs — for simplifying ratios and finding pack sizes.

Read article →
9 June 2019 by Atul Vij Excel Functions A–Z, Math & Trig

EVEN Function in Excel: Round Up to an Even Number

EVEN Function in Excel: Round Up to an Even Number featured illustration

4 Jun 2019 · Excel Functions A–Z · 1 min read

EVEN Function in Excel: Round Up to an Even Number

EVEN rounds away from zero to the next even integer — handy when items come in pairs.

Read article →
4 June 2019 by Atul Vij Excel Functions A–Z, Math & Trig

DAYS Function in Excel: Days Between Two Dates

DAYS Function in Excel: Days Between Two Dates featured illustration

31 May 2019 · Date & Time · 1 min read

DAYS Function in Excel: Days Between Two Dates

DAYS returns the number of days between two dates. Subtracting the dates (=B2-A2) gives the same answer.

Read article →
31 May 2019 by Atul Vij Date & Time, Excel Functions A–Z

LCM Function in Excel: Least Common Multiple

LCM Function in Excel: Least Common Multiple featured illustration

28 May 2019 · Excel Functions A–Z · 1 min read

LCM Function in Excel: Least Common Multiple

LCM finds the smallest number all inputs divide into — when two repeating schedules line up again.

Read article →
28 May 2019 by Atul Vij Excel Functions A–Z, Math & Trig

YEARFRAC Function in Excel: Fraction of a Year Between Dates

YEARFRAC Function in Excel: Fraction of a Year Between Dates featured illustration

26 May 2019 · Date & Time · 1 min read

YEARFRAC Function in Excel: Fraction of a Year Between Dates

YEARFRAC returns the fraction of a year between two dates — for pro-rata interest, depreciation and exact age.

Read article →
26 May 2019 by Atul Vij Date & Time, Excel Functions A–Z

WORKDAY Function in Excel: A Date N Working Days Away

WORKDAY Function in Excel: A Date N Working Days Away featured illustration

24 May 2019 · Date & Time · 1 min read

WORKDAY Function in Excel: A Date N Working Days Away

WORKDAY returns the date that is a number of working days before or after a start date, skipping weekends and holidays.

Read article →
24 May 2019 by Atul Vij Date & Time, Excel Functions A–Z

NETWORKDAYS Function in Excel: Working Days Between Two Dates

NETWORKDAYS Function in Excel: Working Days Between Two Dates featured illustration

21 May 2019 · Date & Time · 1 min read

NETWORKDAYS Function in Excel: Working Days Between Two Dates

NETWORKDAYS counts Monday–Friday working days between two dates, optionally excluding a holiday list. NETWORKDAYS.INTL lets you choose the weekend.

Read article →
21 May 2019 by Atul Vij Date & Time, Excel Functions A–Z

FACT Function in Excel: Factorial

FACT Function in Excel: Factorial featured illustration

17 May 2019 · Excel Functions A–Z · 1 min read

FACT Function in Excel: Factorial

FACT returns n! (1 × 2 × … × n). It grows absurdly fast: FACT(20) is already about 2.4 quintillion.

Read article →
17 May 2019 by Atul Vij Excel Functions A–Z, Math & Trig

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