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

WEEKNUM Function in Excel: Week Number of the Year

WEEKNUM Function in Excel: Week Number of the Year featured illustration

20 Apr 2019 · Date & Time · 1 min read

WEEKNUM Function in Excel: Week Number of the Year

WEEKNUM returns the week of the year. ISOWEEKNUM follows the ISO standard (weeks start Monday, week 1 contains the first Thursday).

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

TEXT Function in Excel: Format Numbers and Dates as Text

TEXT Function in Excel: Format Numbers and Dates as Text featured illustration

13 Apr 2019 · Excel Functions A–Z · 1 min read

TEXT Function in Excel: Format Numbers and Dates as Text

TEXT converts a number or date into text using a format code — needed when you join values into labels.

Read article →
13 April 2019 by Atul Vij Excel Functions A–Z, Text

FISHERINV Function in Excel: Back From Fisher’s z to a Correlation

FISHERINV Function in Excel: Back From Fisher’s z to a Correlation featured illustration

11 Apr 2019 · Excel Functions A–Z · 1 min read

FISHERINV Function in Excel: Back From Fisher’s z to a Correlation

StatisticsLevel: ExpertAvailable in: Excel 2007+FISHERINV reverses FISHER, turning z back into a correlation.Syntax=FISHERINV(y)ArgumentWhat it.

Read article →
11 April 2019 by Atul Vij Excel Functions A–Z, Statistical

CONCAT Function in Excel: Join Text From Cells and Ranges

CONCAT Function in Excel: Join Text From Cells and Ranges featured illustration

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

CONCAT Function in Excel: Join Text From Cells and Ranges

CONCAT joins text from several cells or whole ranges. It replaces the older CONCATENATE. The & operator does the same for a few cells.

Read article →
9 April 2019 by Atul Vij Excel Functions A–Z, Text

FISHER Function in Excel: Fisher Transformation of a Correlation

FISHER Function in Excel: Fisher Transformation of a Correlation featured illustration

24 Mar 2019 · Excel Functions A–Z · 1 min read

FISHER Function in Excel: Fisher Transformation of a Correlation

FISHER transforms a correlation coefficient so it is roughly normal, which lets you build confidence intervals and compare correlations.

Read article →
24 March 2019 by Atul Vij Excel Functions A–Z, Statistical

VARA Function in Excel: Sample Variance Counting Text and TRUE/FALSE

VARA Function in Excel: Sample Variance Counting Text and TRUE/FALSE featured illustration

26 Feb 2019 · Excel Functions A–Z · 1 min read

VARA Function in Excel: Sample Variance Counting Text and TRUE/FALSE

StatisticsLevel: IntermediateAvailable in: Excel 2007+VARA is VAR.S that counts text as 0 and TRUE as 1.Syntax=VARA(value1, [value2], ...)ArgumentWhat it.

Read article →
26 February 2019 by Atul Vij Excel Functions A–Z, Statistical

STDEVP Function in Excel: Population Standard Deviation (Older Name)

STDEVP Function in Excel: Population Standard Deviation (Older Name) featured illustration

22 Feb 2019 · Excel Functions A–Z · 1 min read

STDEVP Function in Excel: Population Standard Deviation (Older Name)

STDEVP gives the standard deviation of a whole population. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier…

Read article →
22 February 2019 by Atul Vij Excel Functions A–Z, Statistical

Depreciation in Excel: SLM, WDV and Income-Tax Block Method

Depreciation in Excel: SLM, WDV and Income-Tax Block Method featured illustration

19 Feb 2019 · Excel for Finance · 3 min read

Depreciation in Excel: SLM, WDV and Income-Tax Block Method

Calculate depreciation in Excel with SLN, DB and custom formulas: straight-line (Companies Act), written-down value, the 180-day half-rate rule, and a complete fixed-asset schedule.

Read article →
19 February 2019 by Atul Vij Excel for Finance

VAR.S Function in Excel: Variance of a Sample

VAR.S Function in Excel: Variance of a Sample featured illustration

12 Feb 2019 · Excel Functions A–Z · 1 min read

VAR.S Function in Excel: Variance of a Sample

VAR.S is the square of STDEV.S. You rarely report it directly, but it turns up in forecasting, portfolio risk and quality-control formulas.

Read article →
12 February 2019 by Atul Vij Excel Functions A–Z, Statistical

Java Lesson 8: Project — An Invoice Calculator

Java Lesson 8: Project — An Invoice Calculator featured illustration

6 Feb 2019 · Java · 1 min read

Java Lesson 8: Project — An Invoice Calculator

Bring it together: an Invoice class with validated lines, GST calculation, item summaries with a Map and formatted output, plus next steps (Maven, Apache…

Read article →
6 February 2019 by Atul Vij Java

Java Lesson 7: Exceptions and Files

Java Lesson 7: Exceptions and Files featured illustration

5 Feb 2019 · Java · 1 min read

Java Lesson 7: Exceptions and Files

Handle errors with try/catch/finally, throw meaningful exceptions, and read and write text files with java.nio.file.Files.

Read article →
5 February 2019 by Atul Vij Java

STDEV.P Function in Excel: Standard Deviation of a Whole Population

STDEV.P Function in Excel: Standard Deviation of a Whole Population featured illustration

5 Feb 2019 · Excel Functions A–Z · 1 min read

STDEV.P Function in Excel: Standard Deviation of a Whole Population

STDEV.P measures spread when your data is the entire group, not a sample. The P version divides by n instead of n−1, so it…

Read article →
5 February 2019 by Atul Vij Excel Functions A–Z, Statistical

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