Learn with Magnimetrics

Explore a wide array of training materials and videos

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 Magnimetrics Tools for Excel

Overview of Modeling Features

Play Video

Audit Formula

Explore the steps of a formula to better understand the way it flows and the data it references.

Play Video

Visibility Options

Bulk edit the visibility settings for worksheets within the current file by switching between Visible, Hidden, and VeryHidden.

Play Video

External Links

Review external links with the options to convert to static values and open the linked file or its location.

Play Video

Remove Hyperlinks

Remove all hypertext links from the current selection.

Play Video

Delete Empty Rows

Delete rows that are empty within the selected column.

Play Video

Trace Formulas

Apply the trace precedents and trace dependents to all cells within the selection at once.

Play Video

Named Ranges

Switch the visibility of all named ranges to Visible and delete all named ranges at once.

Play Video

Remove Warnings

Hide warnings within the current selection.

Play Video

Add Frame

Add a workbook frame to the right and bottom of the current selection.

Overview of Cells and Ranges Features

Play Video

Add Rounding

Wrap all cells within the selected range with a rounding function.

Play Video


Wrap all cells within the selected range with an IFERROR() function.

Play Video

Select All

Select all cells with numeric values, formulas, text, or errors.

Play Video

Change Reference

Switch the reference type of all ranges in formulas within the selection between absolute and relative.

Overview of Formatting Features

Play Video

Numbers Coloring

Apply predefined colors to cells with formulas, numeric values, links to other worksheets or external files.

Play Video

Sheet Formatting

Apply predefined formatting to the current worksheet.

Play Video

Table of Contents

Add a smart Table of Contents that can be easily updated, links to the respective tabs, and adds back links to itself.

Play Video

Apply Zoom Level

Apply a consistent zoom scale across all worksheets in the current workbook and move the selected range to A1 for each worksheet.

Play Video

Unhide All

Unhide all hidden rows or columns on the current worksheet.

Play Video

Copy Column Width

Copy the current selection’s column width and then Paste the same width to the column of each selected cell.

Play Video

Center Across

Formats the range to center content across many cells without having to merge cells.

Play Video

Format as Header

Format selection as a heading, using the preset colors.

Play Video

Format Settings

Change persistent settings for formatting (e.g., formatting colors, company name, currency, etc.).

Overview of File Management Features

Play Video

Save Without Links

Save a copy of the file where all links are converted to constants (all links are broken).

Play Video

Export to Files

Export each selected worksheet to a separate workbook.

Play Video

Import from Files

Import multiple workbooks to separate worksheets within the same workbook.

Play Video

Open Location

Open the location of the currently active file.

Play Video

Duplicate Sheet

Create multiple copies of the current worksheet with the option to list their names.

Play Video

Calculation Options

Switch between automatic and manual calculation mode for the entire workbook, or calculate only the selected range.

Overview of Other Features

Play Video

Shortcuts Manager

Manage features’ shortcuts and turn the shortcut functionality on and off.

Sign Up for our Newsletter

And Get a FREE Benchmark Analysis Template

Excel Tools Footer

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.