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
PowerPoint Lesson 8: Export, Share and Print Handouts

9 Feb 2022 · PowerPoint · 3 min read

PowerPoint Lesson 8: Export, Share and Print Handouts

Get your deck to people the right way: PDF with notes or handouts, printing 3 slides per page, video export, shrinking file size, sharing a OneDrive link and co-authoring.

Read article →
PowerPoint Lesson 6: Animations and Transitions (With Restraint)

7 Feb 2022 · PowerPoint · 2 min read

PowerPoint Lesson 6: Animations and Transitions (With Restraint)

Use animation to explain, not decorate: one subtle transition, reveal points one at a time, build charts step by step, Morph for smooth changes, and the Animation Pane for timing.

Read article →
PowerPoint Lesson 5: SmartArt and Diagrams

6 Feb 2022 · PowerPoint · 2 min read

PowerPoint Lesson 5: SmartArt and Diagrams

Turn bullet lists into processes, timelines, cycles and hierarchies with SmartArt, restyle them with theme colours, and convert to shapes when you need full control.

Read article →
PowerPoint Lesson 4: Charts and Tables From Excel

5 Feb 2022 · PowerPoint · 2 min read

PowerPoint Lesson 4: Charts and Tables From Excel

Show numbers clearly in PowerPoint: insert and edit charts, paste or link Excel charts, simplify (title with the point, direct labels, no clutter), and build tables that are easy to read.

Read article →
PowerPoint Lesson 3: Images, Icons and Designer

4 Feb 2022 · PowerPoint · 2 min read

PowerPoint Lesson 3: Images, Icons and Designer

Use pictures well: full-bleed images, cropping to shape, stock images and icons, removing backgrounds, Designer suggestions, aligning objects, and compressing pictures so decks stay small.

Read article →
R Lesson 5: ggplot2 Charts

3 Feb 2022 · R · 1 min read

R Lesson 5: ggplot2 Charts

Make clean charts with ggplot2: the aesthetics-geometry idea, bar and line charts, ordering bars, labels and themes, and saving PNGs for reports.

Read article →
PowerPoint Lesson 2: Writing Slides People Can Read

3 Feb 2022 · PowerPoint · 2 min read

PowerPoint Lesson 2: Writing Slides People Can Read

Turn walls of text into slides that work: headline titles that state the point, one idea per slide, few words in large type, detail in speaker notes, and a structure that gets to the answer first.

Read article →
PowerPoint Lesson 1: Slide Layouts and the Slide Master

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 clean company theme.

Read article →
Beautiful Charts in R with ggplot2 (for Excel Users)

25 Jan 2022 · R · 1 min read

Beautiful Charts in R with ggplot2 (for Excel Users)

Build bar, line and scatter charts in R with ggplot2, and learn the “grammar of graphics” idea that makes every chart the same few steps.

Read article →
Bank Reconciliation in TallyPrime (BRS) — Step by Step

18 Jan 2022 · Tally & Busy · 2 min read

Bank Reconciliation in TallyPrime (BRS) — Step by Step

Reconcile your bank account in TallyPrime: open the bank ledger, enter bank dates, import statements, and read the reconciliation statement to find unpresented cheques and missing entries.

Read article →
Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained

13 Jan 2022 · Formula Combos · 2 min read

Find the LAST Match in a List: the LOOKUP(2, 1/…) Trick Explained

Get the latest price, last status or most recent date for an item with the famous LOOKUP(2,1/(range=value)) formula — explained step by step, plus the XLOOKUP alternative.

Read article →
CUMPRINC Function in Excel: Principal Repaid Over a Period

7 Jan 2022 · Excel Functions A–Z · 1 min read

CUMPRINC Function in Excel: Principal Repaid Over a Period

CUMPRINC totals the principal part of loan payments between two periods — how much of the loan you actually cleared this year.

Read article →
Older posts
Newer posts
← Previous Page1 … Page72 Page73 Page74 … 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? →