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

Java Lesson 5: Classes and Objects

Java Lesson 5: Classes and Objects featured illustration

3 Feb 2019 · Java · 1 min read

Java Lesson 5: Classes and Objects

Model real things with classes: fields, constructors, methods, private data with public methods, and records for simple data.

Read article →
3 February 2019 by Atul Vij Java

Java Lesson 4: Methods

Java Lesson 4: Methods featured illustration

2 Feb 2019 · Java · 1 min read

Java Lesson 4: Methods

Write static methods with parameters and return types, overloading, and keeping methods small and testable.

Read article →
2 February 2019 by Atul Vij Java

Java Lesson 3: Conditions and Loops

Java Lesson 3: Conditions and Loops featured illustration

1 Feb 2019 · Java · 1 min read

Java Lesson 3: Conditions and Loops

Use if/else, switch expressions, comparison and logical operators, for, enhanced for and while loops in Java.

Read article →
1 February 2019 by Atul Vij Java

Java Lesson 2: Variables and Types

Java Lesson 2: Variables and Types featured illustration

31 Jan 2019 · Java · 1 min read

Java Lesson 2: Variables and Types

Java’s static types: int, double, boolean, char and String, declaring variables, var, arithmetic and integer division, casting and printf formatting.

Read article →
31 January 2019 by Atul Vij Java

Java Lesson 1: Install the JDK and Run Hello World

Java Lesson 1: Install the JDK and Run Hello World featured illustration

30 Jan 2019 · Java · 1 min read

Java Lesson 1: Install the JDK and Run Hello World

Install a JDK (Temurin or Oracle), check java -version, write and run Hello.java from the terminal and in VS Code or IntelliJ IDEA.

Read article →
30 January 2019 by Atul Vij Java

QUARTILE Function in Excel: Quartiles (Older Name)

QUARTILE Function in Excel: Quartiles (Older Name) featured illustration

25 Jan 2019 · Excel Functions A–Z · 1 min read

QUARTILE Function in Excel: Quartiles (Older Name)

QUARTILE returns the quartile of a data set. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…

Read article →
25 January 2019 by Atul Vij Excel Functions A–Z, Statistical

VBA Dictionary: Fast Lookups and Unique Lists in Your Macros

VBA Dictionary: Fast Lookups and Unique Lists in Your Macros featured illustration

22 Jan 2019 · Excel VBA · 2 min read

VBA Dictionary: Fast Lookups and Unique Lists in Your Macros

Use the Scripting.Dictionary in Excel VBA: create one, add and update keys, count and total by key, get unique lists, compare text case-insensitively, early…

Read article →
22 January 2019 by Atul Vij Excel VBA

QUARTILE.INC Function in Excel: Split Data Into Quarters

QUARTILE.INC Function in Excel: Split Data Into Quarters featured illustration

15 Jan 2019 · Excel Functions A–Z · 1 min read

QUARTILE.INC Function in Excel: Split Data Into Quarters

QUARTILE.INC returns the minimum, the 25th, 50th or 75th percentile, or the maximum. It is the fastest way to see whether a salary band…

Read article →
15 January 2019 by Atul Vij Excel Functions A–Z, Statistical

Power BI Lesson 10: Publish, Refresh and Share (Project)

Power BI Lesson 10: Publish, Refresh and Share (Project) featured illustration

14 Jan 2019 · Power BI & DAX · 2 min read

Power BI Lesson 10: Publish, Refresh and Share (Project)

Finish and share the course project: build a one-page sales dashboard, publish to the Power BI service, schedule refresh with a gateway, share via…

Read article →
14 January 2019 by Atul Vij Power BI & DAX

Power BI Lesson 9: Slicers, Drill-Down, Tooltips and Bookmarks

Power BI Lesson 9: Slicers, Drill-Down, Tooltips and Bookmarks featured illustration

13 Jan 2019 · Power BI & DAX · 2 min read

Power BI Lesson 9: Slicers, Drill-Down, Tooltips and Bookmarks

Make reports interactive: slicers and sync across pages, cross-filtering and edit interactions, drill-down hierarchies, drill-through detail pages, report-page tooltips and bookmarks for saved views.

Read article →
13 January 2019 by Atul Vij Power BI & DAX

Power BI Lesson 8: Visuals That Communicate

Power BI Lesson 8: Visuals That Communicate featured illustration

12 Jan 2019 · Power BI & DAX · 2 min read

Power BI Lesson 8: Visuals That Communicate

Choose and format Power BI visuals: cards and KPIs, bar vs column vs line, tables and matrices, maps, conditional formatting, consistent themes and page…

Read article →
12 January 2019 by Atul Vij Power BI & DAX

Power BI Lesson 5: Your First DAX — SUM, COUNTROWS, DIVIDE

Power BI Lesson 5: Your First DAX — SUM, COUNTROWS, DIVIDE featured illustration

9 Jan 2019 · Power BI & DAX · 2 min read

Power BI Lesson 5: Your First DAX — SUM, COUNTROWS, DIVIDE

Write the core measures every report needs: total sales with SUMX, cost and margin, order counts with COUNTROWS, distinct counts, averages, and safe ratios…

Read article →
9 January 2019 by Atul Vij Power BI & DAX

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