Popular topics

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

Recent posts

  • Building Autonomous Multi-Agent Workflows with LangGraph: State, Nodes & Conditional Routing
  • Evaluating Enterprise RAG Systems in Python: Context Precision, Faithfulness & Hallucination Benchmarks
  • Automate Excel to PowerPoint Slides Using Python: Complete python-pptx Workflow Guide
  • TDS Calculation in Excel for FY 2026-27: Complete Sections 192, 194C, 194J Guide & Formulas
  • Excel #REF!, #VALUE! and #DIV/0! Errors: Complete Troubleshooting Matrix & Fixes
  • Basics of VBA / Macros Chapter – 43 (String Manipulation Part-5)

🤯 Wacky fact of the day · Space

Space smells like burnt steak, according to astronauts.

Astronauts returning from spacewalks have described a metallic, burnt or seared-meat smell on their suits, thought to come from reactive oxygen atoms and other…

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
    • Office
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
  • 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

Office

Word, PowerPoint, Outlook and Google Workspace tips for faster everyday work.

PowerPoint Lesson 1: Slide Layouts and the Slide Master

PowerPoint Lesson 1: Slide Layouts and the Slide Master 1

2 Feb 2022 · PowerPoint · 3 min read

PowerPoint Lesson 1: Slide Layouts and the Slide Master

Use layouts instead of loose text boxes, change fonts, colours and logos once in the Slide Master, reset slides that drifted, and build a…

Read article →
2 February 2022 by Atul Vij PowerPoint

Word Lesson 4: Tables in Word

Word Lesson 4: Tables in Word 2

11 Aug 2021 · Word · 3 min read

Word Lesson 4: Tables in Word

Insert and convert tables, apply table styles, repeat header rows, align numbers, merge and split cells, simple formulas like =SUM(ABOVE), sort a table, and…

Read article →
11 August 2021 by Atul Vij Word

Link Excel Charts to PowerPoint and Refresh Them Automatically

Link Excel Charts to PowerPoint and Refresh Them Automatically

5 Aug 2021 · Excel VBA · 2 min read

Link Excel Charts to PowerPoint and Refresh Them Automatically

Paste Excel charts into PowerPoint as linked objects so monthly decks update with one click — plus a VBA macro that refreshes every link…

Read article →
5 August 2021 by Atul Vij Excel VBA, PowerPoint

Word Lesson 10: PDF, Sharing and Co-authoring

Word Lesson 10: PDF, Sharing and Co-authoring 3

10 Jun 2021 · Word · 3 min read

Word Lesson 10: PDF, Sharing and Co-authoring

Finish and share documents properly: inspect and remove hidden data, save as PDF with bookmarks, restrict editing, protect with a password, share OneDrive links…

Read article →
10 June 2021 by Atul Vij Word

Word Lesson 9: Word Shortcuts That Matter

Word Lesson 9: Word Shortcuts That Matter 4

9 Jun 2021 · Word · 2 min read

Word Lesson 9: Word Shortcuts That Matter

The keyboard shortcuts that make a real difference in Word: selecting text, formatting, styles, Find and Replace, change case, repeat last action, navigation and…

Read article →
9 June 2021 by Atul Vij Word

Word Lesson 8: Templates and Quick Parts

Word Lesson 8: Templates and Quick Parts 5

8 Jun 2021 · Word · 3 min read

Word Lesson 8: Templates and Quick Parts

Stop rebuilding the same letter: create a company letterhead template (.dotx), start new documents from it, save reusable blocks with Quick Parts and AutoText,…

Read article →
8 June 2021 by Atul Vij Word

Word Lesson 7: Track Changes and Comments

Word Lesson 7: Track Changes and Comments 6

7 Jun 2021 · Word · 3 min read

Word Lesson 7: Track Changes and Comments

Review documents without losing anyone’s edits: turn on Track Changes, choose markup views, accept or reject edits, reply to and resolve comments, lock tracking…

Read article →
7 June 2021 by Atul Vij Word

Word Lesson 5: Images, Shapes and Text Wrapping

Word Lesson 5: Images, Shapes and Text Wrapping 7

5 Jun 2021 · Word · 3 min read

Word Lesson 5: Images, Shapes and Text Wrapping

Insert pictures and icons, compress them, control text wrapping and position so images stop jumping around, anchor and lock them, add captions, and use…

Read article →
5 June 2021 by Atul Vij Word

Word Lesson 3: Page Layout — Margins, Orientation, Breaks and Sections

Word Lesson 3: Page Layout — Margins, Orientation, Breaks and Sections 8

3 Jun 2021 · Word · 3 min read

Word Lesson 3: Page Layout — Margins, Orientation, Breaks and Sections

Control how pages look: margins and paper size, page breaks instead of repeated Enter, section breaks for a landscape page in a portrait document,…

Read article →
3 June 2021 by Atul Vij Word

Word Lesson 2: Headings, Navigation Pane and Table of Contents

Word Lesson 2: Headings, Navigation Pane and Table of Contents 9

2 Jun 2021 · Word · 3 min read

Word Lesson 2: Headings, Navigation Pane and Table of Contents

Use heading levels to structure a document, jump and reorganise sections with the Navigation Pane, insert an automatic table of contents, update it, and…

Read article →
2 June 2021 by Atul Vij Word

Word Lesson 1: Styles — The One Word Skill That Saves Hours

Word Lesson 1: Styles — The One Word Skill That Saves Hours 10

1 Jun 2021 · Word · 3 min read

Word Lesson 1: Styles — The One Word Skill That Saves Hours

Stop formatting text by hand. Use Word styles for headings and body text, modify a style once to change the whole document, clear manual…

Read article →
1 June 2021 by Atul Vij Word

Google Workspace Lesson 4: Google Forms Into Sheets

Google Workspace Lesson 4: Google Forms Into Sheets 11

20 Jan 2021 · Google Workspace · 2 min read

Google Workspace Lesson 4: Google Forms Into Sheets

Collect data without retyping: build a Google Form with the right question types and validation, send responses to a Sheet, summarise them with formulas…

Read article →
20 January 2021 by Atul Vij Google Workspace

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? →