Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Share Post: Reddit Facebook
Promo2day Review kutools for Excel: more than 200 advanced tools
#1
If you are tired of merging worksheets one by one, or frustrated by all kinds of complicated tasks in Excel, Kutools for Excel is the handy tool for you to simplify complicated tasks into a few clicks. It enhances and adds more than 200 advanced functions for you to easily cope with various kinds of tasks in Excel. For example, you can combine sheets quickly, merge cells without losing data, paste to only visible cells, count cells by color, batch operations with one click in Excel and so on. Kutools for Excel is undoubtedly an incredible handy add-in which will save your time and effort.

Homepage:

https://www.extendoffice.com/product/kut...excel.html

Download:

https://www.extendoffice.com/download/ku...excel.html

OR

https://www.cdn.extendoffice.com/downloa...lSetup.exe

Purchase:

https://www.extendoffice.com/order/kutoo...excel.html

The price of single license is 39 USD.

You will get:

Lifetime license with Free Upgrade and Support for 2 Years.
60-Day Money Back Guarantee.
24x7 Email Support Service.

Activate your license using name and key sent to your email after purchase:

[Image: LMHX2Ro.png]

Advantages and Highlights:

Increase your productivity in 5 minutes.
Don't need any special skills, save two hours every day.
Free trial 60 days, no credit card required, full version, full features.
More than 200 powerful advanced functions which designed for Excel:
Merge Cell/Rows/Columns without Losing Data.
Combine and Consolidate Multiple Sheets and Workbooks.
Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
Count by Colors, Paging Subtotals, Advanced Sort and Super Filter.
More Select / Insert / Delete / Text / Format / Link / Comment / Workbooks / Worksheets Tools...

System Requirements:

Size: 35.90 MB ~ 64.30 MB 
Office: Excel/Office 2007, 2010, 2013, 2016 and 365, 32 bit and 64 bit.
Windows: Windows 7/8/8.1/10, XP, Vista, Server 2003, 2008 and 2012.

[Image: HcyXjjX.png]

Current version:  18.0

Date:      August 15, 2018  
           
Installation:

[Image: VebBjJq.png]

[Image: fkrF98u.png]

[Image: s9HjzAm.gif]

After you download the setup file, you need to uninstall the previous version and double click the installer then follow simple on-screen instructions to have the program on your computer

Free Trial:

The program offers free trial for 60 days with full functions and feature, 
After purchase; you will have 2 years free upgrade period, you are entitled to free upgrade this version.

Check for updates:

[Image: H71zaJu.png]

What are the new features in version 18?

https://www.extendoffice.com/forum/kutoo...notes.html

Super Find: 

[Image: Z00d1MK.png]

This powerful utility improves the Find function of Excel, it can help you to find and select the cells that matched a specific condition in text strings, comments, formulas, hyperlinks, cell values, and dates. It can find the cells with specific cell formatting as well. This feature can be applied in a selected range of cells, active worksheet, selected worksheets, whole workbook and all opened workbooks.
Find and select specific cells in text strings, comments, formulas, hyperlinks, cell values, find and select specific date cells, find and select cells with specific cell formatting
With this option, you can quickly find and select all cells with specific formatting, such as bold cells, italic cells, merged cells, cells with comment and so on…

Fuzzy Lookup:
In Excel worksheet, entering a list of same text manually may contain some typos, with this feature, you can quickly check for the similar records based on character differences, and then correct them to your own text at once. 

Improvements

Super Filter:

[Image: RFY9BMl.png]

Support some new operations for this utility such as improve the condition edit box by adding an OK command button, insert refresh option in this latest version and collect all toolbar features into one drop-down menu

Create Mailing List / Send Emails:

[Image: ov2PfgA.png]

Support Cc and Bcc when creating a mailing list and sending emails
Support multiple attachments to be inserted into one cell without number limitation while creating a mailing list
Support to insert pictures of the local disk when editing message body
Add right-click menu in the edit message box
Support to save the sent emails to a local folder in SMTP sent mode
Support to set interval time when sending multiple emails.
Add a scenario manager for adding and managing multiple email accounts in SMTP sent mode
A new status column is created to determine if the email sent successfully in SMTP sent mode
 
Reading Layout:
Add Highlight the area of active cell option in the Reading Layout Settings dialog box, the active cell will not be highlighted by un-checking it. 

Insert Random Data:
It supports to insert decimal numbers now

Insert Watermark:
Support to insert the image watermark based on the picture scale;
Support the preview feature in Insert Watermark dialog box.

Column list:
Columns can be rearranged by clicking the move Up or Down arrows in the toolbar; or by dragging the column record in the Column list pane.

Fixed:
Matching pictures can only be imported once each time when there are duplicate cell values in the Match Import Pictures utility.
A warning prompt box is always popped out if the first character is not ? character when typing a formula under Custom option in the Operation utility.
The filter result is not correct if there are error values in the filter range of cells when applying the Super Filter feature.

