Diapositiva 1

1 / 24
About This Presentation
Title:

Diapositiva 1

Description:

Presentation of: Model Assistant Suite Description: Model Assistant Suite 1.0 is the most useful collection of add-ins for people who use Microsoft Excel as a ... – PowerPoint PPT presentation

Number of Views:0
Avg rating:3.0/5.0
Slides: 25
Provided by: JABS

less

Transcript and Presenter's Notes

Title: Diapositiva 1


1
Presentation of
2
Model Assistant Suite
  • Description
  • Model Assistant Suite 1.0 is the most useful
    collection of add-ins for people who use
    Microsoft Excel as a decision making tool to
    build, understand, communicate or audit more
    robust models, quicker.
  • It also includes a collection of over 70
    financial calculators ready to use in your Excel
    spreadsheet. 

3
Model Assistant Suite
  • Description
  • Model Assistant Suite contains 5 products
  • Excel Model Builder will allow you to audit,
    understand and analyze any Excel model easily.
  • Tools for Excel Tables Essential tools for data
    analysis and tables management for novice and
    advanced Excel's users.
  • Spreadsheet Presenter Easily customize charts
    and reports in Microsoft Excel for a more
    professional look.
  • Model Analyzer for Excel Decide among multiple
    investment alternatives. Analyze multiple
    scenarios and how sensitive certain variables
    are.
  • Financial Advisor for Excel 73 useful and
    powerful financial calculators, directly to your
    Excel spreadsheet.

4
Excel Model Builder
  • Modeling Tools
  • Model chart analysis Make graphical comparisons
    In a twinkle, about data series, using charts
  • Consolidator Make easy the process of
    consolidating information proceeding from
    different workbook but from the same range.
  • Multi-sheets Consolidator Consolidate data from
    different ranges of many sheets of many
    workbooks.
  • Detailed Consolidation This type of
    consolidation is appropriated if you want to see
    the detail along with the totals
  • Multi sheet database / consolidator Consolidate
    data come from many sheets contained in more than
    one workbook and moreover with the records
    disordered
  • Complex formula's consolidation Make in a simple
    way, many arithmetic operations at the same time
    between spreadsheets.
  • Multiple conditional analysis formatting
    Easily, format cells in a database based on a
    criterion previously specified in the decision
    table.
  • Cells math by logical criteria This useful tool
    performs mathematical calculations (adding,
    counting, finding highest, etc.), using cells
    that meet a given criteria
  • Cell's math by format Search all cells in a
    specific range with a particular background color
    and to do some math with the results.

5
Excel Model Builder
  • Auditing
  • Manage internal and external with Links Manager
    tool
  • With Names Manager you will be able to handle
    various types of ranges names (Escondido,
    Visible, Referring to external files, Erroneous,
    Print areas)
  • Search for special cells in your models quickly
    and safely with Auditor Spreadsheet Map
  • Search for cells with formulas involving elements
    with Test Highlights
  • Auditor Trouble test Detect cells with various
    types of problems,
  • Find out where a given value of a formula comes
    from with Formulas Translator tool.

6
Excel Model Builder
  • Reference Analyzer
  • Navigate between the cells which originate and/or
    depend on a cell under observation.
  • Track circular references and visualize the
    complete path.
  • Error's tracker is a more robust tool than
    Excel's Trace Error tool.
  • Analize in a specific range, a group of formulas
    and all the precedence/dependence connections
    between them.
  • Visualize all origin links which may exist
    between formulas of a selected range. Visualize
    any and all dependence links which may exist
    between formulas of a selected range.
  • And more...

7
Excel Model Builder
  • Model Navigation
  • Sheets manager Visualize the complete relation
    of all the sheets of your workbook, including
    hidden and the very-hidden sheets, including
    their properties of each one of them.
  • Workbooks manager tool.
  • Favorites manager Manage many folders, workbooks
    and worksheets in one place
  • Cells value watcher Is the right tool to
    navigate through specific cells in your
    spreadsheet.
  • To do list Manage any pending tasks related to a
    given workbook that may be key to your projects,
    in an ordered manner.
  • Model Version manager Check the progress of your
    projects.
  • Password manager This tool will help you to
    protect your privacy.

