Reporting wizard
Likeoffice Excel Utility Reporting Wizard helps you to build a useful report in one shot. It opens a new worksheet. In column A, it puts a unique list out from the column you stand in. The other columns in the new worksheet will be populated with sumif, vlookup and countif formulas. For each you may place up to three columns.
Top
|
|
Data analysis
Likeoffice Excel Utility Data Analysis counts the number of unique values in your selection (means, if you have the word “box” shown 4 times, it counts it once only). It presents the results and copy all unique cells to a new worksheet (p). It also counts fields that appear only once and fields that apear more than once. If you stand on one cell, then your range is considered to be your active column.
Top
|
|
Color idential cells
Likeoffice Excel Utility colors identical cells in selection in a the same color. Each click use different colors.
Top
|
|
Color active cell
Likeoffice Excel Utility colors all cells with the value of the active cell in one color. Every time you run it, the color is changed randomly.
Top
|
|
Compare worksheets
Likeoffice Excel Compare tool is considered the best tool to analyze differences in Excel worksheets or lists. It does comparison in all types of data, like: strings, numbers and dates. It was award prizes for its simplicity and effectiveness. It does Logical and Visual compare, providing many all types of reports.
Top
|
|
Filter Form
Likeoffice Excel Utility Filter Form does lot of qick filters like: color filter, not equal, greater/less than activecell and more
Top
|
|
Show filter
Likeoffice Excel Utility shows the Excel filtering arrows at the header of the table. It does the same as in the Excel menu: Data-Filter-Auto filter or same as CTRL 6.
Top
|
|
Filter color
Likeoffice Excel Utility filters based on the color of a cell. Stand on a certain colored cell (highlighted or font colored). It filters the same color on this column.
Top
|
|
Subtotal formula in active cell
Likeoffice Excel Utility adds a dynamic subtotal formula that sums the data below that cell. Since it is a subtotal formula, only the filtered cells are calculated. If you want to count instead of sum, replace the “9” with “3” in the formula.
Top
|
|
Convert to values
Likeoffice Excel Utility values your cells in your selection. It does the function value() for each cell.
Top
|
|
Count number of characters in activecell
Likeoffice Excel Utility counts number of characters in active cell. For example: "Excel Utility" contains 13 characters. In your Excel worksheet, it is the same like the len() function.
Top
|
|
Trim
Likeoffice Excel Utility removes unnecessary spaces before and after the phrase in a certain cell in the selection.. It actually does the trim() function (removes spaces) on each cell in the selection.
Top
|
|
Reverse text
Likeoffice Excel Utility reverses the text in each cell in your selection. For example: "Excel" becomes "lecxE" or "Vista2007" becomes "2007atsiV". It doesn't reverse the numbers though.
Top
|
|
Copy-paste values in current selection
Likeoffice Excel Utility does 'copy' and right after 'paste values' in the selected range.
Top
|
|
Is error
Likeoffice Excel Utility put iserror formula on each cell in your selection. That way, you avoid Excel mistakes like: DIV/0!, N/A and VALUE#.
Top
|
|
Rounding numbers
Likeoffice Excel Utility rounds any cell in your selection. You should set first the number of digits after the decimal point.
Top
|
|
Text only
Likeoffice Excel Utility extracts Text only in each cell in your selection. It extracts text from a varying text and number strings. Cell may starts with numbers or text. For example: "NY 10050" becomes "NY" or "12a4bcd" becomes "abcd".
Top
|
|
Numbers only
Likeoffice Excel Utility extracts Numbers only in each cell in your selection. It extracts numbers from a varying text and number strings. Cell may starts with numbers or text. For example: "NY 10050" becomes "10050" or "12a4bcd" becomes "124".
Top
|
|
Color any 2nd line
Likeoffice Excel Utility colors each second (or third or forth and so) row or column in your selected range. This ease the readability of complex large tables and text. Go to the Likeoffice menu in order to set your definitions. The icon in the Excel toolbar only executes these settings.
Top
|
|
Removing…
Likeoffice Excel Utility provides three alternatives of removing rows or cells: 1) removing empty rows in selection 2) removing duplicate cells in selection and 3) removing rows with the same fields in selection.
Top
|
|
Unhide
Likeoffice Excel Utility unhides rows and columns in active worksheet.
Top
|
|
Goto top-left screen
Likeoffice Excel Utility moves your screen and places your selection in the top-left of the screen.
Top
|
|
Save image to clipboard
Likeoffice Excel Utility copy your selection to the clipboard in a JPG format.
Top
|
|
Cells format
Likeoffice Excel Utility allows you to set four different formats to execute in one click
Top
|
|
Design header
Likeoffice Excel Utility allows you to design your header and then to have your designed header in a icon click. Go to the Likeoffice menu in order to set your definitions. The icon in the Excel toolbar only executes these settings.
Top
|
|
Worksheet view and format
Likeoffice Excel Utility allows you to design your worksheet and then to have your designed worksheet in simple icon click. Go to the Likeoffice menu in order to set your definitions. The icon in the Excel toolbar only executes these settings.
Top
|
|
Web components
Likeoffice Excel Utility Web components has the following commands: - removes hyperlinks in each cell in the selection. - activates hyperlinks in each cell in the selection - removes pictures and shapes
Top
|
|
Num format
Likeoffice Excel Utility presents numbers in the following format: "#,###;[Red](#,###)", means with comma and red for minus.
Top
|
|
Date Format
Likeoffice Excel Utility presents dates in the following format: “dd-mmm-yy” so there is no confusion for US and European date style.
Top
|
|
Another format 1
Likeoffice Excel Utility allows you to customize your format
Top
|
|
Another format 2
Likeoffice Excel Utility allows you to customize your format
Top
|
|
Delete all range in entire workbook
Likeoffice Excel Utility deletes all range names in your workbook.
Top
|
|
Define dynamic table
Likeoffice Excel Utility defines four types of ranges: 1) expand down to the last text or numeric entry in your column 2) expand down as many rows as there are entries 3) expand right to the last text or numeric entry in your row and 4) expand down and right as many rows as there are numeric and text entries. this range is a table.
Top
|
|
General information
Likeoffice Excel Utility provides summarized and useful information on your active file, worksheet and cell.
Top
|
|
Delete file properties
Likeoffice Excel Utility deletes your file properties. If you go in the Excel menu to File-Properties, the fields will be empty.
Top
|
|
Password recovery
Likeoffice Excel Utility opens password of protected worksheets and files.
Top
|
|
