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
Outlook Lesson 2: Rules That Sort Mail for You

2 May 2024 · Outlook · 3 min read

Outlook Lesson 2: Rules That Sort Mail for You

Create Outlook rules that file newsletters, highlight your boss’s mail, sort CC mail, and handle alerts automatically; run rules on existing mail, add exceptions, and know server vs client rules.

Read article →
Outlook Lesson 1: Folders, Focused Inbox and a Clean Inbox

1 May 2024 · Outlook · 3 min read

Outlook Lesson 1: Folders, Focused Inbox and a Clean Inbox

Set up a simple folder system that works, decide on Focused Inbox, process mail with the 4D method, use conversations, flags and categories, and clean up long threads.

Read article →
12 Browser Tricks That Make You Faster (Chrome, Edge, Firefox)

16 Apr 2024 · Internet & Browser · 2 min read

12 Browser Tricks That Make You Faster (Chrome, Edge, Firefox)

Reopen closed tabs, search specific sites from the address bar, group tabs, read without clutter and more — browser shortcuts that save time every day.

Read article →
AutoHotkey: Text Expansion and Hotkeys That Save Hours Every Week

14 Apr 2024 · AutoHotkey · 2 min read

AutoHotkey: Text Expansion and Hotkeys That Save Hours Every Week

Use AutoHotkey v2 on Windows to expand abbreviations into full text, insert today’s date, and launch apps with shortcuts — with a starter script you can copy.

Read article →
10 Tech Myths People Still Believe

7 Apr 2024 · Fun Facts · 2 min read

10 Tech Myths People Still Believe

Incognito mode makes you anonymous, you must drain your battery, more megapixels means better photos — ten common tech myths, busted.

Read article →
Writing Prompts That Get Working Excel Formulas (and Why Vague Prompts Fail)

19 Mar 2024 · Prompt Engineering · 3 min read

Writing Prompts That Get Working Excel Formulas (and Why Vague Prompts Fail)

How to ask an AI assistant for Excel formulas, VBA and SQL so the answer actually works: describe the layout, give sample rows, state your Excel version, and test against edge cases.

Read article →
Working Days and Due Dates in Excel: Skip Weekends and Holidays

18 Mar 2024 · Formula Combos · 2 min read

Working Days and Due Dates in Excel: Skip Weekends and Holidays

Calculate due dates N working days ahead, count working days per month, handle Sunday-only or Friday–Saturday weekends, and keep a holiday list — with WORKDAY, NETWORKDAYS and their .INTL versions.

Read article →
JavaScript Lesson 8: Fetch — Getting Data From an API

23 Feb 2024 · JavaScript · 1 min read

JavaScript Lesson 8: Fetch — Getting Data From an API

Call web APIs with fetch, async/await, check response status, parse JSON, handle errors and offline cases, and where API keys must never go.

Read article →
JavaScript Lesson 7: The DOM — Changing a Web Page

22 Feb 2024 · JavaScript · 1 min read

JavaScript Lesson 7: The DOM — Changing a Web Page

Make a page interactive: select elements with getElementById and querySelector, read input values, handle click events, change text and create elements.

Read article →
JavaScript Lesson 6: Objects and JSON

21 Feb 2024 · JavaScript · 1 min read

JavaScript Lesson 6: Objects and JSON

Group related data in objects, access nested properties, destructure values, convert to and from JSON with JSON.stringify and JSON.parse — the format every API uses.

Read article →
JavaScript Lesson 4: Functions and Arrow Functions

19 Feb 2024 · JavaScript · 1 min read

JavaScript Lesson 4: Functions and Arrow Functions

Write reusable functions with parameters, default values and return, the shorter arrow function syntax, and where functions are used as values.

Read article →
JavaScript Lesson 3: Conditions and Loops

18 Feb 2024 · JavaScript · 1 min read

JavaScript Lesson 3: Conditions and Loops

Make decisions with if/else and the ternary operator, compare with ===, and repeat work with for, for...of over arrays and objects, and while.

Read article →
Older posts
Newer posts
← Previous Page1 … Page57 Page58 Page59 … 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? →