8
Excel Model Builder
  • Formula tools
  • Swap ranges interchange data contained in two
    ranges, in a simple manner.
  • Advanced Transposer transpose the data contained
    in the wished range.
  • Copy range as link whether into the same sheet or
    any desired sheet.
  • Flip cells interchanging of values of a selected
    range.
  • Avoid troubles with Excel percentage function
    using Swap to Number tool.
  • Convert numeric values into text so that perform
    certain calculations using the same values.
  • Convert formulas to values with a single click
  • Perform on the spot calculations with Quick
    Mathematics tool
  • and more...

9
Excel Model Builder
  • Quick edition tools
  • Make any mathematical operation Easily, change
    or add a formula to a value or to a cell, or part
    of another formula.
  • Change sign Change the sign of a complete range
    or cell containing formulas or values.
  • Exact formula copier Copy exact formulas from
    one range to another
  • Copy formula to the right
  • Copy formula downward
  • Copy formula in selection Fills a selected range
    with the data found in the first row / column /
    cell, respectively.
  • Paste formulas This function copies formulas
    from one range to another.
  • And more...

10
Excel Model Builder
  • Other useful functions
  • Take pictures
  • Easy print
  • Set alarm
  • Copy Color from another Book
  • Change Color Palette
  • Arithmetical calculator
  • Add to recent file's list
  • Erase history of files
  • Fast close

11
Excel Model Builder
  • Wizards
  • Multiple IF Easy print
  • Waited average
  • Formula's error message (hot)
  • Conditional Sum Count
  • Intersect cell's values
  • Get cell's value (hot)
  • Concatenate cells

12
Excel Model Builder
  • More Tools
  • By text Easy search
  • By format Easy search
  • By logic criteria search
  • Select by format
  • Quick fill
  • Toggle Settings
  • Freeze Divide Panes
  • Arrange Windows
  • Guides

13
Tools for Excel Tables
  • Description
  • Essential tools for advanced data analysis and
    tables management for novice and advanced
    Microsoft Excel users.

It is an Excel data management tool that will
strengthen your Microsoft Excel to manage huge
tables and data bases. This addin combines the
functionalities of Microsoft Excel in order to
create more robust functionalities which let you
extracting multiple conditional data, splitting
tables, smart consolidation, merging tables,
categorizing database, extracting unique records,
stratifying data and more...
14
Tools for Excel Tables
  • Tools for Excel Tables is a priceless, time
    saving Excel tool for accountants, auditors,
    specialists in fraud detection, financial and
    data analysts, and professionals whose activity
    involves the use of data bases or large tables in
    Excel spreadsheets.
  •  
  • If you desire to know more information about
    each function please, click on links below
  • Easy select
  • Select current region
  • Select visible cells
  • Analysis
  • Specific cells
  • Easy search
  • Easy search - By text
  • Easy search - By format
  • Easy search - By logic criteria
  • Cell's math By format
  • Categorize database
  • Multiple conditional analysis formatting
  • Conditional text
  • Sumif Countif
  • Sumif
  • Countif
  • Duplicates
  • Breaches
  • List unique cases
  • Manager I - E
  • Import
  • Export
  • Merge tables
  • Split table S
  • Split table - By groups
  • Split table - By date
  • Change to text - number
  • Concatenate cells
  • Multiple conditional data extractor
  • Extract unique records
  • Multi sheet / database consolidator
  • Complex formula's consolidation
  • Test the "stratification table sufficiency"
  • Time stratification
  • Stratification 1 to 1

15
Tools for Excel Tables
  • More tools
  • If you desire to know more information about each
    function please, click on links
  • below
  • Delete
  • Delete rows empty
  • Delete rows hidden
  • Delete rows visible
  • Delete columns empty
  • Delete columns hidden
  • Delete columns visible
  • Autofilter
  • Sort
  • Form
  • Viewer
  • Guides
  • Freeze divide panes
  • Arrange Windows
  • Toggle settings
  • Sheets manager
  • Workbooks manager
  • Dinamic table
  • Pivot table wizard
  • Chart
  • Table options
  • Refresh data
  • Refresh all
  • Show field list
  • Show dinamic tables bar
  • Bars
  • Show dinamic tables bar
  • Show group outline bar
  • Show dinamic analysis bar
  • Show dinamic manager bar
  • Show viewer bar

