v1.9 · 99 Utilities · 100% Free

The Time Saver
in MS Excel Powerutils Add-in for Microsoft Excel

Stop doing manually what Excel could do in one click. Powerutils is a free Add-in packed with 99 utilities that automate your most repetitive spreadsheet tasks — instantly.

↓ Download Powerutils 1.9 Explore Features →

SalesReport_Q4.xlsx — Microsoft Excel

Home

Insert

⚡ Powerutils

Data

View

=ROUND(SUM(D2:D7)/SUM(C2:C7)-1,4)

Region

Q3 Sales

Q4 Sales

Growth

Status

North

4,20,000

5,10,000

▲ 21.4%

On Track

South

3,85,000

3,60,000

▼ 6.5%

Review

East

5,10,000

6,25,000

▲ 22.5%

Exceeding

West

4,65,000

4,80,000

▲ 3.2%

Steady

Central

2,95,000

3,20,000

▲ 8.5%

On Track

South-W

3,10,000

2,90,000

▼ 6.5%

Lagging

TOTAL

23,85,000

25,85,000

▲ 8.4%

Sheet1 / Data / Pivot⚡ Powerutils ActiveSUM: 25,85,000

// About Powerutils

Built by an Excel enthusiast,
for everyone

Welcome to Powerutils — your home for everything related to Microsoft Office, with a special focus on Excel and Visual Basic for Applications (VBA), the powerful programming language built right inside Office.

The centrepiece is the Powerutils Add-in: a free, easy-to-install Excel tool that automates the most common, time-consuming spreadsheet tasks. With 99 utilities and growing, it covers text case conversion, date formatting, colour-based sorting, range operations, and much more — all directly from the Excel ribbon.

Whether you work in MIS, finance, audit, accounts closing, or SAP/ERP, Powerutils is built for you. Have an idea for a new utility? Send an email with full details and a sample spreadsheet — it may appear in the next version.

Prasanta Das Gupta

📍 Jamshedpur, Jharkhand, India

"I built Powerutils to solve the Excel problems I faced every day at work. If it saves even one person an hour of effort, it is more than worth it. Keep visiting — there is always more on the way."

8/2, Juniper Flat, Aastha Twin City
Baridih, Jamshedpur, India — 831019

✉ prasanta2907@gmail.com

// What's Inside

99 utilities. One add-in.

From text conversion to colour sorting, date tools to range operations — Powerutils handles your daily Excel tasks in seconds, not minutes.

🔤

Text Case Conversion

Instantly convert any selection between UPPERCASE, lowercase, and Proper Case — no formulas needed.

📅

Date & Number Tools

Reliable date arithmetic, smart number formatting, and conversion between text and numeric values.

🎨

Sort by Colour

Sort data ranges by cell colour or font colour — something Excel still can't do natively in most versions.

⚡

One-Click Automation

Automate the most frequent Excel tasks with a single click, saving hours of manual work every week.

📋

Range Operations

Transpose, fill blanks, remove duplicates, merge and split ranges — powerful tools across large datasets.

↩️

Full Undo Support

Every utility in v1.9 ships with verified undo support so you can work confidently and reverse any change.

📊

MIS & Audit Ready

Designed for finance, MIS, accounts closing, and SAP/ERP workflows — built around real business needs.

🧩

Ribbon Integration

Installs as a standard Excel Add-in and appears directly in the ribbon — no separate launcher required.

🆓

Completely Free

No fees, no subscriptions, no ads. Powerutils has been free software since 2004 and always will be.

// Free Download

Get Powerutils 1.9

The most complete version ever — 99 utilities, full undo support, compatible with Windows XP, Vista, and all modern Windows versions.

⚠ If you downloaded before March 2008, please re-download — critical undo corrections were applied in that release.

v1.9 · Jan 2008 · Latest Release

Powerutils 1.9

99 time-saving utilities in one lightweight add-in. Easy one-click install — no registration required.

99 powerful utilities included
Verified undo support on every utility
Text: UPPER / lower / Proper Case
Sort data by cell colour or font colour
Date arithmetic & number formatting
Works on Windows XP, Vista & later
Integrates directly into Excel's ribbon
100% freeware — no license needed

↓ Download Powerutils 1.9 (.zip)

⚡ Freeware · No registration · ~370 KB

Also available: Version 1.8 (.zip) →

// Tips & Tricks

Excel tips worth knowing

Practical habits that make you a faster, more reliable Excel user — from essentials to surprisingly powerful tricks.

#01

Always enter dates with DATE()

Use =DATE(year, month, day) instead of typing dates directly. It takes one extra second but makes date arithmetic completely reliable and avoids regional format mismatches.

#02

Wrap every formula with ROUND()

Always use =ROUND(formula, n) where n is decimal places. Without it, 2.3 + 2.3 formatted to zero decimals can display as 2 + 2 = 5. Your boss won't be impressed.

#03

Concatenate smartly with &

The & operator joins cells or adds text inline. Try ="Report as of "&TEXT(NOW(),"dd-mmm-yyyy") for dynamic labels — far cleaner than nested functions.

#04

Master these 8 essential functions

Invest time in: =IF, =AND, =OR, =LEFT, =MID, =RIGHT, =LEN, and =VLOOKUP. They will rescue you from complex problems every week.

// Learning Resources

Excel & VBA Tutorials

Step-by-step guides in plain language — so even a new Excel user can become an expert quickly.

📐

Excel Functions

VLOOKUP — look up data from large rangesRead →

IF, AND, OR — decisions on multiple criteriaRead →

SUMIF & COUNTIF — conditional totalsRead →

SUMPRODUCT — advanced array calculationsComing soon

String manipulation & concatenationComing soon

💻

Visual Basic for Applications

Your first day with Excel VBA programmingComing soon

Working with Cells and RangesComing soon

Navigating cells — all methodsComing soon

Cell data analysis techniquesComing soon

Looping, decisions & arraysComing soon

🔗

Quick Links & Resources

Powerutils full help documentationOpen →

What's new in version 1.9Read →

User feedback & reviewsView →

Request a new feature or utilityEmail →

Download version 1.8 (previous)↓ .zip