Magnimetrics Tools for Excel is a user-friendly add-in that simplifies financial modeling and analysis. It’s easy to deploy and helps you deliver on the practical aspects of your FP&A needs. Below is a range of videos showcasing our key features and capabilities. If you have specific topics you want us to cover, submit your ideas and we will consider creating a tutorial around the topic. Our goal is to help you streamline your financial modeling and analysis process, and we’re committed to providing you with the resources and support you need.
Explore the steps of a formula to better understand the way it flows and the data it references.
Bulk edit the visibility settings for worksheets within the current file by switching between Visible, Hidden, and VeryHidden.
Review external links with the options to convert to static values and open the linked file or its location.
Remove all hypertext links from the current selection.
Delete rows that are empty within the selected column.
Apply the trace precedents and trace dependents to all cells within the selection at once.
Switch the visibility of all named ranges to Visible and delete all named ranges at once.
Hide warnings within the current selection.
Add a workbook frame to the right and bottom of the current selection.
Wrap all cells within the selected range with a rounding function.
Wrap all cells within the selected range with an IFERROR() function.
Select all cells with numeric values, formulas, text, or errors.
Switch the reference type of all ranges in formulas within the selection between absolute and relative.
Apply predefined colors to cells with formulas, numeric values, links to other worksheets or external files.
Apply predefined formatting to the current worksheet.
Add a smart Table of Contents that can be easily updated, links to the respective tabs, and adds back links to itself.
Apply a consistent zoom scale across all worksheets in the current workbook and move the selected range to A1 for each worksheet.
Unhide all hidden rows or columns on the current worksheet.
Copy the current selection’s column width and then Paste the same width to the column of each selected cell.
Formats the range to center content across many cells without having to merge cells.
Format selection as a heading, using the preset colors.
Change persistent settings for formatting (e.g., formatting colors, company name, currency, etc.).
Save a copy of the file where all links are converted to constants (all links are broken).
Export each selected worksheet to a separate workbook.
Import multiple workbooks to separate worksheets within the same workbook.
Open the location of the currently active file.
Create multiple copies of the current worksheet with the option to list their names.
Switch between automatic and manual calculation mode for the entire workbook, or calculate only the selected range.
Manage features’ shortcuts and turn the shortcut functionality on and off.
It’s easy! Create a free Magnimetrics account and start building FP&A reports in the cloud.
We are all different and so are our business needs. Our pricing plans deliver the level of flexibility you need to avoid overpaying for unused features.
We would love to learn about your specific needs. Don’t hesitate to reach out so we can help you maximize the impact of Magnimetrics within your organization.