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
OCT2DEC Function in Excel: Octal to Decimal

15 Jul 2022 · Engineering · 1 min read

OCT2DEC Function in Excel: Octal to Decimal

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

Read article →
Phone Storage Full? 12 Safe Ways to Free Space on Android

12 Jul 2022 · Phone · 2 min read

Phone Storage Full? 12 Safe Ways to Free Space on Android

Free up gigabytes on an Android phone without losing anything important: WhatsApp media cleanup, Google Photos backup, cached data, offline maps, downloads, duplicate files and apps you never use.

Read article →
Power Automate Lesson 3: Save Email Attachments to OneDrive

4 Jul 2022 · Power Automate · 1 min read

Power Automate Lesson 3: Save Email Attachments to OneDrive

Automatically save invoice attachments to a OneDrive or SharePoint folder: attachment trigger, Apply to each, file names with dates, and skipping signature images.

Read article →
TINV Function in Excel: Two-Tailed t Critical Value (Older Name)

3 Jul 2022 · Excel Functions A–Z · 1 min read

TINV Function in Excel: Two-Tailed t Critical Value (Older Name)

TINV returns the two-tailed t critical value. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends T.INV.2T for new work. Both give the same result.

Read article →
Power Automate Lesson 7: Power Automate Desktop — Your First Desktop Flow

2 Jul 2022 · Power Automate · 2 min read

Power Automate Lesson 7: Power Automate Desktop — Your First Desktop Flow

Automate Windows apps and websites with Power Automate Desktop: install, recorder, UI elements, variables, Excel actions and a flow that copies data from a web page to Excel.

Read article →
Export Tally Data to Excel and Build a Sales Dashboard

1 Jul 2022 · Excel for Finance · 2 min read

Export Tally Data to Excel and Build a Sales Dashboard

Export TallyPrime reports to Excel properly, clean the export, and build a sales dashboard: party-wise and item-wise totals, monthly trend, top customers and a pivot with slicers.

Read article →
Rename Hundreds of Files at Once with PowerShell

30 Jun 2022 · PowerShell · 2 min read

Rename Hundreds of Files at Once with PowerShell

Bulk-rename files on Windows with PowerShell: add dates, replace text, number files and preview every change safely before it happens.

Read article →
FINV Function in Excel: F Critical Value (Older Name)

30 Jun 2022 · Excel Functions A–Z · 1 min read

FINV Function in Excel: F Critical Value (Older Name)

FINV returns the F critical value. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends F.INV.RT for new work. Both give the same result.

Read article →
T.INV Function in Excel: t Value for a Left-Tail Probability

29 Jun 2022 · Excel Functions A–Z · 1 min read

T.INV Function in Excel: t Value for a Left-Tail Probability

T.INV returns the t value for a left-tail probability; T.INV.2T is the usual critical value.

Read article →
Power Automate: Save Email Attachments to OneDrive Automatically

23 Jun 2022 · Outlook · 1 min read

Power Automate: Save Email Attachments to OneDrive Automatically

Build a Power Automate cloud flow that saves attachments from specific Outlook emails into OneDrive or SharePoint folders — with filters, date folders and duplicate-safe names.

Read article →
F.INV.RT Function in Excel: F Critical Value

23 Jun 2022 · Excel Functions A–Z · 1 min read

F.INV.RT Function in Excel: F Critical Value

StatisticsLevel: ExpertAvailable in: Excel 2010+F.INV.RT gives the critical F value for ANOVA at a chosen significance level.Syntax=F.INV.RT(probability.

Read article →
Python Lists, Dictionaries and Loops for Excel Users

19 Jun 2022 · Python · 2 min read

Python Lists, Dictionaries and Loops for Excel Users

The three Python building blocks you use in every script — lists, dictionaries and loops — explained with Excel comparisons and small, runnable examples.

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