FastExcel V4 - Whats New for FastExcel V3 Users
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
Upgrade offer: 30% Discount on any FastExcel V4 purchase for holders of a valid FastExcel V3 license!
FastExcel V4 Profiler Improvements
-
Single-Click Drill-Down Wizard
- One click drill-down to the slowesr 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 workheet 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
- 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 %
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 %
FastExcel V4 SpeedTools Improvements
-
Easier formula entry with built-in Intellisense, Function Wizard and On-Line Help Support
-
100 superfast 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
Try it out for yourself:
Download FastExcel V4.
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
|
