Ablebits Ultimate Suite for Excel Business Edition 2018.5.2232.9856 一款用於提升您的Excel辦公效率工具 AbleBits2018是一款用於提升您的Excel辦公效率工具,用於Excel2016-2007的60多種專業工具,用於日常工作。  AbleBits2018由60多種智能工具組成的系列將自動完成Excel中的大部分日常任務,並將您的工作效率提高至少50%!它擁有15年的Office開發經驗,體現在完美的解決方案代碼中,可以在所有Excel版本和所有數據集上完美運行。 Languages:English|  Withthiscollectionof60+professionaltools,youcanaccomplishanytaskimpeccablywithouterrorsordelays.It's15yearsofexperiencewithOfficedevelopmentembodiedintheperfectcodeofsolutionsthatworkflawlesslyonallExcelversionsandalldatasets. Makeyourtextdataasperfectasnumbers MicrosoftExcelisnotallaboutnumbersandformulas,butalsotext.Regrettably,itdoesn'tprovidethatmanywaysformanagingtextcontent.Luckily,UltimateSuitemakesupforthatomissionwithaselectionoflovelyutilitiestoremoveexcessspaces,getridofextrablanks,extractsubstrings,changecase,deleteorreplaceunwantedcharacters,clearformattingandconverttexttonumbers. Manageformulasandselectionswithaclick TheUltimateSuiteoffers9beautifultoolstomanageformulasandselectcellsthatmeetcertaincriteria.Usingthesefeaturesyoucanswiftlyreplaceformulaswiththeirvalues,countandsumcellsbycolor,filterbyselectedcells,recalculateranges,selectcellsofacertaintype,allwithasinglebuttonclick! Littletime-saversthatmakeabigdifference TheUltimateSuitewasdesignedtoaddresstheneedsofallusersthatworkwithExcelonadailybasis.So,whydon'tweaddafewmoretoolstomakeyourlifealittleeasierandyourworkabitmorecomfortable?Justthinkofthemasanicebonustohelpyoumanageyourworkbooks,watermarks,commentsandblanks. Combinedatafromdifferentsourcesinnotime Ifyoudealwithlargeworksheets,hundredsorthousandsofrowsineach,matchingandmergingdataisalwaysanightmare…unlessyouhaveafewspecializedwizardsatyourfingertips.Fromjoiningindividualcellstoconsolidatingmultipleworkbooks,theUltimateSuitecoversallofthemergingtasksyouperforminExcel. Sliceanddiceyourtablestheeasyway TheUltimateSuitewillrevolutionizethewayyoumanageandanalyzedatainExcel.Withtheabilitytocombineentriesfrommultiplerows,ignoringduplicatesandskippingemptycells,youcanmakeyourtablescompactandclear.Orlookatyourdatafromdifferentviewpointswithasetofsplittingtools. Elegantsolutionstoremoveduplicatesandfinduniques Duplicatesmaycrawlintoyourworksheetsinsomanyways.TheUltimateSuitedeliversthreeessentialtoolstoeliminatethem.Powerfulandversatile,theywillhelpyouquicklyfindduplicateanduniqueentrieswithinatableorcomparetwodifferentworksheets. Rearrangerangeseffortlessly DatainanExcelfilemaybearrangedinawaythatsimplydoesn'twork.Withmultipurposerangetransformationcapabilities,youcanreshapeyourworksheetsonthefly.Anumberofsimple-yet-beautifulsolutionsenableyoutotranspose,unpivot,rebuild,convert,flipandswapyourrangestoadjustthelayouttoyourliking. Fillblanksandgetrandomdatasetsinaflash Emptycellsinyourworksheetscanbetroublesome,ifnotdownrightdestructive.TheUltimateSuiteprotectstheintegrityofyourdatabyofferingaquickwaytofillblankswithvaluesfromadjacentcells,upwardsordownwards. Keepyourdataaccurate,consistentandup-to-date Maintainingdataaccuracyinlargeworksheetsisincreasinglydifficultasyourdataevolves.Butwhosaysithastobethatway?Leveragehandyat-a-glanceoptionstofindandfixbrokenlinks,fuzzymatches,typosandsimilarentries.Usetheadvancedfindcapabilitiestosearchandreplaceinseveralworkbooksatatime. UltimateSuiteFeatures: MergeandConsolidate -Mergetwotablesandaddmissingcolumnsandrows. -Matchandmergetwotablesbasedonkeycolumns. -Summarizedatafromseveralrangesintoonesheet. -Copydatafromtheselectedrangestooneworksheet. -Turnworkbookstoworksheetsandplacetheresultingsheetstoonefile. -Combineidenticallynamedworksheetsintoone. -Copytheselectedworksheetstooneworkbook. -Mergetheselectedrowsorcolumns. -Joinseveralcellskeepingalldata. DedupeandCompare -Comparetwotablesforduplicateanduniquevalues. -Finduniquevaluesinonetable. -Findanddelete,select,color,copyormoveduplicatesinoneExceltable. -Findandprocessduplicatesandtheir1stoccurrences. CombineandSplit -Combineduplicaterowsandpasteuniquedatatooneline. -Splitabigtableintoseparatelistsbyvaluesintheselectedcolumn. -Splitmulti-partnamesintoseveralcolumns. TransformandReshape -Convertsummarytabletoaflatlist. -Transformyourtableintolabelcards. -Swaptworangesinyoursheetorworkbook. -Fliptheselectedrangeverticallyorhorizontally. -Convertrowstocolumnsandviceversa. RandomizeandFill -Generateuniquerandomnumbers. -GetrandomdatesandBooleans. -Savecustomlistswithvaluestogetrandomdatafromthem. -Generatestrongpasswords,codes,andtestingdata. -Shufflecellsinrows,columns,orintheselectedrange. -Selectcertainnumberorpercentageofdataatrandom. -Fillemptycellswithvalueaboveorbelow. FindandCheck -Findpartialduplicates,typosandmisspelledwords. -Searchandreplacedatainvalues,formulas,hyperlinks,andcomments. -Searchandexportorselectthefoundvalues. -Findandfixbrokenreferencestootherworkbooks. TrimandClean -Trimextraleading,trailing,in-betweenspaces,and . -Addtexttotheselectedcellsbyposition. -Splitacolumnwithtexttoseveralcolumns. -ChangetextcaseinyourExceltable. -Convertnumbersstoredastexttonumbers. -Extracttext. -Removecharactersbyposition. -Clearformattinginyourtable. -Removenon-printing,numeric,textcharacters,symbolsandpunctuationmarks. -Convertlinebreakandothercharacterstoanycustomsymbol. SelectandCalculate -Countandsumcellsbasedontheircolor. -Selectcertaincolortocountorsumcells. -ApplyAverage/Max/Minfunctionstothecoloreddata. -Selectcellsbytype. -Selectcellsbyvalue. -Keepthesameselectionwhenswitchingbetweensheets. -Selectanyvalueinyourlisttofilteryourtable. -Searchcellsbasedontheirvalueorcolor. -Applybasiccalculationstotheselectedcells. QuickUtilities -Deleteemptyrows,columnsandsheets. -Seeallopenworkbooksandsheetsononepane. -Instantlymovecolumnsinyourtable. -InsertawatermarkinExcel -AddaTableofContents -GetcellorrangeaddresstoClipboard. -Convertformulastorelativeorabsolute. -Insertapicturecommentin2clicks. -Changeacommentshape. -Managecomments. -Replaceformulaswithvalues. ReleaseNotes: SupportedWindowsversions: -Windows10 -Windows8.1 -Windows8 -Windows7 -32-bitand64-bit SupportedExcelversions: -Excel2019 -Excel2016 -Excel2013 -Excel2010 -Excel2007 -32-bitand64-bit -DesktopExcelincludedinOffice365/Office365ProPlus Homepage https://www.ablebits.com