Extend your MS Excel's usability with additional 200+ functions to simplify and boost it. Make it easier and faster to operate with sheets, merging cells, hide and unhide sheets, protect your data, count cells by color, benefit from batch insert and delete actions and other multiple cell operations performed with one click.
The ExtendOffice developer has released a very comprehensive add-in for MS Excel named Kutools for Excel. This handy tool includes more than 200 advanced functions that help you simplify your MS Excel tasks. The add-in is structured in groups with every group having its own functions.
You are now able to combine sheets, merge cells without losing data, paste to only visible cells or batch operations with one click in Excel. It has a pretty neat utility, Track Snap, which can take a snapshot of the current workbook at any time, a Reading Layout View which makes checking and entering data easier, and a Show Worksheets feature that toggles all hidden sheets to be visible.
Moreover, it includes features like Range Converter, which helps you process operations in ranges and cells, and Content Converter, that allows you to execute multiple conversion operations. Other Feature Groups include Editing, Formula, Security, and Filter & Statistic.
I also noticed the addition of new improvements. Most noticeable is the addition of context menu in the Navigation pane, the rename of Clear All Cells Formatting into Clear Characters Formatting and the support of hidden files and folders in the Filename List.
All in all, having numerous and well-structured features, Kutools for Excel helps MS Excel to emerge in one of the richest and complex platforms of its kind.
v23.0 [Aug 28, 2020]
- Dumbbell Plot Chart: The Dumbbell Plot chart can be used to compare two sets of data, and show the differences between them with lines in a chart.
- Progress Ring Chart: This Progress Ring Chart is commonly used to show the completion percentage of a project, with showing the completion percentage in the middle of doughnut.
- Percentage Ball Chart: The Percentage Ball Chart is commonly used to show the percentage of something occupied or remaining, or the completion percentage of a project. This chart supports to change border color, background color, and foreground color of the ball.
- Progress Bar Chart: Comparing with above Progress Ring Chart or Percentage Ball Chart can only show the completion percentage of one project, the Progress Bar Chart can show the completion percentages of multiple projects in one chart. The Progress Bar Chart can create a chart based on the given completion percentage. It also supports to create a chart based on the given actual and target values without figuring out the completion percentages in advance.
- Slope Chart: You can easily create a Slope Chart in Excel to visually show the difference between two categories at two times.
- Threshold Value Chart: The Threshold Value Chart compares the data points with a given threshold value, and show the differences between data points and the threshold value by column direction, column height, and color.
- Difference Arrow Chart: This Different Arrow Chart is similar as a clustered column or bar charts, but add arrows and percentages to show the differences between two sets of data.
- Matrix Bubble Chart: This feature helps to create a Matrix Bubble Chart with only several clicks in Excel. The matrix bubble chart represents data points by bubbles in a matrix, which is fit to compare multiple sets of data horizontally and vertically.
- Bar with Bubbles Chart: A general clustered bar chart can only show a set of data. The Bar with Bubbles Chart enhances the bar chart, and helps us show two sets of data horizontally: use bars to show one set of data in left side, and use bubbles to show the other set of data in right side.
- Difference Area Chart: The Difference Area Chart draws two lines for two sets of data, and use the filled room between the two lines to show the differences between two sets of data.
- Dot Chart: The Dot Chart uses markers to show data, which looks like the scatter chart. But this chart assigns both X and Y axes with two sets of data.
- Variable Width Column Chart: Different from normal column showing one-dimension data by column heights, the Variable Width Column Chart can show two sets of values across two dimensions by both column widths and column heights.
- Marimekko Chart: The Marimekko Chart compounds multiple stacked columns in a chart, and shows all sets of values across three dimensions.
- Lollipop Chart: The Lollipop Chart slims columns to lines, and adds colorful circles at the end of lines, which makes the point values more attractive visually.
- Multi Series Area Chart: The Multi Series Area Chart compounds multiple area graphics in one chart, and helps us easily compare multiple sets of values easily in the chart.
- Proportion Stacked Chart: The Proportion Stacked Chart can reflect the proportion of each point value in a series with small squares.
- BiDirectional Bar Chart: The BiDirectional Bar Chart places two sets of values at two sides of the Y axis, so that we can compare these two sets of values horizontally at ease.
- Multi Series Histogram Chart: This Multi Series Histogram Chart uses a set of columns to represent a set of data, and combine multiple sets of columns in one chart, so that you can easily distinguish these series.
- Copy Format to Other Charts: This feature will copy the formatting of the currently selected chart to multiple charts of the active workbook in bulk.
- Set Absolute Position of Chart: This feature will move the currently selected chart to the specified position, and resize the chart to specified range simultaneously.
- Add Sum Labels to Chart: This feature will add the sum labels for the currently selected stacked chart.
- Add Cumulative Sum to Chart: This feature will add an accumulated line with accumulated total labels for the currently selected clustered column chart.
- Move X-axis to Negative/Zero/Bottom: This feature will move the X axis to the bottom of the currently selected chart.
- Add Trend Lines to Multiple Series: This feature will add a trend line for a scatter chart which contains multiple series of data.
- Change Chart Color According to Cell Color: This feature will change the fill color of columns, bars, scatters, etc. based on the fill color of corresponding cells in the chart data range.
- Data Form: This feature shows the data in the specified range row by row. In the Data Form dialog, we can read, add, delete, or edit the data in rows.
Mall Creeps
