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
COUPDAYS Function in Excel: Days in the Current Coupon Period

19 Aug 2022 · Excel Functions A–Z · 1 min read

COUPDAYS Function in Excel: Days in the Current Coupon Period

COUPDAYS returns the number of days in the coupon period that contains settlement. Used for bond pricing and accrued interest on half-yearly coupons.

Read article →
Power Automate Intermediate Lesson 7: Monitoring, Ownership and Sharing

18 Aug 2022 · Power Automate · 1 min read

Power Automate Intermediate Lesson 7: Monitoring, Ownership and Sharing

Keep flows running when people leave: co-owners and service accounts, run history and analytics, connection references, solutions, and the licence limits to know.

Read article →
Power Automate Intermediate Lesson 6: Scheduled Reminders That Don’t Spam

17 Aug 2022 · Power Automate · 1 min read

Power Automate Intermediate Lesson 6: Scheduled Reminders That Don’t Spam

A daily flow that emails customers 3 days before an invoice is due, marks them reminded so nobody gets two mails, and runs on Indian time.

Read article →
In-Cell Bar Charts in Excel: REPT, Data Bars and Sparklines

17 Aug 2022 · Charts & Dashboards · 2 min read

In-Cell Bar Charts in Excel: REPT, Data Bars and Sparklines

Three ways to show charts inside cells — the REPT formula trick, conditional-formatting Data Bars and Sparklines — for compact dashboards that update automatically.

Read article →
Power Automate Intermediate Lesson 5: Error Handling With Scopes and Run After

16 Aug 2022 · Power Automate · 1 min read

Power Automate Intermediate Lesson 5: Error Handling With Scopes and Run After

Make flows fail loudly and recover: Try/Catch scopes, Configure run after, retry policies, the run link in alerts and terminate with a clear status.

Read article →
Power Automate Intermediate Lesson 4: Apply to Each, Arrays and Select

15 Aug 2022 · Power Automate · 1 min read

Power Automate Intermediate Lesson 4: Apply to Each, Arrays and Select

Loop through rows and attachments, build arrays with Select and Filter array, join them into one email table, and speed up loops with concurrency.

Read article →
Power Automate Intermediate Lesson 3: Approvals Routed by Amount

14 Aug 2022 · Power Automate · 1 min read

Power Automate Intermediate Lesson 3: Approvals Routed by Amount

Build an expense approval: auto-approve small claims, send large ones to the finance head, record the outcome and comments in Excel and email the employee.

Read article →
Power Automate Intermediate Lesson 2: Excel Tables Done Right

13 Aug 2022 · Power Automate · 1 min read

Power Automate Intermediate Lesson 2: Excel Tables Done Right

Use the Excel Online connector without surprises: real tables, List rows with filters, ISO dates instead of serial numbers, adding and updating rows by key column, and file locking.

Read article →
Power Automate Intermediate Lesson 1: Expressions for Dates, Text and Numbers

12 Aug 2022 · Power Automate · 1 min read

Power Automate Intermediate Lesson 1: Expressions for Dates, Text and Numbers

Write Power Automate expressions: formatDateTime, convertFromUtc to India Standard Time, addDays, concat, split, replace and float for rupee text, with results.

Read article →
Excel Shortcut of the Week: Ctrl+E Flash Fill

3 Aug 2022 · Excel Formulas · 2 min read

Excel Shortcut of the Week: Ctrl+E Flash Fill

Flash Fill (Ctrl+E) splits, joins and reformats text by example — no formulas. How to use it, five real examples, and when to use formulas instead.

Read article →
TallyPrime Shortcut Keys: The Complete List for Faster Accounting

24 Jul 2022 · Tally & Busy · 2 min read

TallyPrime Shortcut Keys: The Complete List for Faster Accounting

Every TallyPrime shortcut you actually use — vouchers F4 to F10, Alt and Ctrl combinations, report navigation and the new Go To menu — grouped by task with tips for data-entry speed.

Read article →
TallyPrime for Beginners: From Company Creation to Your First GST Invoice

15 Jul 2022 · Tally & Busy · 3 min read

TallyPrime for Beginners: From Company Creation to Your First GST Invoice

A complete beginner walkthrough of TallyPrime: create a company, enable GST, set up ledgers, stock items and tax rates, record a sales invoice, and check GSTR-1 — with shortcuts and common mistakes.

Read article →
Older posts
Newer posts
← Previous Page1 … Page68 Page69 Page70 … 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? →