# 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

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

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

Play Video

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 a workbook frame to the right and bottom of the current selection.

#### Overview of Cells and Ranges Features

Play Video

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.

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

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 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 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.

Play Video

#### Shortcuts Manager

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