Macabacus for Microsoft Office是為Office用戶打造的一款增強插件，這款插件包含了實用的公式，免去了手工輸入公式符號進行計算的麻煩，特別是一些不常用的公式，手工輸入的十分麻煩，支持Office 2010、Office 2013、Office 2016等版本，除此之外，還擁有將表格中的單元格和圖表導出到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適用於Windows 10-Windows 7(32位和64位)的Microsoft Office 2016-2010桌面安裝(32位和64位)。
The leading productivity add-ins for Excel, PowerPoint, and Word. The most complete and highest-quality suite of Microsoft. Office productivity add-ins for finance and other professionals.
Build Financial Models & Presentations More Efficiently
– 80%+ Time Savings for Routine Tasks
– Power Modeling Tools
– Advanced Formula
– Auditing
– Charting Tools
– Dozens of Keyboard
– Shortcuts
– Reliably Link to Excel
– Table of Contents /
– Agenda Automation
– Check Presentations for Mistakes
– Shared Content &
– Template Libraries
– Find & Navigate
– More Easily
– Workbook Optimization
– Extensive Customization
– Enterprise Deployment
Reduce mistakes with our powerful, best-in-class auditing tools—absolutely essential for power users
– Effortlessly navigate a formula’s inputs across worksheets and workbooks, using only the keyboard
– Similarly navigate a cell’s dependents, showing you what formulas and charts the audited cell is driving
– Drill down on precedents / dependents using tree-based navigation to help you understand everything driving your formulas
– Analyze complex formulas piece-by-piece to see what a portion of the formula contributes to the overall result
– Visualizations highlight formula errors, outliers, and other inconsistencies that might otherwise go unnoticed
– View precedents / dependents trace arrows for multiple cells at once or as you navigate cells
Keep your presentation agendas updated so that you can focus on content
– Synchronize agenda slides with native PowerPoint sections seamlessly
– Deep integration with PowerPoint sections keeps your agendas up-to-date as sections are added, removed, moved, or renamed
– Supports both agenda styles—show agendas on either (a) a table of contents slide, or (b) flysheets (divider slides at the start of each section)
– Show section / subsection titles on content slides that update automatically when the agenda changes
– Intelligently collapse subsections to fit more agenda topics onto a single slide and improve readability
– Intelligently omit section flysheets to reduce presentation length and printing costs
– Intelligently avoid showing back-to-back flysheets during slide shows
– Include slide titles or other text in your table of contents
– Fully customizable agenda / flysheet appearance
Export cells and charts from Excel to PowerPoint and Word more easily and professionally
– Export cells and charts to PowerPoint and Word as pictures, embedded workbooks, tables, charts, and more
– Hide Excel interface elements—blue print preview borders, red cell comment indicators, gridlines, and more—and recolor fonts automatically for more professional looking outputs
– Automatically check for formula errors in the data you export, helping avoid embarrassing mistakes in your presentations and documents
– Imported shapes (e.g., pictures, tables) are intelligently positioned and sized, avoiding tedious adjustments required for shapes pasted natively
Improve presentation quality and avoid embarrassing mistakes
– Check slides for formatting, layout, content, and grammar errors and inconsistencies before sending a presentation to a client or to print
– Improve compliance with your corporate design standard and branding
– Over 100 checks for issues like inconsistent word hyphenation and abbreviation, missing footnotes, color palette deviation, incorrect bullet formatting, missing punctuation, missing chart labels, image distortion, and much more
– Unlike other solutions, Macabacus checks charts and Smart Art
– See exactly where the issues are, detailed explanations of issues, and frequencies of occurrence where inconsistencies are found
– Address issues with a customized menu of fixes that highlights dominant conventions in your presentation to help you choose a fix
– Set the proofing language for an entire presentation at once to fix words flagged as mispelled which are clearly not
Link PowerPoint and Word to Excel data with reliable links
– Link cells and charts in Excel to shapes and text in PowerPoint / Word, and update links with the click of a button
– Unlike native Office links, Macabacus links won’t break when the structure of your source spreadsheet changes, which it is certain to do
– Reduced file size of presentations / documents relative to embedding workbooks required for native Office linking
– Inline text linking in PowerPoint and Word lets you write paragraphs with figures sourced from a spreadsheet that are easy to update
– Version control helps identify more recent versions of source files when updating links, and recommends relinking options
– Automatic link detection supports files shared in the cloud using a service like Dropbox
A repository for reusable content and templates shared by all users in your organization
– Shared libraries expedite the preparation and facilitate the standardization of presentations, spreadsheets, and documents
– Library content can include slides (e.g., teams pages), Office shapes (e.g., icons), images (e.g., client logos), charts, and deal tombstones
– Library templates can include presentation templates, spreadsheet templates (for use as starting points when building new models), and document templates (e.g., fax cover pages)
– Slides inserted from the library are linked, and can be updated to the most recent version in the library with the click of a button
– Google-like text search returns matching content instantaneously
– Create “document groups” to categorize published templates by business unit or any other category
– Macabacus supports 3 libraries—a personal library for individual use, and team and company libraries that can be shared
– Locally cache remote libraries for availability offline
– Administrative privileges are required to modify the company library
Working with charts in Excel has never been easier
– Easily create complex charts used in finance and consulting, including waterfall, football field, butterfly, and Marimekko charts
– Insert charts from your Macabacus library pre-populated with dummy data without laboring over complex chart data structures
– Add growth rate (CAGR) arrows to column charts that update as chart data changes. Extensive formatting options give you the exact look you want
– Add totals labels above columns in a stacked column chart with ease
– Recolor data series in a chart to your preferred colors in two mouse clicks
– Stack charts to create a dashboard and quickly conform the size and position of chart / plot areas for multiple charts at once
– Work with data labels more efficiently
– Charts created with Macabacus are 100% native—you do not need Macabacus to work with them
– Reduce the time spent by your graphics professionals on creating and modifying charts for internal clients
Nearly unlimited customization possibilities meet the needs of even the largest institutions
– Configure Macabacus settings—colors, fonts, templates, etc.—to reflect your company’s brand identity and design standard
– Customize the behavior of many non-formatting-related tools to reflect personal or organizational workflow preferences
– Deploy customizations to all users to conform the appearance of Office documents to a single standard and standardize the Macabacus experience for all users
– Save settings to the cloud for consistency across all your devices
– Expedite deployment with our customization services (at additional cost) that translate your design standard into Macabacus settings
Showcase your firm’s advisory engagements with tombstone slides in your client pitchbooks
– Quickly generate tombstones slides, or “creds” pages, for your client pitchbooks that highlight advisory engagements and help your firm win new business
– Tombstones are published to Macabacus libraries, so they can be shared across your organization for convenient access by everyone
– Powerful filters help you find and sort tombstones that showcase transactions relevant to your pitchbook audience and topic
– Intelligently arrange tombstones on slides based on your presentation layout and other preferences
System Requirements:
Macabacus is intended for use with desktop installations of Microsoft Office 2016-2010 (32-bit and 64-bit) for Windows 10-7 (32-bit and 64-bit). We no longer support Office 2007, which Microsoft has officially retired.
8.9.20 (25 Aug 2018) NEW
[Excel, PowerPoint, Word] Patch for SSL/TLS security protocol issue that could prevent Macabacus connection to the Internet with TLS 1.0 disabled
[Excel, PowerPoint] Minor updates
8.9.19
[PowerPoint, Word] Edit Link dialog loads faster in some cases when the source workbook contains many (>500) range names
[Excel] Fixed theme font issue that could cause incorrect font formatting in PDFs
[PowerPoint, Word] Fixed theme font issue that could cause incorrect font formatting in charts inserted from the library
[PowerPoint] Fixed theme font issue that could cause incorrect font formatting in charts imported from Excel
[Word] Fixed sizing issues when refreshing linked tables in some cases
[Word] Fixed bug that could append new, rather than replace old, table content when refreshing linked tables with merged cells
[Excel, PowerPoint, Word] Increased tolerance for Excel bug that may cause exporting to fail in some cases
8.9.18
[Excel] Workaround for Excel 2016/365 bug that could cause Shortcut Manager to display improperly
[Excel] Workaround for Microsoft bug that caused some tools (e.g., Uniformulas, Insert Symbol) to turn off Num Lock
[Excel] Fixed “Custom UI Runtime Error” message that might appear in Excel 2016/365
[PowerPoint] Fixed missing Excel Link menu in some linked table and embedded object context menus
[PowerPoint] Fixed theme font issue that could cause incorrect font formatting in tombstones inserted from the library
[PowerPoint, Word] Manage Links and Edit Link dialogs now remember their last size
[Excel, PowerPoint, Word] Other minor bug fixes and updates
8.9.17
[PowerPoint] New Content Slide dialog now shows thumbnails of all layouts at once for easier layout selection
[PowerPoint] Minor Template Wizard improvements
[Excel] Implemented workaround for Excel 2016 bug affecting Growth Arrow operation
[Excel] Fixed last used Growth Arrow settings not being saved since v8.9.4
8.9.16
[PowerPoint] Major Template Wizard improvements that make creating Macabacus-enabled templates easier
[PowerPoint] Fixed Explorer pane not showing linked embedded objects and filters not working properly
[Excel, Word] Fixed a bug causing the source worksheet to be duplicated upon exporting to Word in some cases
[Excel, PowerPoint, Word] Workaround for Excel 2016 bug that may produce memory errors upon exporting cells as pictures on worksheets with background images
[Excel, PowerPoint, Word] Macabacus no longer requires a source workbook to be saved for linking
8.9.15
[Excel] Super Find now has the ability to search within print areas, only, and improved support for high density displays (Excel 2016/2013, only)
[Excel, PowerPoint, Word] Minor bug fixes and updates
8.9.14
[PowerPoint] Receive notification when linked slide updates are available upon opening presentations
[PowerPoint] Republishing library slides no longer breaks links to them in some cases
[Excel, PowerPoint, Word] Fixed errors when republishing, deleting, and renaming library items with apostrophes in the file name / path
[Excel, PowerPoint, Word] Fixed failure to delete old thumbnail images when republishing certain library items
[Excel, PowerPoint, Word] Other minor bug fixes and updates
8.9.13
[Excel] Add commonly used data validation to cells with the click of a button
[Excel] Styles now support commonly used data validation
[Excel] X-Y Scatter Labels tool now supports multiple series and links data labels to cells containing labels rather than “hardcoding” label text
[Excel] Images inserted from libraries are now sized to match the height or width of a multi-cell, single column or row selection
[Excel] Freeze / unfreeze panes or split / unsplit windows at the same location on multiple worksheets at once
[Excel] Quick CAGR now lets you select an input range on another worksheet
[PowerPoint] Access to a wider selection of numbered bullet styles supported by Office than available via native PowerPoint interfaces
8.9.12
[Excel] Improved Pro Precedents formula editing behavior for precedents on other worksheets
[PowerPoint] Adding proofing check for shapes outside left and right slide margins as defined by the body placeholder on the slide master
8.9.11
[Excel] Added ability to edit audited formulas from the Pro Precedents dialog
[Excel] Added new Soft Disable tool to pause Macabacus when not required to eliminate impact on Excel performance and for troubleshooting
[Excel] Fixed Pro Precedents bug that prevented recognizing precedents on other sheets whose names include an underscore character in rare cases
[Excel] Removed classic Excel 2003 tab—time to move on
[Excel, PowerPoint, Word] Text description now appears in the Library pane for text published to libraries in this version and later
8.9.10
[Excel] Pro Precedents now includes an option to ignore linked workbooks, rather than open them by default
[Excel] Pro Dependents now processes a maximum, rather than unlimited, number of dependents to avoid making Excel unresponsive
[Excel] Replaced Label Last Point tool with Label Points, allowing you to label last, first, maximum, and minimum points in line charts and clustered column / bar charts
[Excel] Chart add-ons (e.g., stack totals, stat lines, target bands) now support charts whose data resides on a different worksheet
[Excel] Improved Target Band support for stacked bar, column, and line charts
[Excel] Target Band better preserves original value axis scale
|
專業軟體光碟