Tutorials:

https://www.extendoffice.com/product/kut...rials.html

Previous releases:

https://www.extendoffice.com/support/lat...excel.html

Features and Tools in the program:

[Image: 8PP7Y04.png]

[Image: We3sWpA.png]

The program has more than 200 tools which are divided in two buttons; kutools and kutools plus. If you are not sure about the function of any tool; simply hover the mouse over the button and a window will pop up showing you the features of this tool

[Image: JpYZLIe.png]

Utilities locating in the Kutools tab:

[Image: PtUy27S.gif]

View group:

Track Snap to take snapshots of the current workbook, Navigation Pane, work area size, reading layout, show columns and worksheets, Show / Hide offers a collection of tools allow you to quickly show or hide the workbooks, worksheets and ranges.

[Image: aHdmrAn.png]

Range and cell group:

Range Converter button offers a collection of utilities allow you to quickly process many operations in ranges and cells as merge, unmerge, flap horizontal and vertical, transform, swap ranges and sort random

[Image: AtHnzHE.png]

Compare ranges: With this utility, you can quickly compare two ranges and select the same / duplicate cells or entire rows, different / unique cells or entire rows.
Prevent duplicates in a single column with one click similar to data validation feature of excel
Copy ranges lets you copy multiple selected ranges at once.
Content converter is a collection of tools allow you to you to quickly convert between various forms. Combine data from multiple columns (or rows) into a single cell.

[Image: 4CwBi4c.png]

Editing group:

Select Tools (a collection of tools make the selection of various items easier in Excel), insert tools, delete tools, text tools, format tools, link tools and more

Select:

[Image: shvPXZ2.png]

Insert:

[Image: jXYLJY1.png]

Delete:

[Image: hzmnX4A.png]

Format:

[Image: ExwtIaq.png]

Text:

[Image: TGouzTu.png]

More:

[Image: oTiH3QU.png]

Kutools functions:

The built-in functions of kutools will help you easily and quickly handle various operations

[Image: WR0JrhC.png]

Formula Group:

Formula helper; you will not need to remember how to create the formula with this tool

[Image: ajXwSOA.png]

Exact copy tool lets you easily copy all the formulas without adjusting the relative cell references.
Convert refers lets you convert the notation of references to cells in the formulas in your selected range
More tools for handling formulas in Excel.

[Image: txY89V7.png]

Utilities locating in the Kutools Plus tab:

[Image: kJRM4Mi.png]

Workbook and sheets; these include workbook and worksheet tools with a collection of tools in each button. Combine and split data, import and export data and printing options

[Image: INfGlH1.png]

[Image: NKZbteJ.png]

[Image: udFU9xk.png]

[Image: YstBnD0.png]

Security groups: these include encrypt and decrypt cells and password protect or unprotect worksheets

[Image: 7Hgqc6Y.png]

Mailing: send emails and create mailing list

[Image: XVLJ7Dv.png]

Filter and statistic group: these include the ability to count by color, paging subtotal, advanced sort and superfilter

[Image: QW7qoBh.png]

Re-run Last Utility:

Quickly apply the utility of Kutools for Excel you have just launched before with one click.

Help information

[Image: v07mRqO.png]

Detailed information about Kutools for Excel.

Setting Center:

[Image: BeAravH.gif]

It includes the following Settings

Disable or enable the Kutools add-in for Excel.
Clear configurations and caches of this add-in.
Set the language of software.
Check the user's registration information.

Register:

If you have purchased a license, you can register the software here, or you can click on the "Purchase" button to purchase license from the official website.

About:

Displays detailed information about Kutools for Excel, such as version, license information and so on.

Sharing Tips and Tutorials for Excel:

https://www.extendoffice.com/documents/excel.html

Kutools For Excel Feature Tutorials:

https://www.extendoffice.com/product/kut...rials.html

Language Files for Translation:

https://www.extendoffice.com/support/tra...excel.html

News and Updates of Kutools For Excel:

https://www.extendoffice.com/support/lat...excel.html

Conclusion:

Kutools for Excel is a very powerful add-in application that helps you to easily and quickly do various operations not supported by Excel built-in functions. You can easily use many formulas with no need to remember how to create. The program will help you, increase your productivity and save your time. The website contains illustrated detailed steps for all features and tools. The current version 18 shows many new handy features and enhanced improvements. You can download and try the program all features for 60 days
Reply


Messages In This Thread
kutools for Excel: more than 200 advanced tools - by tarekma7 - 08-31-2018 , 09:31 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Daemon Tools Pro 6 Advanced Ver. 6.2 Review Mike 0 3,790 10-09-2015 , 11:14 AM
Last Post: Mike

Forum Jump:


Users browsing this thread: 1 Guest(s)