Good news! Kutools for Excel 22.00 is coming with dozens of new handy features and excellent improvements! You can upgrade to or have a free trial of this version by downloading Kutools for Excel 22.00 . Tip: full function & feature, free trial in 30 days! If the 2-year free upgrade support period is not expired, you are entitled to free upgrade this version.
New features
1.Step Chart
The Step Chart feature can show the data trend at irregular intervals in a chart based on the specified horizontal (category) axis labels and series values in Excel.
2.Target and Actual Chart
The Target and Actual Chart feature can compare the target values and the actual values in a chart. It can compare one or multiple sets of data series in a chart, and show the actual values in the style of lines or columns as well.
3.Bullet Chart
The Bullet Chart feature can help you quickly compare the actual value, target value, and qualitative ranges of performances (says poor, average, and good, etc.) horizontally or vertically. It also supports to compare several sets of data series too.
Vertical bullet chart:
Horizontal bullet chart:
4.Thermometer Chart
The Thermometer Chart feature can help you easily compare the current value and the target value. And this feature supports to show the vertical axis as percentage.
5.Gantt Chart
With this Gantt Chart feature, you can quickly create a Gantt chart with specifying the tasks, start dates, and end dates (or durations) in Excel.
6.Timeline Chart
This Timeline Chart feature enables you to easily create a timeline chart with only 3 steps in Excel, and display the chronological sequence of past or future events on the timescale.
7.Color Grouping Chart
This Color Grouping Chart feature can create a column or bar chart, and change fill color for special data points (columns or bars) based on the specified grouping ranges.
8.Comparison Bar Chart
This Comparison Bar Chart feature can help you quickly compare two sets of series values, and show the differences of two sets of series values in a bar chart. This feature also supports to show the differences with arrows instead of bars.
9.Column Chart with Percentage Change
Comparing to normal column charts, this Column Chart with Percentage Change feature can help you create a column chart and mark the changes between every two adjacent columns with green rising arrow or red declining arrow.
10. Stacked Chart with Percentage
This Stacked Chart with Percentage feature can not only create a stacked column chart, but also add data label as percentage for every data point.
11. Color Chart by Value
With this Color Chart by Value feature, you can easily change the fill color of data points based on the specified data range. This feature works well with the clustered column charts and clustered bar charts in Excel.
12. Add Line to Chart
This Add Line to Chart feature can quickly add an average line or a line based on a specified value to the selected chart.
13.Create Simple Drop-down List
This Create Simple Drop-down List feature simplifies the process of creating a drop-down list by Excel’s built-in feature, and enables you to get it done with only two steps.
14. Date & Time Helper
With this Date & Time Helper feature, you can easily add or subtract years, months, weeks, days, hours, minutes, or seconds from a date/time, and calculate age, date difference, or time difference between two dates/time.
15. Share to
Kutools for Excel 22.00 supports to share the whole add-in or a certain feature to friends via email, Facebook, Twitter, Linkedin, and Weibo.
16. Feedback
Kutools for Excel 22.00 supports users to submit suggestions and operation errors to our developing team directly.
Improvements
1.Formula Helper
The Formula Helper is improved greatly to help users filter, find, and apply the formulas easily.
1.1 Formulas are grouped into 5 categories: Date & Time, Statistical, Text, Lookup & Reference, and Math & Trig.
1.2 Add 15 new formulas:
1)Count days, hours and minutes between dates
2)Convert days to year month day
3)Convert seconds to hh:mm:ss time format
4)Count cells equal to A, B or C
5)Count cells with two conditions (and)
6)Count unique values
7)Count cells with unique values (include the first duplicate value)
8)Count the number of values separated by comma
9)Extract the nth word in cell
10)Extract unique values
11)Extract cells with unique values (include the first duplicate value)
12)Extract strings between specified text
13)Index and math on multiple columns
14)Find the largest value less than
15)SUMPRODUCT with criteria
1.3 Supports to filter formulas in the Formulas Helper dialog.
2.Dependent Drop-down List
The Dependent Drop-down List feature supports create 2-levels dependent drop-down lists in horizontal direction.
3.Multi-select Drop-down List
When opening the Multi-select Drop-down List dialog, it will automatically specify the same Apply to settings as you configured last time.
4.Drop-down List with Check Boxes
1)When opening the Drop-down List with Check Boxes Settings dialog, it will automatically reuse the Apply to settings you configured last time.
2)Uses two different interfaces for the Modify mode and Append mode.
3)Supports to change the size of drop-down list form by dragging.
5. Beautify the Normal Distribution / Bell Curve chart.
6. The Combine Worksheets feature supports OneDrive files and folders.
7. The Super Filter feature optimizes the loading efficiency of scenarios.
8. Change the language calling way, and speed up the display of forms.
9. Adjust positions of some features on the Ribbon, and change some feature names and super tips.
10.Optimize and improve other features.
Fixed
1. Fixed: The Speedometer Chart doesn’t support customizing fill color.
2. Fixed: The Exact Copy feature cannot copy formulas in some situations.
3. Fixed: If there is no active window, errors occur when clicking the Toggle to unhide/hide all hidden worksheets button on the Navigation Pane.
4. Fixed: Errors occur when applying the Drop-down List with Check Boxes feature to merged cells.
5. Super Filter:
1)Fixed: The new added sub-condition groups cannot display.
2)Fixed: After saving filter scenarios, the scenarios lost when switching worksheets.
6. Fixed: Kutools may cause the welcome screen to disappear in the latest Office 365.
7. Fixed: other minor bugs.
New features
1.Step Chart
The Step Chart feature can show the data trend at irregular intervals in a chart based on the specified horizontal (category) axis labels and series values in Excel.
2.Target and Actual Chart
The Target and Actual Chart feature can compare the target values and the actual values in a chart. It can compare one or multiple sets of data series in a chart, and show the actual values in the style of lines or columns as well.
3.Bullet Chart
The Bullet Chart feature can help you quickly compare the actual value, target value, and qualitative ranges of performances (says poor, average, and good, etc.) horizontally or vertically. It also supports to compare several sets of data series too.
Vertical bullet chart:
Horizontal bullet chart:
4.Thermometer Chart
The Thermometer Chart feature can help you easily compare the current value and the target value. And this feature supports to show the vertical axis as percentage.
5.Gantt Chart
With this Gantt Chart feature, you can quickly create a Gantt chart with specifying the tasks, start dates, and end dates (or durations) in Excel.
6.Timeline Chart
This Timeline Chart feature enables you to easily create a timeline chart with only 3 steps in Excel, and display the chronological sequence of past or future events on the timescale.
7.Color Grouping Chart
This Color Grouping Chart feature can create a column or bar chart, and change fill color for special data points (columns or bars) based on the specified grouping ranges.
8.Comparison Bar Chart
This Comparison Bar Chart feature can help you quickly compare two sets of series values, and show the differences of two sets of series values in a bar chart. This feature also supports to show the differences with arrows instead of bars.
9.Column Chart with Percentage Change
Comparing to normal column charts, this Column Chart with Percentage Change feature can help you create a column chart and mark the changes between every two adjacent columns with green rising arrow or red declining arrow.
10. Stacked Chart with Percentage
This Stacked Chart with Percentage feature can not only create a stacked column chart, but also add data label as percentage for every data point.
11. Color Chart by Value
With this Color Chart by Value feature, you can easily change the fill color of data points based on the specified data range. This feature works well with the clustered column charts and clustered bar charts in Excel.
12. Add Line to Chart
This Add Line to Chart feature can quickly add an average line or a line based on a specified value to the selected chart.
13.Create Simple Drop-down List
This Create Simple Drop-down List feature simplifies the process of creating a drop-down list by Excel’s built-in feature, and enables you to get it done with only two steps.
14. Date & Time Helper
With this Date & Time Helper feature, you can easily add or subtract years, months, weeks, days, hours, minutes, or seconds from a date/time, and calculate age, date difference, or time difference between two dates/time.
15. Share to
Kutools for Excel 22.00 supports to share the whole add-in or a certain feature to friends via email, Facebook, Twitter, Linkedin, and Weibo.
- Click Kutools > Share to to share Kutools for Excel to friends.[/*]
- Enable a feature, says Navigation Pane, then click the Share button to only share this feature to friends.[/*]
16. Feedback
Kutools for Excel 22.00 supports users to submit suggestions and operation errors to our developing team directly.
Improvements
1.Formula Helper
The Formula Helper is improved greatly to help users filter, find, and apply the formulas easily.
1.1 Formulas are grouped into 5 categories: Date & Time, Statistical, Text, Lookup & Reference, and Math & Trig.
1.2 Add 15 new formulas:
1)Count days, hours and minutes between dates
2)Convert days to year month day
3)Convert seconds to hh:mm:ss time format
4)Count cells equal to A, B or C
5)Count cells with two conditions (and)
6)Count unique values
7)Count cells with unique values (include the first duplicate value)
8)Count the number of values separated by comma
9)Extract the nth word in cell
10)Extract unique values
11)Extract cells with unique values (include the first duplicate value)
12)Extract strings between specified text
13)Index and math on multiple columns
14)Find the largest value less than
15)SUMPRODUCT with criteria
1.3 Supports to filter formulas in the Formulas Helper dialog.
2.Dependent Drop-down List
The Dependent Drop-down List feature supports create 2-levels dependent drop-down lists in horizontal direction.
3.Multi-select Drop-down List
When opening the Multi-select Drop-down List dialog, it will automatically specify the same Apply to settings as you configured last time.
4.Drop-down List with Check Boxes
1)When opening the Drop-down List with Check Boxes Settings dialog, it will automatically reuse the Apply to settings you configured last time.
2)Uses two different interfaces for the Modify mode and Append mode.
3)Supports to change the size of drop-down list form by dragging.
5. Beautify the Normal Distribution / Bell Curve chart.
6. The Combine Worksheets feature supports OneDrive files and folders.
7. The Super Filter feature optimizes the loading efficiency of scenarios.
8. Change the language calling way, and speed up the display of forms.
9. Adjust positions of some features on the Ribbon, and change some feature names and super tips.
10.Optimize and improve other features.
Fixed
1. Fixed: The Speedometer Chart doesn’t support customizing fill color.
2. Fixed: The Exact Copy feature cannot copy formulas in some situations.
3. Fixed: If there is no active window, errors occur when clicking the Toggle to unhide/hide all hidden worksheets button on the Navigation Pane.
4. Fixed: Errors occur when applying the Drop-down List with Check Boxes feature to merged cells.
5. Super Filter:
1)Fixed: The new added sub-condition groups cannot display.
2)Fixed: After saving filter scenarios, the scenarios lost when switching worksheets.
6. Fixed: Kutools may cause the welcome screen to disappear in the latest Office 365.
7. Fixed: other minor bugs.
There are no replies made for this post yet.