FastExcel Version 4 – with Introductory Offer

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 %

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

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

This entry was posted in arrays, Calculation, Debug formulas, Dynamic Arrays, Excel, Lookups, Memory, UDF, VBA. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s