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
VBA Files and Folders + Final Project: Combine a Month of Reports Automatically

24 Oct 2025 · Excel VBA · 4 min read

VBA Files and Folders + Final Project: Combine a Month of Reports Automatically

Excel VBA course lesson 15: loop through files with Dir, create folders, check whether files exist, read text/CSV files, then build the final project — a one-click macro that combines every branch file, totals it and saves a dated report.

Read article →
PowerPoint Intermediate Lesson 1: Slide Master and Custom Layouts

24 Oct 2025 · PowerPoint · 2 min read

PowerPoint Intermediate Lesson 1: Slide Master and Custom Layouts

Stop formatting slide by slide: set fonts, colours and logo once in the Slide Master and create your own layouts such as "Title + Chart" and "Two KPIs".

Read article →
Build Your Own LLM, Lesson 2: Write a BPE Tokenizer in Python

20 Oct 2025 · Build Your Own LLM · 5 min read

Build Your Own LLM, Lesson 2: Write a BPE Tokenizer in Python

Build the byte-pair encoding tokenizer used by GPT-style models from scratch in about 40 lines of Python: training merges, encoding, decoding and why the vocabulary size matters.

Read article →
AI for Office Work Lesson 8: Safety, Privacy and Company Data

15 Oct 2025 · AI & ML · 2 min read

AI for Office Work Lesson 8: Safety, Privacy and Company Data

Use AI without leaking data: what not to paste, approved vs consumer tools, anonymising, Indian data protection basics (DPDP Act), copyright, bias and a simple team AI policy.

Read article →
AI for Office Work Lesson 7: Copilot in Microsoft 365

14 Oct 2025 · AI & ML · 2 min read

AI for Office Work Lesson 7: Copilot in Microsoft 365

What Microsoft 365 Copilot does in Word, Excel, PowerPoint, Outlook and Teams, practical prompts for each app, how it uses your work data, and what to check.

Read article →
AI vs Machine Learning vs Deep Learning vs LLM: The Difference in 5 Minutes

13 Oct 2025 · Machine Learning · 2 min read

AI vs Machine Learning vs Deep Learning vs LLM: The Difference in 5 Minutes

AI, machine learning, deep learning and LLMs are nested ideas, not rivals. A short, jargon-free explanation with everyday examples of each.

Read article →
AI for Office Work Lesson 6: Reports and Presentations

13 Oct 2025 · AI Tools · 2 min read

AI for Office Work Lesson 6: Reports and Presentations

Use AI to structure reports, turn numbers into commentary, draft slide outlines, create speaker notes and design with Copilot in PowerPoint — while keeping numbers correct.

Read article →
AI for Office Work Lesson 5: Cleaning and Classifying Data

12 Oct 2025 · AI Tools · 1 min read

AI for Office Work Lesson 5: Cleaning and Classifying Data

Use AI to tidy data: categorise transactions, standardise names and addresses, extract fields from text, and when to ask for a formula or Power Query steps instead.

Read article →
AI for Office Work Lesson 4: Meeting Notes and Summaries

11 Oct 2025 · AI Tools · 1 min read

AI for Office Work Lesson 4: Meeting Notes and Summaries

Turn meetings into useful notes: Teams/Zoom transcripts, prompts for decisions and action items, follow-up emails, and consent and confidentiality basics.

Read article →
AI for Office Work Lesson 3: Emails and Replies

10 Oct 2025 · AI Tools · 2 min read

AI for Office Work Lesson 3: Emails and Replies

Draft and improve emails with AI: replies to long threads, tone adjustments, difficult messages, follow-ups and translations, while keeping your voice and facts correct.

Read article →
AI for Office Work Lesson 2: Excel Formulas With AI

9 Oct 2025 · AI Tools · 2 min read

AI for Office Work Lesson 2: Excel Formulas With AI

Get correct Excel formulas from AI: describe your columns and sample rows, state your Excel version, ask for an explanation, test on known cases, and fix errors.

Read article →
Who Invented Zero? India’s Gift to Mathematics

8 Oct 2025 · History · 2 min read

Who Invented Zero? India’s Gift to Mathematics

Zero as a number — something you can add, subtract and multiply — was first written down in India. Brahmagupta's rules from 628 CE, the Gwalior inscription and how zero reached Europe.

Read article →
Older posts
Newer posts
← Previous Page1 … Page40 Page41 Page42 … 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? →