Home
/ Business > Business Finance (13 files) > Legal (10 files) > Online Auction Tools (14 files) > Personal Finance (17 files) > Spam Filters (30 files) > Spreadsheets (21 files) > Taxes (10 files) > Word Processing (26 files)
Advanced Excel Add-ins & Tips Click here to Download | Product Home Page | More downloads from Data Instrument Group Size: 1.5MB Version: v6.3 Date Updated: 11/12/2004 9:02:13 AM License: 15 day trial, $69 to buy Description:
- Sort by many ( >3) levels
- Special sort by cell characters count, color, font style, text value
- Random sort
Table Column(s) Add-ins
- Append value(s) before or after
- Trim spaces
Combine columns
- Split column by delimitor or length
- Count cell characters
- Shift Column(s), Hide/UnHide
Mix & Match for all Combinations
- Mix multiple sets of cells, create a list of all possible combinations
Convert Date, Type, Case ...
- Date value to Weekday, Month, Qtr, Year, Hour
- Data type to Text or General
- Convert to Upper/Lower Case
- Only 1st character to upper case
- Cross Table to List
Extract - Emails, Filters, Subtotal...
- Extract valid email addresses
- Extract results in filter, subtotal
Do Access in Excel
- Complex query; Join; Aggregate
Find & Remove Duplicates - Dedupe
- Match one table against another
- Filter uniques by key field(s)
Join (Merge) Tables
- by Column(s) Match
- by Column(s) (fuzzy) Match
Match Tables Add-ins
- Match by one or multiple columns
- Filter for matched or unmatched
Append / Split Table
- Auto-select & Append all tables to form a master list
- Append by matching fields
- Split by values in column(s)
- Split by number of rows
Act by Row Intervals
- Insert, delete, copy, select by row intervals
Fill Add-ins
- Fill scattered blank cells
- Fill random values
- By boundries, linear series
Delete Rows / Columns
- Delete blank, hidden, or visible
- Delete rows by intervals
File Links Add-ins
- Break broken links, clean up link error
Power User Tips
- 1st-visit to 1st-buy analysis
- Count unique
- Join, Multi-level Sorting, ...
Audiovox FPE1506DV 15 in. LCD TV TV/DVD Combo Products
 |
 |
|
|
|