16
Spreadsheet Presenter
  • Description
  • Easily customize charts and reports in Microsoft
    Excel for a more professional look.
  • Spreadsheet Presenter will allow you to customize
    your charts and reports in Microsoft Excel - as
    you desire.
  • You will have many tools available to improve
    your worksheets, making them easier to read and
    follow, for your presentations and reports.
  • Add new colors, highlights, notes, automate
    formatting tasks, take images, export reports and
    more...

17
Spreadsheet Presenter
Spreadsheet Presenter has more than 50 tools
which will make your work easier and faster, with
a fresh and professional look.  If you desire
more information about each tool you can click on
links below
  • Titles
  • Autoformat
  • Select Alternate Rows Shading
  • Color Font
  • Cell's format
  • Format Borders
  • Format Range
  • Dotted Line Tool
  • Apply Formatting Options
  • Bullets
  • Format Date
  • Format Number
  • Change Case
  • Superscript and Underscript
  • Custom cells alignment
  • Change horizontal alignment
  • Change Vertical Alignment
  • Format cell's Height
  • Format Cell's Width
  • Save Palette
  • Add Note
  • Draw a Circle
  • Highlights and Arrows
  • Watermark
  • Stamp
  • Images
  • Add Label
  • Move Labels
  • Add Images
  • Text Box
  • Resize Charts
  • Change Chart Colors
  • Export sheets as...
  • Copy Color From Another Book
  • Add/Remove Text
  • Add text as Number Format
  • Apply your Favorite Palette
  • Add Iterative Tools Bar

18
Model Analizer for Excel
  • Description
  • Powerful Excels analysis tool
  • This product is Integrated by three kind of
    analysis multiples scenarios analysis,
    sensitivity analysis and Analysis of objective
    values.
  • Change manual tasks and repetitive which don't
    add value to your business and save time and
    effort to dedicate to the reason of being of your
    enterprise.

19
Model Analizer for Excel
  • Multi Scenarios Mannager
  • Take IT allows you to built multiple scenarios
    without changing the structure of your model.
  • IT allows you to increase the productivity of the
    worker
  • The only one tool in the market and made thinking
    in the needs of the users.

Example Model
20
Model Analizer for Excel
  • What-if Analysis
  • To analyse the sensitivity with absolute
    quantities and percentage of variables of the
    variables from your models.
  • Only in several seconds you can obtain reprots
    and graphics such as Spider, Tornado and
    Sensitivity Tables.
  • IT allows you to know and care the variables
    which have more impact in your model.

Example Model
21
Model Analizer for Excel
  • Goal Seeker Analysis
  • It allows you to find the necessary values that
    must take certain variables of your model to get
    the desired objectives or ideal values from other
    variables.
  • Moreover, find points of balance

Example Model
22
Financial Advisor for excel
  • Description
  • Financial Advisor for Excel has 73 financial
    calculators that will simplify basic financial
    calculations, saving you time and effort. These
    calculators can work for all sorts of different
    evaluations for cash flows, loans, investments,
    future values, rates of return, financial
    analyses and personal finances.
  • You only need to enter the data as required and
    the calculators automatically give you the
    results.
  • Our calculators have a professionally impressive
    design, are flexible with sensitivity tables and
    offer charts and help notes to make them easy to
    use and understand.

Number of Calculators Financial Advisor for Excel
Valuation of Flows 14
Loans 13
Future Value 5
Inversions 8
Rates of Return 7
Financial Analysis 14
Personal Miscellaneous 12
Total 73
23
Financial Advisor for excel
If you desire more information about each
financial calculator you can click on image
below
24
Volume discount prices
1 License USD 399.95
2-5 Licenses USD 339.95
6-9 Licenses USD 295.95
10 or more Licenses USD 199.95
If you desire purchase it, simple click links
below https//secure.shareit.com/shareit/checkout
.html?PRODUCT5B3001339215D1languageid1

Please, if you have any doubt or need further
information, dont hesitate to contact us
at sales_at_modeladvisor.com
Write a Comment
User Comments (0)