Master visually Excel 2007 [[electronic resource] /] / by Elaine Marmel |
Autore | Marmel Elaine J |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub. |
Descrizione fisica | 1 online resource (801 p.) |
Disciplina | 005.54 |
Collana | Visual read less, learn more |
Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
ISBN |
1-281-28584-6
9786611285845 0-470-38525-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Master Visually Excel 2007; Credits; About the Author; Author's Acknowledgments; WHAT'S INSIDE; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Part I: EXCEL BASICS; What You Can Do in Excel; Start and Close Excel; Understanding the Excel Screen; Learn Excel Terminology; Understanding the Ribbon; Work with the Mini Toolbar and Context Menu; Enter Information; Undo and Redo; Move Around in a Worksheet; Chapter 1: Getting Started with Excel; Move Around in a Workbook; Manage the Status Bar; Chapter 2: Managing Workbooks; Save a Workbook; Open a Workbook
Convert an Excel 97-2003 Workbook to an Excel 2007 Workbook Start a New Workbook; Switch between Workbooks; Work with Workspaces; Add Properties to a Workbook; Close a Workbook; Chapter 3: Formatting Cells; Change Fonts or Font Size; Apply Boldface, Italics, or Underlining; Change Font Color; Apply Font Effects; Assign a Number Format; Assign a Currency Format; Assign an Accounting Format; Assign a Short Date Format; Assign a Long Date Format; Assign a Time Format; Assign a General Format; Assign a Percentage Format; Assign a Fraction Format; Assign a Scientific Format; Assign a Text Format Assign a Special Format Assign a Custom Format; Fill Cells with Color; Indent Text within Cells; Align Cell Content Vertically; Align Cell Content Horizontally; Wrap Text within Cells; Shrink Text within Cells; Rotate Text in Cells; Add Borders to Cells; Apply a Style; Create a Style; Copy Formatting; Clear Formatting; Part II: DESIGNING WORKSHEETS; Chapter 4: Editing Worksheets; Base a Worksheet on a Template; Apply a Theme; Mix and Match Themes; Select Cells; Move or Copy Information; Find and Replace Information; Chapter 5: Proofreading a Worksheet; Check Spelling; Edit the Dictionary Translate Text Using the Thesaurus; Research Online; Chapter 6: Adjusting Worksheets; Insert and Delete Rows; Insert and Delete Columns; Swap Rows and Columns; Adjust Row Height; Adjust Column Width; Copy Width from One Column to Another; Hide and Unhide Rows or Columns; Merge Cells in Columns or Rows; Chapter 7: Managing Workbook Structure; Set Worksheet Tab Colors; Edit Multiple Worksheets Simultaneously; Add or Delete a Worksheet; Move or Copy a Worksheet; Rename a Worksheet; Hide and Unhide a Worksheet; Hide and Unhide a Workbook; Arrange Open Worksheets or Workbooks Switch to Another Workbook Merge Styles; Outline a Worksheet; Work with Custom Views of Outline Settings; Manually Create an Outline; Remove an Outline; Chapter 8: Working with Views; Switch Views; Zoom In and Zoom Out; Create and Use a Custom View; Hide or Display Gridlines; Hide or Display Row Numbers and Column Letters; Hide or Display the Formula Bar; Open a New Window; Freeze Column and Row Titles; Split a Window; Chapter 9: Printing Worksheet Information; Set Margins; Add Headers and Footers to a Worksheet; Select an Area to Print; Insert, Adjust, or Remove Page Breaks Set Page Orientation |
Altri titoli varianti |
Excel 2007
Master visually Microsoft Office Excel 2007 |
Record Nr. | UNINA-9910784817903321 |
Marmel Elaine J
![]() |
||
Indianapolis, IN, : Wiley Pub. | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Master visually Excel 2007 [[electronic resource] /] / by Elaine Marmel |
Autore | Marmel Elaine J |
Edizione | [1st edition] |
Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub. |
Descrizione fisica | 1 online resource (801 p.) |
Disciplina | 005.54 |
Collana | Visual read less, learn more |
Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
ISBN |
1-281-28584-6
9786611285845 0-470-38525-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Master Visually Excel 2007; Credits; About the Author; Author's Acknowledgments; WHAT'S INSIDE; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Part I: EXCEL BASICS; What You Can Do in Excel; Start and Close Excel; Understanding the Excel Screen; Learn Excel Terminology; Understanding the Ribbon; Work with the Mini Toolbar and Context Menu; Enter Information; Undo and Redo; Move Around in a Worksheet; Chapter 1: Getting Started with Excel; Move Around in a Workbook; Manage the Status Bar; Chapter 2: Managing Workbooks; Save a Workbook; Open a Workbook
Convert an Excel 97-2003 Workbook to an Excel 2007 Workbook Start a New Workbook; Switch between Workbooks; Work with Workspaces; Add Properties to a Workbook; Close a Workbook; Chapter 3: Formatting Cells; Change Fonts or Font Size; Apply Boldface, Italics, or Underlining; Change Font Color; Apply Font Effects; Assign a Number Format; Assign a Currency Format; Assign an Accounting Format; Assign a Short Date Format; Assign a Long Date Format; Assign a Time Format; Assign a General Format; Assign a Percentage Format; Assign a Fraction Format; Assign a Scientific Format; Assign a Text Format Assign a Special Format Assign a Custom Format; Fill Cells with Color; Indent Text within Cells; Align Cell Content Vertically; Align Cell Content Horizontally; Wrap Text within Cells; Shrink Text within Cells; Rotate Text in Cells; Add Borders to Cells; Apply a Style; Create a Style; Copy Formatting; Clear Formatting; Part II: DESIGNING WORKSHEETS; Chapter 4: Editing Worksheets; Base a Worksheet on a Template; Apply a Theme; Mix and Match Themes; Select Cells; Move or Copy Information; Find and Replace Information; Chapter 5: Proofreading a Worksheet; Check Spelling; Edit the Dictionary Translate Text Using the Thesaurus; Research Online; Chapter 6: Adjusting Worksheets; Insert and Delete Rows; Insert and Delete Columns; Swap Rows and Columns; Adjust Row Height; Adjust Column Width; Copy Width from One Column to Another; Hide and Unhide Rows or Columns; Merge Cells in Columns or Rows; Chapter 7: Managing Workbook Structure; Set Worksheet Tab Colors; Edit Multiple Worksheets Simultaneously; Add or Delete a Worksheet; Move or Copy a Worksheet; Rename a Worksheet; Hide and Unhide a Worksheet; Hide and Unhide a Workbook; Arrange Open Worksheets or Workbooks Switch to Another Workbook Merge Styles; Outline a Worksheet; Work with Custom Views of Outline Settings; Manually Create an Outline; Remove an Outline; Chapter 8: Working with Views; Switch Views; Zoom In and Zoom Out; Create and Use a Custom View; Hide or Display Gridlines; Hide or Display Row Numbers and Column Letters; Hide or Display the Formula Bar; Open a New Window; Freeze Column and Row Titles; Split a Window; Chapter 9: Printing Worksheet Information; Set Margins; Add Headers and Footers to a Worksheet; Select an Area to Print; Insert, Adjust, or Remove Page Breaks Set Page Orientation |
Altri titoli varianti |
Excel 2007
Master visually Microsoft Office Excel 2007 |
Record Nr. | UNINA-9910828905303321 |
Marmel Elaine J
![]() |
||
Indianapolis, IN, : Wiley Pub. | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Mastering Excel 2003 [[electronic resource] ] : programming with VBA / / Steven M. Hansen |
Autore | Hansen Steve |
Pubbl/distr/stampa | San Francisco, : SYBEX, 2004 |
Descrizione fisica | 1 online resource (606 p.) |
Disciplina |
005.369
005.54 |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
Soggetto genere / forma | Electronic books. |
ISBN |
1-280-52218-6
9786610522187 0-7821-5105-1 1-4175-0798-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Contents; Introduction; Part 1 Introduction to Excel Development; Chapter 1 Excel as a Development Platform; Who Develops in Excel?; What Is an Excel Application?; Why Use Excel?; Stop When You See Red; Summary; Chapter 2 Getting to Know Your Environment; One Exceptional Editor; Managing Your Modules; Optimizing Your Editor; Helpful Editor Features; Understated Features of the Code Window; Object Inspection Using the Object Browser; Obtaining Help Has Never Been So Easy; Securing Your Project; Quick Code Navigation; Summary; Chapter 3 Getting Started with VBA; Thinking Like a Computer
VBA Building BlocksVariables Are the Elements You Interact With; Operators; Directing Your Program with Statements; Basic Array Usage; Objects-A Human-Friendly Way to Think of Bits and Bytes; Summary; Chapter 4 Debugging Tactics that Work; A Bug Epidemic; Debugging Weapons in the VBE; A Simple Debugging Methodology; Implementing Simple Error Handling; Summary; Part 2 Mastering the Excel Object Model; Chapter 5 Exploring the Application Object; A Bird's-Eye View of the Application Object; Display-Oriented Features You Have to Know; Display-Oriented Features That Are Nice to know Convenient Excel Object PropertiesCommon File Operations Simplified; Inspecting Your Operating Environment; Two Useful Bonus Members; Summary; Chapter 6 Working with the Workbook Object; Walk before You Run: Opening and Closing Workbooks; Is That Workbook Open?; Untangle Links Programmatically (Part I); Plain Vanilla Workbook Properties; Respond to User Actions with Events; Summary; Chapter 7 Winning with Worksheets; Setting the Stage; Validating Your Worksheets before Using Them; Now You See It, Now You Don't; Lock Up Your Valuables; Managing Workbook Worksheets Expounding on Worksheet EventsSummary; Chapter 8 The Most Important Object; Referring to Ranges; Finding My Way; Input Easy; Output Easier; Summary; Chapter 9 Practical Range Operations; Data Mobility with Cut, Copy, and Paste; Find What You Are Seeking; Don't Like It? Change It with Replace; Would You Like Special Sauce with That?; CurrentRegion: A Useful Shortcut; Sorting Lists Simplified; Summary; Chapter 10 Exploring Other Excel Objects; Make a Good First Impression; Chart Manipulation; Summary; Part 3 Advanced Excel Programming Techniques; Chapter 11 Developing Class Modules Class Modules Are for Creating ObjectsA Linguistic Foundation; What's the Big Deal? Why Use Objects?; Creating a Simple Object; Using Your Object; A Better, Smarter Object; An Object Showdown; Collecting Your Objects; Implementing More Accurate Properties; Summary; Chapter 12 Adding User Personalization to Your Application; The Need for Persistence; Class Semi-Specification; Planning the Plumbing; Security Considerations; The Setting Class; Collect Those Setting Objects with Settings; Pseudo? Says Who?; Put Those Settings to Work; Summary; Chapter 13 Excel Development Best Practices Deactivate Activate |
Record Nr. | UNINA-9910456026503321 |
Hansen Steve
![]() |
||
San Francisco, : SYBEX, 2004 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Mastering Excel 2003 [[electronic resource] ] : programming with VBA / / Steven M. Hansen |
Autore | Hansen Steve |
Pubbl/distr/stampa | San Francisco, : SYBEX, 2004 |
Descrizione fisica | 1 online resource (606 p.) |
Disciplina |
005.369
005.54 |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-280-52218-6
9786610522187 0-7821-5105-1 1-4175-0798-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Contents; Introduction; Part 1 Introduction to Excel Development; Chapter 1 Excel as a Development Platform; Who Develops in Excel?; What Is an Excel Application?; Why Use Excel?; Stop When You See Red; Summary; Chapter 2 Getting to Know Your Environment; One Exceptional Editor; Managing Your Modules; Optimizing Your Editor; Helpful Editor Features; Understated Features of the Code Window; Object Inspection Using the Object Browser; Obtaining Help Has Never Been So Easy; Securing Your Project; Quick Code Navigation; Summary; Chapter 3 Getting Started with VBA; Thinking Like a Computer
VBA Building BlocksVariables Are the Elements You Interact With; Operators; Directing Your Program with Statements; Basic Array Usage; Objects-A Human-Friendly Way to Think of Bits and Bytes; Summary; Chapter 4 Debugging Tactics that Work; A Bug Epidemic; Debugging Weapons in the VBE; A Simple Debugging Methodology; Implementing Simple Error Handling; Summary; Part 2 Mastering the Excel Object Model; Chapter 5 Exploring the Application Object; A Bird's-Eye View of the Application Object; Display-Oriented Features You Have to Know; Display-Oriented Features That Are Nice to know Convenient Excel Object PropertiesCommon File Operations Simplified; Inspecting Your Operating Environment; Two Useful Bonus Members; Summary; Chapter 6 Working with the Workbook Object; Walk before You Run: Opening and Closing Workbooks; Is That Workbook Open?; Untangle Links Programmatically (Part I); Plain Vanilla Workbook Properties; Respond to User Actions with Events; Summary; Chapter 7 Winning with Worksheets; Setting the Stage; Validating Your Worksheets before Using Them; Now You See It, Now You Don't; Lock Up Your Valuables; Managing Workbook Worksheets Expounding on Worksheet EventsSummary; Chapter 8 The Most Important Object; Referring to Ranges; Finding My Way; Input Easy; Output Easier; Summary; Chapter 9 Practical Range Operations; Data Mobility with Cut, Copy, and Paste; Find What You Are Seeking; Don't Like It? Change It with Replace; Would You Like Special Sauce with That?; CurrentRegion: A Useful Shortcut; Sorting Lists Simplified; Summary; Chapter 10 Exploring Other Excel Objects; Make a Good First Impression; Chart Manipulation; Summary; Part 3 Advanced Excel Programming Techniques; Chapter 11 Developing Class Modules Class Modules Are for Creating ObjectsA Linguistic Foundation; What's the Big Deal? Why Use Objects?; Creating a Simple Object; Using Your Object; A Better, Smarter Object; An Object Showdown; Collecting Your Objects; Implementing More Accurate Properties; Summary; Chapter 12 Adding User Personalization to Your Application; The Need for Persistence; Class Semi-Specification; Planning the Plumbing; Security Considerations; The Setting Class; Collect Those Setting Objects with Settings; Pseudo? Says Who?; Put Those Settings to Work; Summary; Chapter 13 Excel Development Best Practices Deactivate Activate |
Record Nr. | UNINA-9910780447603321 |
Hansen Steve
![]() |
||
San Francisco, : SYBEX, 2004 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Mastering Excel 2003 : programming with VBA / / Steven M. Hansen |
Autore | Hansen Steve |
Edizione | [1st ed.] |
Pubbl/distr/stampa | San Francisco, : SYBEX, 2004 |
Descrizione fisica | 1 online resource (606 p.) |
Disciplina |
005.369
005.54 |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN |
1-280-52218-6
9786610522187 0-7821-5105-1 1-4175-0798-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Contents; Introduction; Part 1 Introduction to Excel Development; Chapter 1 Excel as a Development Platform; Who Develops in Excel?; What Is an Excel Application?; Why Use Excel?; Stop When You See Red; Summary; Chapter 2 Getting to Know Your Environment; One Exceptional Editor; Managing Your Modules; Optimizing Your Editor; Helpful Editor Features; Understated Features of the Code Window; Object Inspection Using the Object Browser; Obtaining Help Has Never Been So Easy; Securing Your Project; Quick Code Navigation; Summary; Chapter 3 Getting Started with VBA; Thinking Like a Computer
VBA Building BlocksVariables Are the Elements You Interact With; Operators; Directing Your Program with Statements; Basic Array Usage; Objects-A Human-Friendly Way to Think of Bits and Bytes; Summary; Chapter 4 Debugging Tactics that Work; A Bug Epidemic; Debugging Weapons in the VBE; A Simple Debugging Methodology; Implementing Simple Error Handling; Summary; Part 2 Mastering the Excel Object Model; Chapter 5 Exploring the Application Object; A Bird's-Eye View of the Application Object; Display-Oriented Features You Have to Know; Display-Oriented Features That Are Nice to know Convenient Excel Object PropertiesCommon File Operations Simplified; Inspecting Your Operating Environment; Two Useful Bonus Members; Summary; Chapter 6 Working with the Workbook Object; Walk before You Run: Opening and Closing Workbooks; Is That Workbook Open?; Untangle Links Programmatically (Part I); Plain Vanilla Workbook Properties; Respond to User Actions with Events; Summary; Chapter 7 Winning with Worksheets; Setting the Stage; Validating Your Worksheets before Using Them; Now You See It, Now You Don't; Lock Up Your Valuables; Managing Workbook Worksheets Expounding on Worksheet EventsSummary; Chapter 8 The Most Important Object; Referring to Ranges; Finding My Way; Input Easy; Output Easier; Summary; Chapter 9 Practical Range Operations; Data Mobility with Cut, Copy, and Paste; Find What You Are Seeking; Don't Like It? Change It with Replace; Would You Like Special Sauce with That?; CurrentRegion: A Useful Shortcut; Sorting Lists Simplified; Summary; Chapter 10 Exploring Other Excel Objects; Make a Good First Impression; Chart Manipulation; Summary; Part 3 Advanced Excel Programming Techniques; Chapter 11 Developing Class Modules Class Modules Are for Creating ObjectsA Linguistic Foundation; What's the Big Deal? Why Use Objects?; Creating a Simple Object; Using Your Object; A Better, Smarter Object; An Object Showdown; Collecting Your Objects; Implementing More Accurate Properties; Summary; Chapter 12 Adding User Personalization to Your Application; The Need for Persistence; Class Semi-Specification; Planning the Plumbing; Security Considerations; The Setting Class; Collect Those Setting Objects with Settings; Pseudo? Says Who?; Put Those Settings to Work; Summary; Chapter 13 Excel Development Best Practices Deactivate Activate |
Record Nr. | UNINA-9910823013903321 |
Hansen Steve
![]() |
||
San Francisco, : SYBEX, 2004 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Microsoft Excel 2010 in simple steps / / Greg Holden and Patti Short |
Autore | Holden Greg |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Harlow, England : , : Prentice Hall, , [2010] |
Descrizione fisica | 1 online resource (236 p. ) : col. ill |
Disciplina | 005.54 |
Soggetto topico | Electronic spreadsheets |
ISBN |
1-282-98367-9
9786612983672 0-273-73678-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Top 10 Excel 2010 Tips Chapter 1 Starting to Use Excel Chapter 2 Learning Essential Workbook Techniques Chapter 3 Managing Workbooks and Worksheets Chapter 4 Creating Formulas and Functions Chapter 5 Working with Charts Chapter 6 Interpreting Worksheet Data with Tables Chapter 7 Creating and Modifying Graphics and Shapes Chapter 8 Publishing Workbooks and Worksheets Chapter 9 Protecting and Securing your Data Chapter 10 Sharing your Data with your Colleagues Top 10 Excel 2010 Problems Solved |
Record Nr. | UNINA-9910150239303321 |
Holden Greg
![]() |
||
Harlow, England : , : Prentice Hall, , [2010] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
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 |
Soggetto genere / forma | Electronic books. |
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-9910450803403321 |
Bluttman Ken
![]() |
||
Hoboken, N.J., : Wiley, c2007 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
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 [[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-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 | ||
|