Skip to content

Popular topics

ExcelExcel VBAPower Query & PivotsExcel for FinanceAutomationSAP & OracleCodingAI & MLTech tipsWacky World

Recent posts

  • Basics of VBA / Macros Chapter – 80 (Userform Part-1)
  • Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
  • Basics of VBA / Macros Chapter – 68 (Application Object Part-1)
  • Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
  • Loan Amortization Schedule in Excel with Extra Payments: Step-by-Step Template & Formulas
  • Excel Month-End Financial Close: Step-by-Step Checklist, Reconciliation Formulas & Template

🤯 Wacky fact of the day · Human Body

The brain uses about 20% of the body’s energy.

Although it is only around 2% of body weight, the brain consumes roughly a fifth of the body’s energy at rest.

Why? How? →Source ↗

AJ's Techie & Wacky World

Excel, SAP, Oracle & automation tips — plus wacky facts

Skip to content
  • ✨ 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

Atul Vij

DEGREES Function in Excel: Radians to Degrees

DEGREES Function in Excel: Radians to Degrees featured illustration

1 May 2023 · Excel Functions A–Z · 1 min read

DEGREES Function in Excel: Radians to Degrees

MathLevel: IntermediateAvailable in: Excel 2007+DEGREES converts radians back to degrees.Syntax=DEGREES(angle)ArgumentWhat it meansangleIn.

Read article →
1 May 2023 by Atul Vij Excel Functions A–Z, Math & Trig

SIN Function in Excel: Sine of an Angle

SIN Function in Excel: Sine of an Angle featured illustration

28 Apr 2023 · Excel Functions A–Z · 1 min read

SIN Function in Excel: Sine of an Angle

MathLevel: IntermediateAvailable in: Excel 2007+SIN expects radians. Wrap degrees in RADIANS().Syntax=SIN(number)ArgumentWhat it meansnumberAngle in.

Read article →
28 April 2023 by Atul Vij Excel Functions A–Z, Math & Trig

RADIANS Function in Excel: Degrees to Radians

RADIANS Function in Excel: Degrees to Radians featured illustration

23 Apr 2023 · Excel Functions A–Z · 1 min read

RADIANS Function in Excel: Degrees to Radians

MathLevel: IntermediateAvailable in: Excel 2007+RADIANS converts degrees, because SIN, COS and TAN in Excel expect.

Read article →
23 April 2023 by Atul Vij Excel Functions A–Z, Math & Trig

PowerPoint Lesson 7: Presenter View, Notes and Rehearsing

PowerPoint Lesson 7: Presenter View, Notes and Rehearsing featured illustration

18 Apr 2023 · PowerPoint · 2 min read

PowerPoint Lesson 7: Presenter View, Notes and Rehearsing

Present confidently: speaker notes, Presenter View with timer and next slide, jumping to any slide, blacking the screen, using the laser pointer, Rehearse with…

Read article →
18 April 2023 by Atul Vij PowerPoint

7 Prompt Patterns That Get Better Answers from ChatGPT and Claude

7 Prompt Patterns That Get Better Answers from ChatGPT and Claude featured illustration

11 Apr 2023 · Prompt Engineering · 2 min read

7 Prompt Patterns That Get Better Answers from ChatGPT and Claude

Seven practical prompt patterns — context, examples, format, steps, constraints, delimiters and questions first — with before-and-after prompts you can reuse.

Read article →
11 April 2023 by Atul Vij Prompt Engineering

Java Lesson 6: Collections — List and Map

Java Lesson 6: Collections — List and Map featured illustration

8 Apr 2023 · Java · 1 min read

Java Lesson 6: Collections — List and Map

Store groups of objects with ArrayList and HashMap/TreeMap, loop over them, merge totals by key, and use streams for sums.

Read article →
8 April 2023 by Atul Vij Java

PowerPoint Presenter View: 7 Tricks for Calmer Presentations

PowerPoint Presenter View: 7 Tricks for Calmer Presentations

7 Apr 2023 · PowerPoint · 1 min read

PowerPoint Presenter View: 7 Tricks for Calmer Presentations

Use PowerPoint’s Presenter View to see notes, the next slide and a timer while the audience sees only your slides — plus shortcuts to…

Read article →
7 April 2023 by Atul Vij PowerPoint

Java Streams for Beginners: filter, map and collect Explained

Java Streams for Beginners: filter, map and collect Explained

28 Mar 2023 · Java · 1 min read

Java Streams for Beginners: filter, map and collect Explained

Java Streams let you process lists in a clear, declarative style. Learn filter, map, sorted, collect and groupingBy with a small sales example.

Read article →
28 March 2023 by Atul Vij Java

SAP – Systems Applications and Products

SAP - Systems Applications and Products

27 Feb 2023 · SAP · 2 min read

SAP – Systems Applications and Products

SAP stands for Systems Applications and Products in Data Processing. It is ERP software as well as the name of the company. SAP software…

Read article →
27 February 2023 by Atul Vij SAP

FDIST Function in Excel: F Probability (Older Name)

FDIST Function in Excel: F Probability (Older Name) featured illustration

11 Feb 2023 · Excel Functions A–Z · 1 min read

FDIST Function in Excel: F Probability (Older Name)

FDIST returns the right-tailed F probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…

Read article →
11 February 2023 by Atul Vij Excel Functions A–Z, Statistical

TEXTSPLIT, TEXTBEFORE and TEXTAFTER: Splitting Text Without the Headache

TEXTSPLIT, TEXTBEFORE and TEXTAFTER: Splitting Text Without the Headache featured illustration

17 Jan 2023 · Excel Formulas · 2 min read

TEXTSPLIT, TEXTBEFORE and TEXTAFTER: Splitting Text Without the Headache

Split codes, names, addresses and emails in Excel 365 with TEXTSPLIT, TEXTBEFORE and TEXTAFTER: delimiters, instance numbers, multiple delimiters, rows vs columns, missing values…

Read article →
17 January 2023 by Atul Vij Excel Formulas

FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe)

FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe) featured illustration

12 Jan 2023 · Excel Functions A–Z · 1 min read

FLOOR.PRECISE Function in Excel: Round Down to a Multiple (Sign-Safe)

FLOOR.PRECISE rounds down to a multiple regardless of signs; negatives round away from zero.

Read article →
12 January 2023 by Atul Vij Excel Functions A–Z, Math & Trig

Post navigation

← Older posts
Newer posts →
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
© 2026 Atul Vij · AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? →