Built for the Mac. Built on the Mac. Same Powerful Tools as Windows version. Runs on Mac Excel 2011


What is Excel Power Expander?

Excel Power Expander is a very powerful Automation Toolbox for Microsoft Excel. It adds 87 automation utilities and 125 new worksheet formulas into the world’s most popular spreadsheet software. The tools substantially extend Excel’s functionality and add much intelligence to automate everyday complex spreadsheet tasks.

In this major upgrade, same as previous versions, both Windows and Mac Excel are supported.

With Excel Power Expander, you can perform impossible data crunching operations and achieve improved work efficiency that no one can achieve.


 

System Requirements

Excel Power Expander 5 Mac Edition is fully compatible with Excel 2011 for Mac.

In addition, the Windows version supports the following versions of Excel:

- Excel 2013 for Windows (Office 365)
- Excel 2010 for Windows
- Excel 2007 for Windows
- Excel 2003 for Window

No matter you are using the PC and/or Mac, or planning to use either or both, you can always enjoy the identical tools in Excel Power Expander.

Super-Charge Microsoft Excel for Mac!

Excel Power Expander Mac Edition delivered functionality which are grouped into the following categories:

- Formatting Tools;
- Range Tools;
- Text Manipulation Tools;
- Workbook / Worksheet / View Management Tools;
- World Holiday Calendar + Holiday calculation Functions;
- Miscellaneous Automation Utilities;and
- 125 New Worksheet Formulas

All the functions were very carefully designed, so that they can be highly practical tools and useful in processing real-world data.

Objective : Translate Automation into
Improved Work Efficiency

While delivering a lot of useful features, all Excel Power Expander features were designed with an objective of achieving improved work efficiency through automation. With just a few mouse clicks, Excel Power Expander will carry out operations which require hundreds or even millions of steps. With automation, Excel Power Expander actually helps you to work more efficiently and break through the constrains of time and cost.

Features Highlight

Automation Utilities
(Tools which you can run from the menus (or ribbons)

Full integration with the new
MS Office Ribbons, Menus and Shortcut Menus

TEXT MANIPULATION TOOLS
- Split-Up Words Wizard
- Combine Cell Contents
- Case Change
- Append Characters
- Cell Padding
- Date Re-Construction
- Word Count
- Negative Reposition

FORMATTING TOOLS
- 3D Format Filters
- Alternate Columns / Rows Shading

INSERTION TOOLS
- Insert Columns/ Insert Rows
- Insert Thin Columns / Insert Thin Rows

RANGE TOOLS
- Range Selection Tools
- Range Swap Tools
- Reverse Columns Order
- Reverse Rows Order
- Swap Columns Order
- Swap Rows Order
- Swap Columns/Rows Order [Form Mode]
- Force Convert To Values
- Copy Column Widths
- Copy Row Heights

DUPLICATED ROWS HUNTER

MISSING SEQUENTIAL NUMBERS HUNTER

MATRIX TRANSFORM

NUMBER TO ENGLISH TRANSLATION WIZARD

UNITS CONVERSION

PERPETUAL CALENDAR

SAVE ASSISTANTS
- Revert To Saved
- Save All
- Save Status Monitor

KILLERS
- Kill Characters
- Kill Irregular Spacings
- Kill All Spaces
- Empty Rows Killer
- Empty Sheets Killer
- Hyperlinks Killer

PHANTOM CLEANERS
- Remove Phantom Names
- Clean Pivot Table Field Names

EXTRACTORS
- Extract Initials
- Extract Characters

CALENDAR (AND HOLIDAY CALENDAR) TOOLS
- World Holidays (Holiday Calendars)
World Holidays / Location Code Lookup
Holiday Worksheet Functions
- Perpetual Calenders

RANDOM TOOLS
- Random Number Generator
Normal Mode
Advanced Mode
Random Numbers Generator In Action
- Random Dates
- Random Characters
- Data Random Pick
- Randomize Order

WORKBOOKS MANAGEMENT
- Excel Navigator
- Sheets Sorter
Normal Mode
Advanced Mode
- Sheets Visibility
— Very Hidden
Anti-Stealth
Visibility Check
- Zoom Ratio Controller
- Duplicate Sheets
- Print Multiple Sheets

GLOBAL ASSIGNMENT
- Global Assign Page Setup
- Global Assign Workbook Properties

TOGGLE WINDOW OPTIONS

Worksheet Functions

Date & Time Functions
- CHINESEDATE
- CHINESEDATEPRO
- DATE2NUMBER
- DAYNAME
- DAYOFYEAR
- DAYSINMONTH
- DAYSLEFTINYEAR
- ISHOLIDAY
- ISLEAPYEAR
- MONTHNAME
- MONTHWEEK
- MOONPHASE
- SUNRISE
- SUNSET
- SUNTIMES
- TEXTDATE
- UTCOFFSET
- WEEKDAYCOUNT
- ZODIAC

Math & Trigonometric Functions
- ACOSEC
- ACOTAN
- ASEC
- COSEC
- COTAN
- HACOSEC
- HACOTAN
- HASEC
- HCOS
- HCOTAN
- HSIN
- HTAN
- ISEVEN
- ISODD
- ISPRIME
- LOGN
- ORDINAL
- PRODUCT3D
- PRODUCTROUND
- PRODUCTROUND3D
- ROUNDSIG
- SEC
- STATICRAND
- SUM3D
- SUMROUND
- SUMROUND3D

Statistical Functions
- AVERAGE3D
- AVERAGEROUND
- COUNT3D
- COUNTA3D
- COUNTBLANK3D
- EVENCOUNTBETWEEN
- INTCOUNTBETWEEN
- LARGE3D
- MAX3D
- MIN3D
- ODDCOUNTBETWEEN
- SMALL3D

Text Functions
- CONTAINS
- INSERTSTRING
- NUM2CHINESE
- NUM2TXT
- REMOVEIRRSPACE
- REMOVESPACE
- SCRAMBLE
- UNIQUECHAR
- UNIQUECHARCOUNT

Scientific Functions
- ABSZERO
- ATOMIC
- AVOGADRO
- BOHRMAG
- BOLTZ (BOLTZMANN)
- ELCHARGE
- ELEMENT
- EMASS
- FARADAY
- FINESTRCONST
- GCONST
- GRAVITY
- LIGHT
- NEUTRON
- NMASS
- NUCLEARMAG
- PLANCK
- PMASS
- SOUND
- SOUNDA
- SOUNDW
- VACUUMP

Range/Reference Functions
- FIND_COLUMN_INDEX
- FIND_ROW_INDEX
- XLOOKUP

Financial Functions
- BENFORD
- FD
- F2D
- F3D
- MATURITY

Information Functions
- APPBUILD
- APPVERSION
- CELLCOLORINDEX
- CELLCOMMENT
- CELLFORMULA
- CELLNUMBERFORMAT
- CONTAINFORMULA
- DEFAULTPRINTER
- EXCELDIR
- FILEEXIST
- FONTINSTALLED
- FULLPATH
- ISLOCALNAME
- OS
- SHAPEHEIGHT
- SHAPEWIDTH
- SHEETNAME
- STDFONT
- STDFONTSIZE
- USER
- WINHEIGHT
- WINMAXHEIGHT
- WINMAXWIDTH
- WINWIDTH
- WORKSHEETCOUNT

Miscellaneous Functions
- ARRAYDIMENSION (for VBA)
- CREDITCARDTYPE
- SOUNDEX
- VALIDCREDITCARD