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
R Lesson 4: dplyr — filter, mutate, summarise

16 May 2020 · R · 1 min read

R Lesson 4: dplyr — filter, mutate, summarise

Analyse data with dplyr verbs: filter rows, mutate new columns, arrange, group_by and summarise — the R equivalent of filters, formulas and pivot tables.

Read article →
ROW Function in Excel: Row Number of a Cell

11 May 2020 · Excel Functions A–Z · 1 min read

ROW Function in Excel: Row Number of a Cell

ROW returns the row number of a reference (or of the cell it is in). It is the quiet engine behind serial numbers and many array tricks.

Read article →
IFS Function in Excel: Several Conditions Without Nested IFs

10 May 2020 · Excel Functions A–Z · 1 min read

IFS Function in Excel: Several Conditions Without Nested IFs

IFS checks conditions in order and returns the value for the first TRUE one — cleaner than nesting IF inside IF.

Read article →
OCT2HEX Function in Excel: Octal to Hexadecimal

8 May 2020 · Engineering · 1 min read

OCT2HEX Function in Excel: Octal to Hexadecimal

OCT2HEX converts a octal number to hexadecimal. Used for device codes, permission bits, memory addresses and number-system lessons.

Read article →
SQL from Zero: A Complete Beginner’s Guide (with Practice)

4 May 2020 · SQL · 5 min read

SQL from Zero: A Complete Beginner’s Guide (with Practice)

Learn SQL from the very beginning: tables, SELECT, WHERE, ORDER BY, aggregates, GROUP BY, JOINs, NULLs, subqueries, CTEs, window functions and changing data — with examples you can run in your browser.

Read article →
ISODD Function in Excel: Is the Number Odd?

30 Apr 2020 · Excel Functions A–Z · 1 min read

ISODD Function in Excel: Is the Number Odd?

InformationLevel: BeginnerAvailable in: Excel 2007+ISODD returns TRUE for odd numbers (decimals are truncated first).Syntax=ISODD(number)ArgumentWhat it.

Read article →
SEQUENCE Function in Excel: Generate a List of Numbers or Dates

28 Apr 2020 · Excel Functions A–Z · 1 min read

SEQUENCE Function in Excel: Generate a List of Numbers or Dates

SEQUENCE creates a spilled list of numbers — serial numbers, calendars, repeating patterns.

Read article →
OCT2BIN Function in Excel: Octal to Binary

27 Apr 2020 · Engineering · 1 min read

OCT2BIN Function in Excel: Octal to Binary

OCT2BIN converts a octal number to binary. Used for device codes, permission bits, memory addresses and number-system lessons.

Read article →
Nested IF, AND, OR and IFERROR: Decision Formulas Without the Headache

27 Apr 2020 · Excel Formulas · 2 min read

Nested IF, AND, OR and IFERROR: Decision Formulas Without the Headache

Write decision formulas that stay readable: nested IF in the right order, IFS, AND/OR combinations, SWITCH, lookup tables instead of deep nesting, and IFERROR/IFNA used carefully.

Read article →
HEX2DEC Function in Excel: Hexadecimal to Decimal

24 Apr 2020 · Engineering · 1 min read

HEX2DEC Function in Excel: Hexadecimal to Decimal

EngineeringLevel: IntermediateAvailable in: Excel 2007+HEX2DEC reads hex text — colour codes, error codes from logs — as a.

Read article →
DECIMAL Function in Excel: Any Base Back to a Number

18 Apr 2020 · Excel Functions A–Z · 1 min read

DECIMAL Function in Excel: Any Base Back to a Number

EngineeringLevel: IntermediateAvailable in: Excel 2013+DECIMAL reverses BASE.Syntax=DECIMAL(text, radix)ArgumentWhat it meansradix2 to 36.ExamplesExample.

Read article →
BASE Function in Excel: Number in Any Base

12 Apr 2020 · Excel Functions A–Z · 1 min read

BASE Function in Excel: Number in Any Base

BASE converts to any base from 2 to 36 and handles much bigger numbers than DEC2BIN.

Read article →
Older posts
Newer posts
← Previous Page1 … Page85 Page86 Page87 … 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? →