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
NOW Function in Excel: Current Date and Time

24 Mar 2021 · Date & Time · 1 min read

NOW Function in Excel: Current Date and Time

NOW returns the current date and time and updates every time the sheet recalculates. For a timestamp that stays fixed, press Ctrl+; then Space then Ctrl+Shift+;.

Read article →
VARP Function in Excel: Population Variance (Older Name)

16 Mar 2021 · Excel Functions A–Z · 1 min read

VARP Function in Excel: Population Variance (Older Name)

VARP gives the variance of a whole population. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends VAR.P for new work. Both give the same result.

Read article →
Slow Wi-Fi at Home? 10 Fixes That Actually Work

16 Mar 2021 · Internet & Browser · 2 min read

Slow Wi-Fi at Home? 10 Fixes That Actually Work

Diagnose and fix slow home Wi-Fi: speed tests the right way, router placement, 2.4 GHz vs 5 GHz, channel congestion, DNS, restarting, firmware, mesh systems and when to call your ISP.

Read article →
VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE

13 Mar 2021 · Excel Functions A–Z · 1 min read

VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE

StatisticsLevel: IntermediateAvailable in: Excel 2007+VARPA is the population version of VARA.Syntax=VARPA(value1, [value2], ...)ArgumentWhat it.

Read article →
AVEDEV Function in Excel: Average Distance From the Mean

12 Mar 2021 · Excel Functions A–Z · 1 min read

AVEDEV Function in Excel: Average Distance From the Mean

AVEDEV is the average of absolute deviations — an easier-to-explain measure of spread than standard deviation (“on average we are off by 12 units”).

Read article →
DEVSQ Function in Excel: Sum of Squared Deviations

7 Mar 2021 · Excel Functions A–Z · 1 min read

DEVSQ Function in Excel: Sum of Squared Deviations

DEVSQ adds up how far each value is from the mean, squared. It is the raw ingredient of variance and of ANOVA tables.

Read article →
VAR.P Function in Excel: Variance of a Whole Population

2 Mar 2021 · Excel Functions A–Z · 1 min read

VAR.P Function in Excel: Variance of a Whole Population

VAR.P is the population version of VAR.S: it divides by n, not n−1. Use it when the data is everything there is — all 12 months of a finished year.

Read article →
Machine Learning Lesson 8: Project, Predict Late Invoice Payments

24 Feb 2021 · Machine Learning · 3 min read

Machine Learning Lesson 8: Project, Predict Late Invoice Payments

Build a complete model that predicts which invoices will be paid late, test it, save it, and score new invoices into an Excel file with an action for each.

Read article →
Machine Learning Lesson 7: Pipelines, Cross-Validation and Avoiding Leakage

23 Feb 2021 · Machine Learning · 2 min read

Machine Learning Lesson 7: Pipelines, Cross-Validation and Avoiding Leakage

Bundle cleaning and the model into one scikit-learn pipeline so nothing leaks from test data, and compare models fairly with 5-fold cross-validation.

Read article →
Machine Learning Lesson 6: Clustering Customers with K-Means

22 Feb 2021 · Machine Learning · 2 min read

Machine Learning Lesson 6: Clustering Customers with K-Means

Group shoppers into segments without any labels using K-Means. Scale features first, choose the number of groups with the elbow method, and describe each segment.

Read article →
Machine Learning Lesson 5: Decision Trees and Random Forests

21 Feb 2021 · Machine Learning · 3 min read

Machine Learning Lesson 5: Decision Trees and Random Forests

Decision trees learn readable if/then rules; unlimited trees overfit. Random forests combine hundreds of trees and show which features matter most.

Read article →
Machine Learning Lesson 4: Classification (Which Customers Will Leave?)

20 Feb 2021 · Machine Learning · 3 min read

Machine Learning Lesson 4: Classification (Which Customers Will Leave?)

Predict yes/no outcomes with logistic regression. Read accuracy, precision, recall and the confusion matrix, and choose your own probability cut-off.

Read article →
Older posts
Newer posts
← Previous Page1 … Page80 Page81 Page82 … 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? →