Add On Ultimate Suite for Excel (Tools Keren Mempermudah Ms. Excell)
Tentang Tools
hai Gaes tau gak sih ternyata begitu banyak add-on untuk Microsift Office, nah fungsi utama dari addon ini adlah untuk mempermudah pekerjaan kita. dikarenakan fitu dari standar aplikasi itu sendiri kurang atau tidk ada maka terciptalah add-on. nah kesempatan kali ini saya akan sshare add-on untuk microsoft excell tentunya full versi.
Ultimate Suite for Excel adalah kumpulan 60+ alat cerdas untuk Excel yang menyediakan cara sederhana yang luar biasa untuk mengatasi berbagai tantangan kompleks. Alat-alat ini akan menghemat waktu Anda dan Anda akan menemukan kegunaan baru setiap hari. Dengan koleksi 60+ alat profesional ini, Anda dapat menyelesaikan tugas apa pun dengan sempurna tanpa kesalahan atau penundaan. Ini adalah pengalaman 15 tahun dengan pengembangan Office yang diwujudkan dalam kode solusi sempurna yang bekerja dengan sempurna di semua versi Excel dan semua kumpulan data.
Features and Highlights
Merge and Consolidate
- Match and merge two tables based on key columns.
- Merge two tables and add missing columns and rows.
- Summarize data from several ranges into one sheet.
- Copy data from the selected ranges to one worksheet.
- Turn workbooks into worksheets and place the resulting sheets in one file.
- Copy the selected worksheets to one workbook.
- Merge the selected rows or columns.
- Join several cells keeping all data.
- Combine identically named worksheets into one.
Combine and Split
- Combine duplicate rows and paste unique data into one line.
- Split a big table into separate lists by values in the selected column.
- Split multi-part names into several columns.
Dedupe and Compare
- Find and delete duplicates in one Excel table.
- Find and process duplicates and their 1st occurrences.
- Find unique values in one table.
- Find and delete, select, color, copy or move duplicate or unique values.
- Compare two tables for duplicate and unique values.
Transform and Reshape
- Convert summary table to a flat list.
- Transform your table into label cards.
- Swap two ranges in your sheet or workbook.
- Flip the selected range vertically or horizontally.
- Convert rows to columns and vice versa.
Randomize and Fill
- Generate unique random numbers.
- Get random dates and Booleans.
- Save custom lists with values to get random data from them.
- Generate strong passwords, codes, and testing data.
- Shuffle cells in rows, columns, or in the selected range.
- Select a certain number or percentage of data at random.
- Fill empty cells with values above or below.
Find and Check
- Find partial duplicates, typos, and misspelled words.
- Search and replace data in values, formulas, hyperlinks, and comments.
- Search and export or select the found values.
- Find and fix broken references to other workbooks.
Trim and Clean
- Trim extra leading, trailing, in-between spaces, and.
- Add text to the selected cells by position.
- Split a column with text into several columns.
- Change the text case in your Excel table.
- Convert numbers stored as text to numbers.
- Remove characters by position.
- Clear formatting in your table.
- Remove non-printing, numeric, text characters, symbols, and punctuation marks.
Select and Calculate
- Count and sum cells based on their color.
- Select certain color to count or sum cells.
- Apply Average/Max/Min functions to the colored data.
- Select cells by type.
- Select cells by value.
- Keep the same selection when switching between sheets.
- Select any value in your list to filter your table.
- Search cells based on their value or color.
- Apply basic calculations to the selected cells.
Quick Utilities
- Delete empty rows, columns, and sheets.
- See all open workbooks and sheets on one pane.
- Instantly move columns in your table.
- Get cell or range address to Clipboard.
- Replace formulas with values.
- Convert formulas to relative or absolute.
- Insert a picture comment in 2
Download Link