Macabacus for Microsoft Office v8.9.20.0 註冊版-Office增強插件 MacabacusforMicrosoftOffice是為Office用戶打造的一款增強插件，這款插件包含了實用的公式，免去了手工輸入公式符號進行計算的麻煩，特別是一些不常用的公式，手工輸入的十分麻煩，支持Office2010、Office2013、Office2016等版本，除此之外，還擁有將表格中的單元格和圖表導出到ppt和word中的功能，可以大大提高辦公效率。 Macabacus功能 一、公式審計 –輕鬆導航公式的工作表和工作簿輸入，只使用鍵盤 –同樣地導航一個單元格的依賴項，向您展示審計單元格正在駕駛的公式和圖表 –使用基於樹的導航深入研究先例/家屬，以幫助您瞭解驅動公式的所有內容 –逐個分析複雜的公式以查看公式的一部分對整體結果的貢獻 –可視化突出顯示了公式錯誤，異常值和其他不一致的地方，否則這些不一致可能會被忽視 –查看先例/依賴者一次或多次導航單元格時會跟蹤多個單元格的箭頭 二、議程(目錄) –無縫地將議程幻燈片與原生PowerPoint部分同步 –與PowerPoint部分深度集成，使您的議程隨著部分的添加，刪除，移動或重命名而保持最新 –支持這兩種議程樣式–在(a)目錄幻燈片上顯示議程，或(b)flysheets(每個部分開始時的分隔幻燈片) –在議程變更時自動更新的內容幻燈片上顯示部分/小節標題 –智能摺疊子部分以適應更多議程主題到單個幻燈片並提高可讀性 –智能省略部分flysheets減少演示文稿的長度和打印成本 –智能地避免在幻燈片放映過程中顯示背對背的傳票 –在您的目錄中包含幻燈片標題或其他文字 –完全可定製的議程/表單外觀 三、從EXCEL導出 –將單元格和圖表導出為PowerPoint和Word，作為圖片，嵌入式工作簿，表格，圖表等 –隱藏Excel界面元素–藍色打印預覽邊框，紅色單元格評論指示器，網格線等–自動重新著色字體以獲得更專業的輸出 –自動檢查導出數據中的配方錯誤，從而避免在演示文稿和文檔中出現令人尷尬的錯誤 –導入的形狀(例如，圖片，表格)智能定位和尺寸，避免了本地粘貼形狀所需的繁瑣調整 四、演示文稿打樣 –在向客戶發送演示文稿或打印之前，請檢查幻燈片的格式，佈局，內容和語法錯誤和不一致之處 –改進對您的企業設計標準和品牌的遵守 –超過100次檢查不一致的單詞連字和縮寫，缺少腳註，調色板偏差，不正確的子彈格式，缺少標點符號，缺少圖表標籤，圖像失真等問題 –與其他解決方案不同，Macabacus檢查圖表和智能藝術 –確切地查看問題的位置，問題的詳細解釋以及發現不一致情況的發生頻率 –使用定製的修復菜單來解決問題，該修補程序會突出顯示演示文稿中的主導約定，以幫助您選擇修補程序 –一次性為整個演示文稿設置校對語言，以修復標記為拼寫錯誤的文字，這些文字顯然不是 五、鏈接到EXCEL –將Excel中的單元格和圖錶鏈接到PowerPoint/Word中的形狀和文本，並通過單擊按鈕來更新鏈接 –與本地Office鏈接不同，當您的源電子表格結構發生變化時，Macabacus鏈接不會中斷，這一點肯定會發生 –相對於本地Office鏈接所需的嵌入工作簿，演示文稿/文檔的文件大小減少 –使用PowerPoint和Word中的內嵌文本鏈接，您可以編寫帶有易於更新的電子表格中的圖形的段落 –版本控制有助於在更新鏈接時識別更新版本的源文件，並推薦重新鏈接選項 –自動鏈接檢測支持使用Dropbox等服務在雲中共享的文件 六、高級圖表 –輕鬆創建複雜的財務和諮詢圖表，包括瀑布，足球場，蝴蝶和Marimekko圖表 –從預先填充虛擬數據的Macabacus庫中插入圖表，而不用考慮複雜的圖表數據結構 –將增長率(CAGR)箭頭添加到更新為圖表數據更改的列圖表中。廣泛的格式選項為您提供所需的精確外觀 –輕鬆地在堆疊柱狀圖中的列上方添加總計標籤 –只需點擊兩次鼠標，就可以將圖表中的數據系列重新著色成您喜歡的顏色 –堆疊圖表可以創建儀表板，並一次快速確定多個圖表的圖表/繪圖區域的大小和位置 –更有效地處理數據標籤 –用Macabacus創建的圖表是100%原生的–你不需要Macabacus來處理它們 –減少圖形專業人員為內部客戶創建和修改圖表所花費的時間 七、共享庫 –共享庫加快了準備過程並促進了演示文稿，電子表格和文檔的標準化 –圖書館內容可以包括幻燈片(如團隊頁面)，辦公室形狀(如圖標)，圖像(如客戶端徽標)，圖表和交易墓碑 –庫模板可以包括演示文稿模板，電子表格模板(用於構建新模型時的起點)和文檔模板(例如傳真封面) –從庫中插入的幻燈片會被鏈接，並且可以通過單擊按鈕將其更新為庫中的最新版本 –類似Google的文本搜索會立即返回匹配的內容 –創建“文檔組”以按業務單位或任何其他類別對發佈的模板進行分類 –Macabacus支持3個圖書館–供個人使用的個人圖書館，以及可以共享的團隊和公司圖書館 –本地緩存遠程庫的可用性脫機 –需要管理權限才能修改公司庫 八、定製 –配置Macabacus設置–顏色，字體，模板等–以反映貴公司的品牌標識和設計標準 –自定義許多非格式相關工具的行為以反映個人或組織工作流偏好 –為所有用戶部署自定義設置，以使Office文檔的外觀符合單一標準，並為所有用戶標準化Macabacus體驗 –將設置保存到雲中，以便在所有設備上保持一致 –使用我們的定製服務加快部署(額外成本)，將您的設計標準轉換為Macabacus設置 九、兼容性： –Macabacus適用於Windows10-Windows7(32位和64位)的MicrosoftOffice2016-2010桌面安裝(32位和64位)。 Theleadingproductivityadd-insforExcel,PowerPoint,andWord.Themostcompleteandhighest-qualitysuiteofMicrosoft.Officeproductivityadd-insforfinanceandotherprofessionals. BuildFinancialModels&PresentationsMoreEfficiently –80%+TimeSavingsforRoutineTasks –PowerModelingTools –AdvancedFormula –Auditing –ChartingTools –DozensofKeyboard –Shortcuts –ReliablyLinktoExcel –TableofContents/ –AgendaAutomation –CheckPresentationsforMistakes –SharedContent& –TemplateLibraries –Find&Navigate –MoreEasily –WorkbookOptimization –ExtensiveCustomization –EnterpriseDeployment Reducemistakeswithourpowerful,best-in-classauditingtools—absolutelyessentialforpowerusers –Effortlesslynavigateaformula’sinputsacrossworksheetsandworkbooks,usingonlythekeyboard –Similarlynavigateacell’sdependents,showingyouwhatformulasandchartstheauditedcellisdriving –Drilldownonprecedents/dependentsusingtree-basednavigationtohelpyouunderstandeverythingdrivingyourformulas –Analyzecomplexformulaspiece-by-piecetoseewhataportionoftheformulacontributestotheoverallresult –Visualizationshighlightformulaerrors,outliers,andotherinconsistenciesthatmightotherwisegounnoticed –Viewprecedents/dependentstracearrowsformultiplecellsatonceorasyounavigatecells Keepyourpresentationagendasupdatedsothatyoucanfocusoncontent –SynchronizeagendaslideswithnativePowerPointsectionsseamlessly –DeepintegrationwithPowerPointsectionskeepsyouragendasup-to-dateassectionsareadded,removed,moved,orrenamed –Supportsbothagendastyles—showagendasoneither(a)atableofcontentsslide,or(b)flysheets(dividerslidesatthestartofeachsection) –Showsection/subsectiontitlesoncontentslidesthatupdateautomaticallywhentheagendachanges –Intelligentlycollapsesubsectionstofitmoreagendatopicsontoasingleslideandimprovereadability –Intelligentlyomitsectionflysheetstoreducepresentationlengthandprintingcosts –Intelligentlyavoidshowingback-to-backflysheetsduringslideshows –Includeslidetitlesorothertextinyourtableofcontents –Fullycustomizableagenda/flysheetappearance ExportcellsandchartsfromExceltoPowerPointandWordmoreeasilyandprofessionally –ExportcellsandchartstoPowerPointandWordaspictures,embeddedworkbooks,tables,charts,andmore –HideExcelinterfaceelements—blueprintpreviewborders,redcellcommentindicators,gridlines,andmore—andrecolorfontsautomaticallyformoreprofessionallookingoutputs –Automaticallycheckforformulaerrorsinthedatayouexport,helpingavoidembarrassingmistakesinyourpresentationsanddocuments –Importedshapes(e.g.,pictures,tables)areintelligentlypositionedandsized,avoidingtediousadjustmentsrequiredforshapespastednatively Improvepresentationqualityandavoidembarrassingmistakes –Checkslidesforformatting,layout,content,andgrammarerrorsandinconsistenciesbeforesendingapresentationtoaclientortoprint –Improvecompliancewithyourcorporatedesignstandardandbranding –Over100checksforissueslikeinconsistentwordhyphenationandabbreviation,missingfootnotes,colorpalettedeviation,incorrectbulletformatting,missingpunctuation,missingchartlabels,imagedistortion,andmuchmore –Unlikeothersolutions,MacabacuscheckschartsandSmartArt –Seeexactlywheretheissuesare,detailedexplanationsofissues,andfrequenciesofoccurrencewhereinconsistenciesarefound –Addressissueswithacustomizedmenuoffixesthathighlightsdominantconventionsinyourpresentationtohelpyouchooseafix –Settheproofinglanguageforanentirepresentationatoncetofixwordsflaggedasmispelledwhichareclearlynot LinkPowerPointandWordtoExceldatawithreliablelinks –LinkcellsandchartsinExceltoshapesandtextinPowerPoint/Word,andupdatelinkswiththeclickofabutton –UnlikenativeOfficelinks,Macabacuslinkswon’tbreakwhenthestructureofyoursourcespreadsheetchanges,whichitiscertaintodo –Reducedfilesizeofpresentations/documentsrelativetoembeddingworkbooksrequiredfornativeOfficelinking –InlinetextlinkinginPowerPointandWordletsyouwriteparagraphswithfiguressourcedfromaspreadsheetthatareeasytoupdate –Versioncontrolhelpsidentifymorerecentversionsofsourcefileswhenupdatinglinks,andrecommendsrelinkingoptions –AutomaticlinkdetectionsupportsfilessharedinthecloudusingaservicelikeDropbox Arepositoryforreusablecontentandtemplatessharedbyallusersinyourorganization –Sharedlibrariesexpeditethepreparationandfacilitatethestandardizationofpresentations,spreadsheets,anddocuments –Librarycontentcanincludeslides(e.g.,teamspages),Officeshapes(e.g.,icons),images(e.g.,clientlogos),charts,anddealtombstones –Librarytemplatescanincludepresentationtemplates,spreadsheettemplates(foruseasstartingpointswhenbuildingnewmodels),anddocumenttemplates(e.g.,faxcoverpages) –Slidesinsertedfromthelibraryarelinked,andcanbeupdatedtothemostrecentversioninthelibrarywiththeclickofabutton –Google-liketextsearchreturnsmatchingcontentinstantaneously –Create“documentgroups”tocategorizepublishedtemplatesbybusinessunitoranyothercategory –Macabacussupports3libraries—apersonallibraryforindividualuse,andteamandcompanylibrariesthatcanbeshared –Locallycacheremotelibrariesforavailabilityoffline –Administrativeprivilegesarerequiredtomodifythecompanylibrary WorkingwithchartsinExcelhasneverbeeneasier –Easilycreatecomplexchartsusedinfinanceandconsulting,includingwaterfall,footballfield,butterfly,andMarimekkocharts –InsertchartsfromyourMacabacuslibrarypre-populatedwithdummydatawithoutlaboringovercomplexchartdatastructures –Addgrowthrate(CAGR)arrowstocolumnchartsthatupdateaschartdatachanges.Extensiveformattingoptionsgiveyoutheexactlookyouwant –Addtotalslabelsabovecolumnsinastackedcolumnchartwithease –Recolordataseriesinacharttoyourpreferredcolorsintwomouseclicks –Stackchartstocreateadashboardandquicklyconformthesizeandpositionofchart/plotareasformultiplechartsatonce –Workwithdatalabelsmoreefficiently –ChartscreatedwithMacabacusare100%native—youdonotneedMacabacustoworkwiththem –Reducethetimespentbyyourgraphicsprofessionalsoncreatingandmodifyingchartsforinternalclients Nearlyunlimitedcustomizationpossibilitiesmeettheneedsofeventhelargestinstitutions –ConfigureMacabacussettings—colors,fonts,templates,etc.—toreflectyourcompany’sbrandidentityanddesignstandard –Customizethebehaviorofmanynon-formatting-relatedtoolstoreflectpersonalororganizationalworkflowpreferences –DeploycustomizationstoalluserstoconformtheappearanceofOfficedocumentstoasinglestandardandstandardizetheMacabacusexperienceforallusers –Savesettingstothecloudforconsistencyacrossallyourdevices –Expeditedeploymentwithourcustomizationservices(atadditionalcost)thattranslateyourdesignstandardintoMacabacussettings Showcaseyourfirm’sadvisoryengagementswithtombstoneslidesinyourclientpitchbooks –Quicklygeneratetombstonesslides,or“creds”pages,foryourclientpitchbooksthathighlightadvisoryengagementsandhelpyourfirmwinnewbusiness –TombstonesarepublishedtoMacabacuslibraries,sotheycanbesharedacrossyourorganizationforconvenientaccessbyeveryone –Powerfulfiltershelpyoufindandsorttombstonesthatshowcasetransactionsrelevanttoyourpitchbookaudienceandtopic –Intelligentlyarrangetombstonesonslidesbasedonyourpresentationlayoutandotherpreferences SystemRequirements: MacabacusisintendedforusewithdesktopinstallationsofMicrosoftOffice2016-2010(32-bitand64-bit)forWindows10-7(32-bitand64-bit).WenolongersupportOffice2007,whichMicrosofthasofficiallyretired. 8.9.20(25Aug2018)NEW [Excel,PowerPoint,Word]PatchforSSL/TLSsecurityprotocolissuethatcouldpreventMacabacusconnectiontotheInternetwithTLS1.0disabled [Excel,PowerPoint]Minorupdates 8.9.19 [PowerPoint,Word]EditLinkdialogloadsfasterinsomecaseswhenthesourceworkbookcontainsmany(>500)rangenames [Excel]FixedthemefontissuethatcouldcauseincorrectfontformattinginPDFs [PowerPoint,Word]Fixedthemefontissuethatcouldcauseincorrectfontformattinginchartsinsertedfromthelibrary [PowerPoint]FixedthemefontissuethatcouldcauseincorrectfontformattinginchartsimportedfromExcel [Word]Fixedsizingissueswhenrefreshinglinkedtablesinsomecases [Word]Fixedbugthatcouldappendnew,ratherthanreplaceold,tablecontentwhenrefreshinglinkedtableswithmergedcells [Excel,PowerPoint,Word]IncreasedtoleranceforExcelbugthatmaycauseexportingtofailinsomecases 8.9.18 [Excel]WorkaroundforExcel2016/365bugthatcouldcauseShortcutManagertodisplayimproperly [Excel]WorkaroundforMicrosoftbugthatcausedsometools(e.g.,Uniformulas,InsertSymbol)toturnoffNumLock [Excel]Fixed“CustomUIRuntimeError”messagethatmightappearinExcel2016/365 [PowerPoint]FixedmissingExcelLinkmenuinsomelinkedtableandembeddedobjectcontextmenus [PowerPoint]Fixedthemefontissuethatcouldcauseincorrectfontformattingintombstonesinsertedfromthelibrary [PowerPoint,Word]ManageLinksandEditLinkdialogsnowremembertheirlastsize [Excel,PowerPoint,Word]Otherminorbugfixesandupdates 8.9.17 [PowerPoint]NewContentSlidedialognowshowsthumbnailsofalllayoutsatonceforeasierlayoutselection [PowerPoint]MinorTemplateWizardimprovements [Excel]ImplementedworkaroundforExcel2016bugaffectingGrowthArrowoperation [Excel]FixedlastusedGrowthArrowsettingsnotbeingsavedsincev8.9.4 8.9.16 [PowerPoint]MajorTemplateWizardimprovementsthatmakecreatingMacabacus-enabledtemplateseasier [PowerPoint]FixedExplorerpanenotshowinglinkedembeddedobjectsandfiltersnotworkingproperly [Excel,Word]FixedabugcausingthesourceworksheettobeduplicateduponexportingtoWordinsomecases [Excel,PowerPoint,Word]WorkaroundforExcel2016bugthatmayproducememoryerrorsuponexportingcellsaspicturesonworksheetswithbackgroundimages [Excel,PowerPoint,Word]Macabacusnolongerrequiresasourceworkbooktobesavedforlinking 8.9.15 [Excel]SuperFindnowhastheabilitytosearchwithinprintareas,only,andimprovedsupportforhighdensitydisplays(Excel2016/2013,only) [Excel,PowerPoint,Word]Minorbugfixesandupdates 8.9.14 [PowerPoint]Receivenotificationwhenlinkedslideupdatesareavailableuponopeningpresentations [PowerPoint]Republishinglibraryslidesnolongerbreakslinkstotheminsomecases [Excel,PowerPoint,Word]Fixederrorswhenrepublishing,deleting,andrenaminglibraryitemswithapostrophesinthefilename/path [Excel,PowerPoint,Word]Fixedfailuretodeleteoldthumbnailimageswhenrepublishingcertainlibraryitems [Excel,PowerPoint,Word]Otherminorbugfixesandupdates 8.9.13 [Excel]Addcommonlyuseddatavalidationtocellswiththeclickofabutton [Excel]Stylesnowsupportcommonlyuseddatavalidation [Excel]X-YScatterLabelstoolnowsupportsmultipleseriesandlinksdatalabelstocellscontaininglabelsratherthan“hardcoding”labeltext [Excel]Imagesinsertedfromlibrariesarenowsizedtomatchtheheightorwidthofamulti-cell,singlecolumnorrowselection [Excel]Freeze/unfreezepanesorsplit/unsplitwindowsatthesamelocationonmultipleworksheetsatonce [Excel]QuickCAGRnowletsyouselectaninputrangeonanotherworksheet [PowerPoint]AccesstoawiderselectionofnumberedbulletstylessupportedbyOfficethanavailablevianativePowerPointinterfaces 8.9.12 [Excel]ImprovedProPrecedentsformulaeditingbehaviorforprecedentsonotherworksheets [PowerPoint]Addingproofingcheckforshapesoutsideleftandrightslidemarginsasdefinedbythebodyplaceholderontheslidemaster 8.9.11 [Excel]AddedabilitytoeditauditedformulasfromtheProPrecedentsdialog [Excel]AddednewSoftDisabletooltopauseMacabacuswhennotrequiredtoeliminateimpactonExcelperformanceandfortroubleshooting [Excel]FixedProPrecedentsbugthatpreventedrecognizingprecedentsonothersheetswhosenamesincludeanunderscorecharacterinrarecases [Excel]RemovedclassicExcel2003tab—timetomoveon [Excel,PowerPoint,Word]TextdescriptionnowappearsintheLibrarypanefortextpublishedtolibrariesinthisversionandlater 8.9.10 [Excel]ProPrecedentsnowincludesanoptiontoignorelinkedworkbooks,ratherthanopenthembydefault [Excel]ProDependentsnowprocessesamaximum,ratherthanunlimited,numberofdependentstoavoidmakingExcelunresponsive [Excel]ReplacedLabelLastPointtoolwithLabelPoints,allowingyoutolabellast,first,maximum,andminimumpointsinlinechartsandclusteredcolumn/barcharts [Excel]Chartadd-ons(e.g.,stacktotals,statlines,targetbands)nowsupportchartswhosedataresidesonadifferentworksheet [Excel]ImprovedTargetBandsupportforstackedbar,column,andlinecharts [Excel]TargetBandbetterpreservesoriginalvalueaxisscale