Microsoft Office Excel 2007 formulas & functions for dummies [[electronic resource] /] / by Ken Bluttman and Peter G. Aitken |
Autore | Bluttman Ken |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2007 |
Descrizione fisica | 1 online resource (386 p.) |
Disciplina | 005.54 |
Altri autori (Persone) | AitkenPeter G |
Collana | For dummies |
Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
ISBN | 0-470-37739-9 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Microsoft Office Excel 2007 Formulas & Functions for Dummies; About the Authors; Dedications; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; How to Use This Book; What You Can Safely Ignore; Foolish Assumptions; How This Book Is Organized; Icons Used In This Book; Where to Go from Here; Part I: Putting the Fun in Functions; Chapter 1: Tapping into Formula and Function Fundamentals; Working with Excel Fundamentals; Gaining the Upper Hand on Formulas; Using Functions in Formulas; Chapter 2: Saving Time with Function Tools
Getting Familiar with the Insert Function Dialog BoxFinding the Correct Function; Entering Functions Using the Insert Function Dialog Box; Directly Entering Formulas and Functions; Chapter 3: Saying "Array!" for Formulas and Functions; Discovering Arrays; Using Arrays in Formulas; Working with Functions That Return Arrays; Chapter 4: Fixing Formula Boo-Boos; Catching Errors as You Enter Them; Auditing Formulas; Watching the Watch Window; Evaluating and Checking Errors; Making an Error Behave the Way You Want; Part II: Counting on Your Money Chapter 5: Calculating Loan Payments and Interest RatesUnderstanding How Excel Handles Money; Figuring Loan Calculations; Chapter 6: Appreciating What You'll Get, Depreciating What You Got; Looking into the Future; Depreciating the Finer Things in Life; Measuring Your Internals; Chapter 7: Using Basic Math Functions; Adding It All Together with the SUM Function; Rounding Out Your Knowledge; Leaving All Decimals Behind with INT; Leaving Some Decimals Behind with TRUNC; Looking for a Sign; Ignoring Signs; Chapter 8: Advancing Your Math; Using PI to Calculate Circumference and Diameter Generating and Using Random NumbersOrdering Items; Combining; Raising Numbers to New Heights; Multiplying Multiple Numbers; Using What Remains with the MOD Function; Summing Things Up; Chapter 9: Throwing Statistics a Curve; Stuck in the Middle with AVERAGE, MEDIAN, and MODE; Deviating from the Middle; Analyzing Data with Percentiles and Bins; Going for the Count; Chapter 10: Using Significance Tests; Testing to the T; Comparing Results to an Estimate; Part III: Doing the Math; Chapter 11: Rolling the Dice on Predictions and Probability; Modeling Getting It Straight: Using SLOPE and INTERCEPT to Describe Linear DataWhat's in the Future: Using FORECAST, TREND, and GROWTH to Make Predictions; Using NORMDIST and POISSON to Determine Probabilities; Chapter 12: Dressing Up for Date Functions; Understanding How Excel Handles Dates; Formatting Dates; Making a Date with DATE; Breaking a Date with DAY, MONTH, and YEAR; Converting a Date from Text; Finding Out What TODAY Is; Determining the Day of the Week; Working with Workdays; Calculating Time between Two Dates with the DATEDIF Function; Chapter 13: Keeping Well-Timed Functions Understanding How Excel Handles Time |
Record Nr. | UNINA-9910777042103321 |
Bluttman Ken
![]() |
||
Hoboken, N.J., : Wiley, c2007 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Microsoft Office Excel 2007 formulas & functions for dummies / / by Ken Bluttman and Peter G. Aitken |
Autore | Bluttman Ken |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2007 |
Descrizione fisica | 1 online resource (386 p.) |
Disciplina | 005.54 |
Altri autori (Persone) | AitkenPeter G |
Collana | For dummies |
Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
ISBN | 0-470-37739-9 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Microsoft Office Excel 2007 Formulas & Functions for Dummies; About the Authors; Dedications; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; How to Use This Book; What You Can Safely Ignore; Foolish Assumptions; How This Book Is Organized; Icons Used In This Book; Where to Go from Here; Part I: Putting the Fun in Functions; Chapter 1: Tapping into Formula and Function Fundamentals; Working with Excel Fundamentals; Gaining the Upper Hand on Formulas; Using Functions in Formulas; Chapter 2: Saving Time with Function Tools
Getting Familiar with the Insert Function Dialog BoxFinding the Correct Function; Entering Functions Using the Insert Function Dialog Box; Directly Entering Formulas and Functions; Chapter 3: Saying "Array!" for Formulas and Functions; Discovering Arrays; Using Arrays in Formulas; Working with Functions That Return Arrays; Chapter 4: Fixing Formula Boo-Boos; Catching Errors as You Enter Them; Auditing Formulas; Watching the Watch Window; Evaluating and Checking Errors; Making an Error Behave the Way You Want; Part II: Counting on Your Money Chapter 5: Calculating Loan Payments and Interest RatesUnderstanding How Excel Handles Money; Figuring Loan Calculations; Chapter 6: Appreciating What You'll Get, Depreciating What You Got; Looking into the Future; Depreciating the Finer Things in Life; Measuring Your Internals; Chapter 7: Using Basic Math Functions; Adding It All Together with the SUM Function; Rounding Out Your Knowledge; Leaving All Decimals Behind with INT; Leaving Some Decimals Behind with TRUNC; Looking for a Sign; Ignoring Signs; Chapter 8: Advancing Your Math; Using PI to Calculate Circumference and Diameter Generating and Using Random NumbersOrdering Items; Combining; Raising Numbers to New Heights; Multiplying Multiple Numbers; Using What Remains with the MOD Function; Summing Things Up; Chapter 9: Throwing Statistics a Curve; Stuck in the Middle with AVERAGE, MEDIAN, and MODE; Deviating from the Middle; Analyzing Data with Percentiles and Bins; Going for the Count; Chapter 10: Using Significance Tests; Testing to the T; Comparing Results to an Estimate; Part III: Doing the Math; Chapter 11: Rolling the Dice on Predictions and Probability; Modeling Getting It Straight: Using SLOPE and INTERCEPT to Describe Linear DataWhat's in the Future: Using FORECAST, TREND, and GROWTH to Make Predictions; Using NORMDIST and POISSON to Determine Probabilities; Chapter 12: Dressing Up for Date Functions; Understanding How Excel Handles Dates; Formatting Dates; Making a Date with DATE; Breaking a Date with DAY, MONTH, and YEAR; Converting a Date from Text; Finding Out What TODAY Is; Determining the Day of the Week; Working with Workdays; Calculating Time between Two Dates with the DATEDIF Function; Chapter 13: Keeping Well-Timed Functions Understanding How Excel Handles Time |
Altri titoli varianti |
Excel 2007 formulas & functions for dummies
Microsoft Office Excel 2007 formulas and functions for dummies |
Record Nr. | UNINA-9910814807003321 |
Bluttman Ken
![]() |
||
Hoboken, N.J., : Wiley, c2007 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Modeling for insight [[electronic resource] ] : a master class for business analysts / / Stephen G. Powell, Robert J. Batt |
Autore | Powell Stephen G |
Pubbl/distr/stampa | Hoboken, NJ, : John Wiley & Sons, c2008 |
Descrizione fisica | 1 online resource (496 p.) |
Disciplina |
658.4
658.40352 |
Altri autori (Persone) | BattRobert J |
Soggetto topico |
Decision making
Business planning Business - Computer simulation Electronic spreadsheets |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-21048-4
1-281-93759-2 9786611937591 0-470-38720-3 0-470-38719-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
MODELING FOR INSIGHT; CONTENTS; PREFACE; USING THIS BOOK; ACKNOWLEDGMENTS; ACKNOWLEDGMENTS FOR CASES; ABOUT THE AUTHORS; PART I; 1. Introduction; 2. Foundations of Modeling for Insight; 3. Spreadsheet Engineering; PART II; 4. A First Example-The Red Cross Problem; 5. Retirement Planning Problem; 6. Technology Option; PART III; 7. MediDevice; 8. Draft Commercials; 9. New England College Skiway; 10. National Leasing, Inc.; 11. Pharma X and Pharma Y; 12. Invivo Diagnostics, Inc.; Appendix A: Guide to Solver(®); Appendix B: Guide to Crystal Ball(®); Appendix C: Guide to the Sensitivity Toolkit
INDEX |
Record Nr. | UNINA-9910144116603321 |
Powell Stephen G
![]() |
||
Hoboken, NJ, : John Wiley & Sons, c2008 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Modeling for insight [[electronic resource] ] : a master class for business analysts / / Stephen G. Powell, Robert J. Batt |
Autore | Powell Stephen G |
Pubbl/distr/stampa | Hoboken, NJ, : John Wiley & Sons, c2008 |
Descrizione fisica | 1 online resource (496 p.) |
Disciplina |
658.4
658.40352 |
Altri autori (Persone) | BattRobert J |
Soggetto topico |
Decision making
Business planning Business - Computer simulation Electronic spreadsheets |
ISBN |
1-118-21048-4
1-281-93759-2 9786611937591 0-470-38720-3 0-470-38719-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
MODELING FOR INSIGHT; CONTENTS; PREFACE; USING THIS BOOK; ACKNOWLEDGMENTS; ACKNOWLEDGMENTS FOR CASES; ABOUT THE AUTHORS; PART I; 1. Introduction; 2. Foundations of Modeling for Insight; 3. Spreadsheet Engineering; PART II; 4. A First Example-The Red Cross Problem; 5. Retirement Planning Problem; 6. Technology Option; PART III; 7. MediDevice; 8. Draft Commercials; 9. New England College Skiway; 10. National Leasing, Inc.; 11. Pharma X and Pharma Y; 12. Invivo Diagnostics, Inc.; Appendix A: Guide to Solver(®); Appendix B: Guide to Crystal Ball(®); Appendix C: Guide to the Sensitivity Toolkit
INDEX |
Record Nr. | UNINA-9910830051503321 |
Powell Stephen G
![]() |
||
Hoboken, NJ, : John Wiley & Sons, c2008 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Modeling for insight : a master class for business analysts / / Stephen G. Powell, Robert J. Batt |
Autore | Powell Stephen G |
Pubbl/distr/stampa | Hoboken, NJ, : John Wiley & Sons, c2008 |
Descrizione fisica | 1 online resource (496 p.) |
Disciplina |
658.4
658.40352 |
Altri autori (Persone) | BattRobert J |
Soggetto topico |
Decision making
Business planning Business - Computer simulation Electronic spreadsheets |
ISBN |
1-118-21048-4
1-281-93759-2 9786611937591 0-470-38720-3 0-470-38719-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
MODELING FOR INSIGHT; CONTENTS; PREFACE; USING THIS BOOK; ACKNOWLEDGMENTS; ACKNOWLEDGMENTS FOR CASES; ABOUT THE AUTHORS; PART I; 1. Introduction; 2. Foundations of Modeling for Insight; 3. Spreadsheet Engineering; PART II; 4. A First Example-The Red Cross Problem; 5. Retirement Planning Problem; 6. Technology Option; PART III; 7. MediDevice; 8. Draft Commercials; 9. New England College Skiway; 10. National Leasing, Inc.; 11. Pharma X and Pharma Y; 12. Invivo Diagnostics, Inc.; Appendix A: Guide to Solver(®); Appendix B: Guide to Crystal Ball(®); Appendix C: Guide to the Sensitivity Toolkit
INDEX |
Record Nr. | UNINA-9910876629603321 |
Powell Stephen G
![]() |
||
Hoboken, NJ, : John Wiley & Sons, c2008 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Next generation Excel [[electronic resource] ] : modeling in Microsoft Excel for analysts and MBAs (for Windows and Mac OS) / / Isaac Gottlieb |
Autore | Gottlieb Isaac |
Edizione | [2nd ed.] |
Pubbl/distr/stampa | Singapore, : Wiley, 2013 |
Descrizione fisica | 1 online resource (418 p.) |
Disciplina | 657.0285554 |
Collana | Wiley finance series |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-119-19898-4
1-118-46908-9 1-118-46909-7 1-299-18686-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Using Excel efficiently -- pt. 2. IF functions and text manipulations -- pt. 3. Statistical tools -- pt. 4. What-if analysis -- pt. 5. Multi-page systems and lookups -- pt. 6. The data menu and ribbon -- pt. 7. Excel financial tools -- pt. 8. Using the solver add-in. |
Record Nr. | UNINA-9910138858603321 |
Gottlieb Isaac
![]() |
||
Singapore, : Wiley, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Next generation Excel : modeling in Microsoft Excel for analysts and MBAs (for Windows and Mac OS) / / Isaac Gottlieb |
Autore | Gottlieb Isaac |
Edizione | [2nd ed.] |
Pubbl/distr/stampa | Singapore, : Wiley, 2013 |
Descrizione fisica | 1 online resource (418 p.) |
Disciplina | 657.0285554 |
Collana | Wiley finance series |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-119-19898-4
1-118-46908-9 1-118-46909-7 1-299-18686-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Using Excel efficiently -- pt. 2. IF functions and text manipulations -- pt. 3. Statistical tools -- pt. 4. What-if analysis -- pt. 5. Multi-page systems and lookups -- pt. 6. The data menu and ribbon -- pt. 7. Excel financial tools -- pt. 8. Using the solver add-in. |
Altri titoli varianti | Modeling in Microsoft Excel for analysts and MBAs (for Windows and Mac OS) |
Record Nr. | UNINA-9910821367903321 |
Gottlieb Isaac
![]() |
||
Singapore, : Wiley, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Next generation Excel [[electronic resource] ] : modeling in Excel for analysts and MBAs / / Isaac Gottlieb |
Autore | Gottlieb Isaac <1949-> |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2010 |
Descrizione fisica | 1 online resource (435 p.) |
Disciplina | 005.54 |
Collana | Wiley finance series |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-17736-3
1-283-33262-0 9786613332622 1-118-39049-0 1-118-17734-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Using Excel efficiently -- pt. 2. IF functions and text manipulations -- pt. 3. Statistical tools -- pt. 4. What-if analysis -- pt. 5. Multi-page systems and lookups -- pt. 6. The data menu and ribbon -- pt. 7. Excel financial tools -- pt. 8. Using the solver add-in. |
Record Nr. | UNINA-9910130557303321 |
Gottlieb Isaac <1949->
![]() |
||
Hoboken, N.J., : Wiley, c2010 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Next generation Excel [[electronic resource] ] : modeling in Excel for analysts and MBAs / / Isaac Gottlieb |
Autore | Gottlieb Isaac <1949-> |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2010 |
Descrizione fisica | 1 online resource (435 p.) |
Disciplina | 005.54 |
Collana | Wiley finance series |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-118-17736-3
1-283-33262-0 9786613332622 1-118-39049-0 1-118-17734-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Using Excel efficiently -- pt. 2. IF functions and text manipulations -- pt. 3. Statistical tools -- pt. 4. What-if analysis -- pt. 5. Multi-page systems and lookups -- pt. 6. The data menu and ribbon -- pt. 7. Excel financial tools -- pt. 8. Using the solver add-in. |
Record Nr. | UNINA-9910830715403321 |
Gottlieb Isaac <1949->
![]() |
||
Hoboken, N.J., : Wiley, c2010 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Next generation Excel : modeling in Excel for analysts and MBAs / / Isaac Gottlieb |
Autore | Gottlieb Isaac <1949-> |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2010 |
Descrizione fisica | 1 online resource (435 p.) |
Disciplina | 005.54 |
Collana | Wiley finance series |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-118-17736-3
1-283-33262-0 9786613332622 1-118-39049-0 1-118-17734-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Using Excel efficiently -- pt. 2. IF functions and text manipulations -- pt. 3. Statistical tools -- pt. 4. What-if analysis -- pt. 5. Multi-page systems and lookups -- pt. 6. The data menu and ribbon -- pt. 7. Excel financial tools -- pt. 8. Using the solver add-in. |
Record Nr. | UNINA-9910877539803321 |
Gottlieb Isaac <1949->
![]() |
||
Hoboken, N.J., : Wiley, c2010 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|