After several man-years of development and a lot of beta testing FastExcel Version 4 has finally hit general availability!
FastExcel V4 is a major rewrite of FastExcel V3 and provides many of the things you have been asking for:
- Support for the new capabilities and functions of Excel 2016, 2019 and Office 365 Excel
- 50 Powerful Dynamic Array Functions
- Formula Explorer for reviewing, undestanding and debugging formulas
- VBA Performance Profiling
- Single-click Drilldown to calculation bottleneck formulas
- Check Workbook for potential problems
- Choice of Automatic or Manual Install without Admin Privileges, uses .Net 4
- Separate Ribbon Tabs for Profiler, Manager Pro and SpeedTools
- Several hundred detailed improvements
Introductory offer: 40% Discount on FastExcel V4 Bundle and FastExcel Manager Pro for Mac!
Purchase FastExcel V4 Bundle using Coupon Code FXLV4INTRO – 40% Discount Offer valid until 15 April 2020.
Purchase FastExcel V4 Manager Pro for Mac using Coupon Code FXLMACINTRO – 40% Discount Offer valid until 15 April 2020.
FastExcel V4 Profiler Improvements
-
-
Single-Click Drill-Down Wizard: One click drill-down to the slowest formulas on the slowest worksheets
-
Improved Profiling Statistics: Counts of Unique Formulas, CSE Formulas and What-If Tables
-
Improved Profiling Stability
- Changes in Excel memory managements made determining memory used by each worksheet both inaccurate and a cause of crashes. The measuring worksheet memory option has been removed.
-
Profile Formulas updated for new Excel and SpeedTools functions
-
VBA Performance Profiling
- Choose VBA Project to Profile
- Select Modules, Classes, Subroutines and Functions to Profile
- Drill Down Profiling to blocks or single statements
-
New Check Workbook Report shows for each worksheet a range of statistics on potential workbook trouble spots.
- Formulas: Counts of – Total Formulas, Unique Formulas, Error Formulas, CSE (Array) Formulas
- Counts of Data Validation and Conditional Formats
- Counts of What-If Tables, Table Onjects, Pivot Tables, Charts, Custom XML Parts, Shapes, Hyperlinks, Links, Defined Names
- Used Range, Waste % and Sparse %
-
FastExcel V4 Manager Pro Improvements
-
Manager Pro for Mac Excel 365
-
New Formula Explorer Pro – A better way of reviewing, understanding and debugging formulas
- Treeview of Formula Expressions
- Normal, Precedent or Dependent Views
- Forward and backward stepped debugging
- Fully expanded Arrays expressions
- Integrated understand of Excel functions like IF, SUMIFS, SUMPRODUCT etc
- Work with Named Formulas, Conditional Format Formulas, Data Validation Formulas
- Supports both US English and National Language formulas
-
Name Manager Pro Improvements
- Integration with Formula Explorer Pro: Review and Debug Named Formulas
- Support of Office 365 Excel
-
New Check Workbook Report
- A report for each worksheet showing a range of statistics on potential workbook trouble spots.
- Formulas: Counts of – Total Formulas, Unique Formulas, Error Formulas, CSE (Array) Formulas
- Counts of Data Validation and Conditional Formats
- Counts of What-If Tables, Table Onjects, Pivot Tables, Charts, Custom XML Parts, Shapes, Hyperlinks, Links, Defined Names
- Used Range, Waste % and Sparse %
- A report for each worksheet showing a range of statistics on potential workbook trouble spots.
FastExcel V4 SpeedTools Improvements
-
Easier formula entry with built-in Intellisense, Function Wizard and On-Line Help Support
-
100 super-fast powerful multi-threaded worksheet functions
- Advanced FILTER.IFS, ASUMIFS family of functions
- Logical AND, OR for array functions
- Advanced AVLOOKUP and AMATCH functions
-
Exploit the power of Dynamic Arrays with 50 Array-Handling functions
- Totalling for Dynamic Arrays
- Dynamically floating or static
- Columns or Rows totals
- Stack multiple Arrays/Ranges horizontally or vertically, handling headers
- Unpivot using single or multiple headers and choice of columns
- Merge (Join) dynamic arrays and find miss-matches (Anti-Join)
- Resize & Reshape Arrays
- Two-way Lookups and Slices
- Multi-Column and Multi-row Lookups
- Regular Expressions
- Totalling for Dynamic Arrays
Try it out for yourself:
Get a 15-day full-featured trial license
You can convert the trial version of FastExcel V4 to a fully licensed version at any time by purchasing one of the FastExcel V4 licensing options.
Want to know more?
View the FastExcel V4 WebHelp
Excel and UDF Performance Stuff 