Excel PowerUps Premium Suite

Download a fully functional 30-day trial. No sign-up, registration, email name or credit card required. Just download and start being more productive.

Go to the download page Buy now

Take the plunge. Download it free today

Go to the download page

Six Products. Now in a Single Package

Text Analysis Assistant

The Text Analysis functions enable you to more easily work with text values to analyze, evaluate, search with regular expressions, and evaluate sentiment to help you quickly analyze and process large volumes of text or verbatim responses.

Data Randomizer Assistant

The Randomizer functions give you new randomizing functions for random text, random name generation, random selections from lists or regions, and random outcomes based on likelihood.

Field Validation Assistant

The Field Validator functions are used to verify your data conforms to formatting standards for phone numbers, addresses, credit card numbers, email addresses, etc. Now you can more easily detect bad data or bogus entries from forms or other sources.

Fuzzy Data Assistant

The Excel PowerUps Premium Suite includes more functions to identify the current user, handle many types of unit conversions, and more. Cool tools such as the Fuzzy Find and Replace tool make this a super useful add-in.

Web Assistant

The Web Assistant functions extend Excel to be “web aware”. Now you can work with online web services, work with XML using XPath, and even verify URLs and filepaths are valid. Create new dynamic worksheets from services and create new live reports.

Excel PowerUp Functions

The Excel PowerUp functions add the new functions only available in Excel 2013 to your copy of Excel 2010, 2007, or 2003. Share more files across Excel 2013, 2010, 2007 and 2003 that use the newest functions.

Automatic Installation

Automatic installation and enabling in Excel

Free Updates

Updates of the same series are included

Free Support

Free support is available over email

Join Thousands of Users Worldwide

Excel PowerUps has thousands of users worldwide. And why not? Extend the life of legacy versions of Excel you’ve already invested in without sacrificing the advancements of the new functions in the newest version of Excel. Get new groups of functions opening new capability doors for your worksheets.

Volume Pricing Available

Read more

What are customers saying?

Here are some of the comments we've got back from customers.

Happy Customer

"Love it, was just the tool I needed to complete my project. Great support too. Thanks!!"

Satisfied Customer

"This is [...] awesome!"

Productive Customer

"Thank you so much. I can't live without it!"

Latest Posts

Browse the latest posts or search for a topic you're looking for at the top of the page.

3156890720_5dbb5b7f2c_z

300 level, Excel

IFS Function in Excel 2013

Posted By Charlie Nichols

You can add an IFS Function for Excel 2013, 2010, and 2007
Excel 2016 introduced a new function called IFS. You can add an IFS function to your copy of Excel 2013, 2010, or 2007 with the Excel PowerUps add-in.
The IFS function in Excel 2013 allows you to

14481855815_cfbc4e0c41_z

300 level, Excel

SWITCH Function for Excel 2013, 2010, and 2007

Posted By Charlie Nichols

Now Available: SWITCH Function for Excel 2013, 2010, and 2007
Excel 2016 introduced a new function called SWITCH. You can add a SWITCH function to your copy of Excel 2013, 2010, or 2007 with the Excel PowerUps add-in.
The SWITCH function in Excel 2013 allows

6096614897_03376b6888_z

Excel

TEXTJOIN, SWITCH, IFS, MAXIFS, MINIFS, CONCAT Available for Excel 2013, 2010, 2007

Posted By Charlie Nichols

New Functions Available for Excel 2013, 2010, 2007
The following functions are available for Excel 2013, Excel 2010, and Excel 2007 in the Excel PowerUps Premium Suite.

CONCAT
IFS
MAXIFS
MINIFS
SWITCH
TEXTJOIN

These functions were introduced in a recent update for

how to pick a random name from a range of cells

200 level, Excel

How to pick a random value from a range of cells in Excel

Posted By Charlie Nichols

How to pick a random number from a range of cells
Here’s how to pick a random number from a range of cells in Excel. And actually, it doesn’t need to be a number. If you have a range that contains data (names, numbers, dates, whatever)

pwrconcatenate

200 level, Excel

Concatenate a range of cells in Excel – Easily

Posted By Charlie Nichols

Concatenate a Range of Cells in Excel
Concatenate a range of cells in Excel without having to individually select every cell that you want to concatenate. The pwrCONCATENATE function (part of the Text Analyzer Assistant in the Excel PowerUps Premium Suite) lets you select a

diagx

100 level, Excel

How to X out a cell in Excel – a visual How-to

Posted By Charlie Nichols

X out a cell in Excel
You can easily X out a cell in Excel by placing an X from corner to corner in a cell in Excel. Follow the steps below with accompanying screen shots.

Select the cell(s) you wish to place

17476837524_38e39f623d_z

200 level, Excel

How to fix a VLOOKUP error in Excel

Posted By Charlie Nichols

VLOOKUP error in Excel
Ever have this happen? You write your VLOOKUP formula and have one of the following values returned:

#VALUE!
#NAME?
#N/A
#REF!
Other UNEXPECTED result!

Below you’ll find some common pitfalls that cause each of the errors above.
VLOOKUP

200 level, Excel

Excel Financial Functions tutorial

Posted By Charlie Nichols

Excel as a Financial Tool
Excel provides a number of functions to make calculating financial data very easy. You can find a great deal of examples and documentation on each of the functions. For this tutorial, we will use five commonly used Excel financial

912749911_210a0c6bdb_b (1)

200 level, Excel

Regular Expressions in Excel – Test Tool

Posted By Charlie Nichols

Regular expressions in Excel
Regular expressions in Excel are made easy with the pwrREGEXMATCH function.
As a demonstration of the function, the example file pictured below is set up to evaluate a regular expression entered in cell D2 against text entered in cell D4.

Download it free today

Go to the download page

Contact info      Privacy      Terms of use      © 2016 Northwest Online Enterprises, LLC