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
GAMMALN Function in Excel: Natural Log of the Gamma Function

30 Nov 2024 · Excel Functions A–Z · 1 min read

GAMMALN Function in Excel: Natural Log of the Gamma Function

GAMMALN returns ln(GAMMA(x)); useful when GAMMA itself would overflow for large x.

Read article →
Excel Lesson 6: IF — Making Decisions in a Cell

30 Nov 2024 · Excel Formulas · 3 min read

Excel Lesson 6: IF — Making Decisions in a Cell

Learn IF step by step: comparison operators, returning text or numbers, AND and OR for combined rules, nested IF for grades and ratings, and the mistakes that make IF give wrong answers silently.

Read article →
Excel Lesson 5: SUM, AVERAGE, COUNT, MIN and MAX

29 Nov 2024 · Excel Formulas · 3 min read

Excel Lesson 5: SUM, AVERAGE, COUNT, MIN and MAX

The five functions you will use every day: SUM, AVERAGE, COUNT/COUNTA/COUNTBLANK, MIN and MAX, plus AutoSum, LARGE/SMALL, how blanks and text are treated, and quick checks with the status bar.

Read article →
Excel Lesson 4: Your First Formulas and Cell References

28 Nov 2024 · Excel Formulas · 3 min read

Excel Lesson 4: Your First Formulas and Cell References

Write formulas that start with =, use + - * / and ^, follow the order of operations, refer to cells instead of typing numbers, copy formulas down, and read common error values.

Read article →
Excel Lesson 2: Entering Data, AutoFill and Flash Fill

26 Nov 2024 · Excel Formulas · 4 min read

Excel Lesson 2: Entering Data, AutoFill and Flash Fill

Enter numbers, text and dates correctly, fill series with the fill handle, use Ctrl+Enter and Ctrl+D, and let Flash Fill split and join names for you. Plus the rules that keep data usable later.

Read article →
Excel Lesson 1: The Excel Screen and Moving Around Fast

25 Nov 2024 · Excel Formulas · 4 min read

Excel Lesson 1: The Excel Screen and Moving Around Fast

Your first Excel lesson: workbooks, sheets, rows, columns and cells, the ribbon, Name Box and formula bar, and the keyboard shortcuts that make you fast from day one.

Read article →
Python Lesson 12: Project — Automate a Monthly Report

14 Nov 2024 · Python · 3 min read

Python Lesson 12: Project — Automate a Monthly Report

Build a real automation: combine every monthly CSV in a folder, clean and summarise with pandas, write a multi-sheet Excel report with KPIs, and schedule it to run by itself with Windows Task Scheduler.

Read article →
Python Lesson 11: Excel Files With openpyxl

13 Nov 2024 · Python · 2 min read

Python Lesson 11: Excel Files With openpyxl

Create formatted Excel reports from Python: write DataFrames to sheets, style headers, set number formats and column widths, add formulas and a chart with openpyxl.

Read article →
AI Agents and Tool Calling Explained (With a 20-Line Example)

12 Nov 2024 · AI Agents & RAG · 2 min read

AI Agents and Tool Calling Explained (With a 20-Line Example)

What people mean by AI agents: a model in a loop that can call tools such as search, a calculator or your database. How tool calling works, with a small Python example and the safety rules.

Read article →
Python Lesson 10: pandas — Summaries and Pivot Tables

12 Nov 2024 · Python · 2 min read

Python Lesson 10: pandas — Summaries and Pivot Tables

Summarise data with pandas: groupby with sum and count, several aggregations with agg, pivot_table with totals, top-N with nlargest, monthly summaries, and percentage of total.

Read article →
Python Lesson 9: pandas — Cleaning Messy Data

11 Nov 2024 · Python · 2 min read

Python Lesson 9: pandas — Cleaning Messy Data

Clean a real-world messy export with pandas: tidy column names, trim and fix case, turn “Rs 1,23,000” into numbers, parse mixed date formats, remove duplicates and blanks, and save the clean file.

Read article →
Python Lesson 8: pandas — Reading and Exploring Data

10 Nov 2024 · Python · 2 min read

Python Lesson 8: pandas — Reading and Exploring Data

Start with pandas: read CSV and Excel files into a DataFrame, check shape and data types, view rows, add calculated columns, and filter rows with conditions — Excel tables in code.

Read article →
Older posts
Newer posts
← Previous Page1 … Page51 Page52 Page53 … 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? →