搜索
Presentationof:ModelAssistantSuiteDescription:ModelAssistantSuite1.0isthemostusefulcollectionofadd-insforpeoplewhouseMicrosoftExcelasadecisionmakingtool:tobuild,understand,communicateorauditmorerobustmodels,quicker.Italsoincludesacollectionofover70financialcalculatorsreadytouseinyourExcelspreadsheet.Description:ModelAssistantSuitecontains5products:•ExcelModelBuilder:willallowyoutoaudit,understandandanalyzeanyExcelmodeleasily.•ToolsforExcelTables:EssentialtoolsfordataanalysisandtablesmanagementfornoviceandadvancedExcel'susers.•SpreadsheetPresenter:EasilycustomizechartsandreportsinMicrosoftExcelforamoreprofessionallook.•ModelAnalyzerforExcel:Decideamongmultipleinvestmentalternatives.Analyzemultiplescenariosandhowsensitivecertainvariablesare.•FinancialAdvisorforExcel:73usefulandpowerfulfinancialcalculators,directlytoyourExcelspreadsheet.ModelAssistantSuiteExcelModelBuilderModelingTools•Modelchartanalysis:MakegraphicalcomparisonsInatwinkle,aboutdataseries,usingcharts•Consolidator:Makeeasytheprocessofconsolidatinginformationproceedingfromdifferentworkbookbutfromthesamerange.•Multi-sheetsConsolidator:Consolidatedatafromdifferentrangesofmanysheetsofmanyworkbooks.•DetailedConsolidation:Thistypeofconsolidationisappropriatedifyouwanttoseethedetailalongwiththetotals•Multisheetdatabase/consolidator:Consolidatedatacomefrommanysheetscontainedinmorethanoneworkbookandmoreoverwiththerecordsdisordered•Complexformula'sconsolidation:Makeinasimpleway,manyarithmeticoperationsatthesametimebetweenspreadsheets.•Multipleconditionalanalysis&formatting:Easily,formatcellsinadatabasebasedonacriterionpreviouslyspecifiedinthedecisiontable.•Cellsmathbylogicalcriteria:Thisusefultoolperformsmathematicalcalculations(adding,counting,findinghighest,etc.),usingcellsthatmeetagivencriteria•Cell'smathbyformat:Searchallcellsinaspecificrangewithaparticularbackgroundcolorandtodosomemathwiththeresults.Auditing•ManageinternalandexternalwithLinksManagertool•WithNamesManageryouwillbeabletohandlevarioustypesofrange’snames(Escondido,Visible,Referringtoexternalfiles,Erroneous,Printareas)•SearchforspecialcellsinyourmodelsquicklyandsafelywithAuditorSpreadsheetMap•SearchforcellswithformulasinvolvingelementswithTest&Highlights•AuditorTroubletest:Detectcellswithvarioustypesofproblems,•FindoutwhereagivenvalueofaformulacomesfromwithFormulasTranslatortool.ExcelModelBuilderReferenceAnalyzer•Navigatebetweenthecellswhichoriginateand/ordependonacellunderobservation.•Trackcircularreferencesandvisualizethecompletepath.•Error'strackerisamorerobusttoolthanExcel'sTraceErrortool.•Analizeinaspecificrange,agroupofformulasandalltheprecedence/dependenceconnectionsbetweenthem.•Visualizealloriginlinkswhichmayexistbetweenformulasofaselectedrange.Visualizeanyandalldependencelinkswhichmayexistbetweenformulasofaselectedrange.•Andmore...ExcelModelBuilderModelNavigation•Sheetsmanager:Visualizethecompleterelationofallthesheetsofyourworkbook,includinghiddenandthevery-hiddensheets,includingtheirpropertiesofeachoneofthem.•Workbooksmanagertool.•Favoritesmanager:Managemanyfolders,workbooksandworksheetsinoneplace•Cellsvaluewatcher:Istherighttooltonavigatethroughspecificcellsinyourspreadsheet.•Todolist:Manageanypendingtasksrelatedtoagivenworkbookthatmaybekeytoyourprojects,inanorderedmanner.•ModelVersionmanager:Checktheprogressofyourprojects.•Passwordmanager:Thistoolwillhelpyoutoprotectyourprivacy.ExcelModelBuilderFormulatools•Swapranges:interchangedatacontainedintworanges,inasimplemanner.•AdvancedTransposer:transposethedatacontainedinthewishedrange.•Copyrangeaslinkwhetherintothesamesheetoranydesiredsheet.•Flipcells:interchangingofvaluesofaselectedrange.•AvoidtroubleswithExcelpercentagefunctionusingSwap%toNumbertool.•Convertnumericvaluesintotextsothatperformcertaincalculationsusingthesamevalues.•Convertformulastovalueswithasingleclick•PerformonthespotcalculationswithQuickMathematicstool•andmore...ExcelModelBuilderQuickeditiontools•Makeanymathematicaloperation:Easily,changeoraddaformulatoavalueortoacell,orpartofanotherformula.•Changesign:Changethesignofacompleterangeorcellcontainingformulasorvalues.•Exactformulacopier:Copyexactformulasfromonerangetoanother•Copyformulatotheright•Copyformuladownward•CopyformulainselectionFillsaselectedrangewiththedatafoundinthefirstrow/column/cell,respectively.•Pasteformulas:Thisfunctioncopiesformulasfromonerangetoanother.•Andmore...ExcelModelBuilderOtherusefulfunctions•Takepictures•Easyprint•Setalarm•CopyColorfromanotherBook•ChangeColorPalette•Arithmeticalcalculator•Addtorecentfile'slist•Erasehistoryoffiles•FastcloseExcelModelBuilderWizards•MultipleIFEasyprint•Waitedaverage•Formula'serrormessage(hot)•ConditionalSum&Count•Intersectcell'svalues•Getcell'svalue(hot)•ConcatenatecellsExcelModelBuilderMoreTools•BytextEasysearch•ByformatEasysearch•Bylogiccriteriasearch•Selectbyformat•Quickfill•ToggleSettings•Freeze|DividePanes•ArrangeWindows•GuidesExcelModelBuilderToolsforExcelTablesDescription:EssentialtoolsforadvanceddataanalysisandtablesmanagementfornoviceandadvancedMic