Normal view MARC view

Power modeling midnight manual

Author: Ascoli, Edward Publisher: Adkins and Matchett, 2007.Language: EnglishDescription: 87 p. ; 21 cm.ISBN: 9781891112744Type of document: Book
Tags: No tags from this library for this title. Log in to add tags.
Item type Current location Collection Call number Status Date due Barcode Item holds
Book Asia Campus
Main Collection
Print HG173 .A736 2007
(Browse shelf)
900185233
Available 900185233
Total holds: 0

Digitized

Table of Contents Modeling with Styles 1 Introduction....................................................................................................................................... 1 Defining a style ................................................................................................................................... 1 Applying a style .................................................................................................................................. 2 Applying a style using the Style dialog box.............................................................................. 2 Applying a style using the Style drop down box ............................................................................. 2 Applying a style using copy and paste............................................................................................ 5 Applying a style using copy and paste special ............................................................................... 5 5 Editing an existing style ...................................................................................................................... Deleting an existing style .................................................................................................................... 6 Making styles available in different Excel files ...................................................................................6 Importing styles from another file ................................................................................................... 6 Saving styles in a general template file ........................................................................................ 7 Saving styles in the default workbook template........... ...... ..................................................... 8 Styles for financial modeling purposes............................................................................................ 9 Normal style .................................................................................................................................. 9 Percent style ...................... ..................................................................................................... 11 Blue style ...................................................................................................................................... 13 Input style...................................................................................................................................... 13 Date style ...................................................................................................................................... 15 Multiple style .................................................................................... . .. . .................................16 Multiple style without the x ............................................................................................................ 18 Special underline style ........................ . . ..................................................................................... 19 Custom number formats ................................................................................................................... 21 What is a custom number format? ..............................................................................................21 Number format string .................................................................................................................. 21 Number format codes ............................................................................................................... 22 Date number format codes ........................................................................................................... 22 23 Circularities Under Control Introduction.................... .................... .............................................................................................. 23 What is a circular reference?............................................................................................................ 23 Preventing unintentional circular references ............................................................ ............ . . . . . . 23 Displayingthe circular message................................................................................................... 24 Displayingthe circular indicator on the status bar ................ ............................................... 24 Returning an unexpected zero ...................................................................................................... 24 25 Intentionalcircular references ......................................................................................................... Iteration setting ......................................................................................................................... 25 Working with intentional circular references ................................................................................. 25 Super Flexible Output Tables 29 Introduction....................................................................................................................................... 29 LOOKUP functions ........................................................................................................................... 29 VLOOKUP function ....................................................................................................................... 29 HLOOKUP function ....................................................................................................................... 31 INDEX function .............................................................................................................................32 MATCH function........... . . .......................................................................................................... . 33 .................................................................. 34 MATCH used in conjunction with INDEX............... . MATCH used in conjunction with VLOOKUP and HLOOKUP...................................................... 35 Grand Scenarios 37 Introduction.................................................................................................................................... 37 Switch functions .......... .............................................................................................................. 37 CHOOSE function..................... .......................................................................................... 37 OFFSET function .................... ................................................................................................ 39 41 MATCH function............................................................................................................................ Controls ............................................................................................................................................ 43 ............................................................................................................................ Power Modeling Power Modeling . . ............................................................................................................... . . . ........................................................................................................... ................................................................................................................................ . . . . . . . . Using list data validation ....................................................................................................... 44 On-sheet controls.........................................................................................................................45 Dynamic headings and footnotes ............................................................................................ 56 Concatenation............................................................................................................................... 56 Case functions .............................................................................................................................. 57 Modeling application.................................................................................................................... 57 58 Text function .............................................................................................................................. Sensltizlng Your Work 61 Introduction..................................................................................................................................... 61 Data tables ....................................................................................................................................... 61 One-input data tables................................................................................................................... 62 Two-input data tables................................................................................................................... 66 69 Modeling application ................................................................................................................... Sensitizing data table input values ........................................................................................ 72 Protecting Your Work ........................................................................................................................ 81 Introduction................... . ............................................................................................................. 81 81 Hiding formulas ................................................................................................................................. . ............................................................................. 82 Protecting cells and ranges ......................... . . ............................................................................ 85 Protecting the workbook structure.......... . Preventing changes from being saved ........................................................................................... 85 Preventing access to a workbook .................................................................................................... 86 ....................................................................................................................

There are no comments for this item.

Log in to your account to post a comment.
Koha 18.11 - INSEAD Catalogue
Home | Contact Us | What's Koha?