Edizione	[1st edition]
Pubbl/distr/stampa	Indianapolis, IN., : Wiley Pub., c2004
Descrizione fisica	1 online resource (1176 p.)
Disciplina	005.54
Altri autori (Persone)	KimmelPaul
Collana	Programmer to programmer
Soggetto topico	Business - Computer programs Electronic spreadsheets Computer software - Development
ISBN	1-280-26598-1 9786610265985 0-7645-7898-7
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	About the Authors; Acknowledgments; Introduction; Chapter 1: Primer in Excel VBA; Using the Macro Recorder; Recording Macros; Running Macros; The Visual Basic Editor; Other Ways to Run Macros; User Defined Functions; Creating a UDF; What UDFs Cannot Do; The Excel Object Model; Objects; Getting Help; Experimenting in the Immediate Window; The VBA Language; Basic Input and Output; Calling Functions and Subroutines; Variable Declaration; Scope and Lifetime of Variables; Variable Type; Object Variables; Making Decisions; Looping; Arrays; Runtime Error Handling; Summary Chapter 2: Programming in the VBEWriting Code; Programming for People; Writing Code; Where Does My Code Go?; Managing a Project; Adding Classes; Modifying Properties; Importing and Exporting Visual Basic Code; Editing; Managing Editor Options; Running and Debugging Code; Using Watches; Using the Object Browser; Summary; Chapter 3: The Application Object; Globals; The Active Properties; Display Alerts; Screen Updating; Evaluate; InputBox; StatusBar; SendKeys; OnTime; OnKey; Worksheet Functions; Caller; Summary; Chapter 4: Object-Oriented Theory and VBA; Comparing Classes and Interfaces Defining an InterfaceImplementing an Interface; Defining Methods; Parameters; Implementing Recursive Methods; Eliminating Recursion with Loops; Defining Fields; Defining Properties; Defining Events; Defining Events in Classes; Raising Events; Handling Events; Information Hiding and Access Modifiers; Encapsulation, Aggregation, and References; Summary; Chapter 5: Event Procedures; Worksheet Events; Enable Events; Worksheet Calculate; Chart Events; Before Double Click; Workbook Events; Save Changes; Headers and Footers; Summary; Chapter 6: Class Modules; Creating Your Own Objects Using CollectionsClass Module Collection; Trapping Application Events; Embedded Chart Events; A Collection of UserForm Controls; Referencing Classes Across Projects; Summary; Chapter 7: Writing Bulletproof Code; Using Debug.Print; Using Debug.Assert; A Brief Exemplar of PC Debugging; Creating Reusable Tools with the Debug Object; Tracing Code Execution; Trapping Code Execution Paths; Asserting Application Invariants; Raising Errors; Writing Error Handlers; On Error Goto Line Number; On Error Resume Next; On Error GoTo 0; Using the Err Object; Scaffolding; Writing to the EventLog; Summary Chapter 8: Debugging and TestingStepping Through Code; Running Your Code; Stepping into Your Code; Step Over; Step Out; Run to Cursor; Set Next Statement; Show Next Statement; Using Breakpoints; Using Watches; Add Watch; Edit Watch; Quick Watch; Locals Windows; Testing an Expression in the Immediate Window; Resources for Finding Definitions; Edit => Quick Info; Edit => Parameter Info; Edit => Complete Word; Edit => List Properties/Methods; Edit => List Constants; Edit => Bookmarks; View => Definition; View => Object Browser; Viewing the Call Stack; Asserting Application Invariants; Summary Chapter 9: UserForms
Record Nr.	UNINA-9910806138303321

Autore	Etheridge Denise
Edizione	[1st edition]
Pubbl/distr/stampa	Hoboken, N.J., : Wiley, c2007
Descrizione fisica	1 online resource (305 p.)
Disciplina	005.54
Collana	Read less-learn more
Soggetto topico	Business - Computer software Spreadsheet software
Soggetto genere / forma	Electronic books.
ISBN	1-281-23789-2 9786611237899 0-470-37749-6
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and Pivot Tables; Credits; About the Author; Author's Acknowledgments; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Chapter 1: Getting Started; Introduction to Data Analysis with Excel; Understanding the Excel Window; Enter Data; Format Numbers; Format Cells; Select Data; Copy, Cut, and Paste Cells; Copy with the Office Clipboard; Insert and Delete Cells; Find and Replace; Find and Replace Formats; Chapter 2: Creating Formulas; Understanding Formulas; Create Formulas; Edit Formulas; Name Cells and Ranges Define and Display Constants Create Formulas that Include Names; Check Formulas for Errors; Trace Precedents and Dependents; Chapter 3: Creating and Using Functions; Understanding the Function Wizard; Round a Number; Determine the Nth Largest Value; Create a Conditional Formula; Calculate a Conditional Sum; Calculate Products and Square Roots; Look Up Information; Determine the Location of a Value; Perform Time Calculations; Perform Date Calculations; Chapter 4: Using Financial Functions; Calculate Future Value; Calculate Present Value; Calculate Loan Payments; Calculate Principal or Interest Calculate the Interest Rate Calculate the Internal Rate of Return; Calculate Straight-Line Depreciation; Calculate Declining Balance Depreciation; Calculate Double-Declining Balance Depreciation; Calculate Sum-of-the-Years-Digits Depreciation; Chapter 5: Using Statistical Functions and Tools; Calculate an Average; Calculate the Median or the Mode; Calculate Rank; Calculate Frequency; Calculate Variance and Standard Deviation; Find the Correlation; Install Excel Add-Ins; Calculate a Moving Average; Compare Variances; Using the Data Analysis Toolpak to Determine Rank and Percentile Calculate Descriptive Statistics Chapter 6: Organizing Worksheet Data; Enter Data with a Form; Filter Duplicate Records; Perform Simple Sorts and Filters; Perform Complex Sorts; Sort by Cell Color, Font Color, or Icon; Perform Complex Filters; Enter Criteria to Find Records; Filter by Multiple Criteria; Subtotal Sorted Data; Count Filtered Records; Define Data as a Table; Modify a Table Style; Chapter 7: Working with PivotTables; Create a PivotTable; Modify PivotTable Data and Layout; Compute Subtotals and Grand Totals; Create a Pivot Table Calculated Field; Hide Rows or Columns in a PivotTable Sort a PivotTable Retrieve Values from a PivotTable; Chapter 8: Charting Data; Create a Chart; Add Chart Details; Change the Chart Type; Add a Trendline; Add and Remove Chart Data; Add Error Bars; Create a Histogram; Chart Filtered Data; Create a PivotChart; Create a Combination Chart; Chapter 9: Working with External Data; Paste Link into Word; Embed a Worksheet; Hyperlink a Worksheet; Query a Web Site; Import a Text File; Import an Access Database; Query an Access Database; Chapter 10: Useful Data Analysis Tools and Techniques; Perform What-If Analysis; Optimize a Result with Goal Seek Solve a Formula with a Data Table
Record Nr.	UNINA-9910451195003321

Autore	Verschuuren G. M. N (Geert M. N.)
Edizione	[Rev. & expanded 2nd ed.]
Pubbl/distr/stampa	Uniontown, OH, : Holy Macro! Books, 2008
Descrizione fisica	1 online resource (275 p.)
Disciplina	005.360245 005.54
Collana	Excel for Professionals series
Soggetto topico	Electronic spreadsheets Engineering - Data processing Science - Data processing
Soggetto genere / forma	Electronic books.
ISBN	1-932802-66-5
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Front Cover; Contents; About the Author; Introduction; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Excercises - Part 1; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12; Chapter 13; Chapter 14; Chapter 15; Chapter 16; Chapter 17; Chapter 18; Chapter 19; Chapter 20; Excercises - Part 2; Chapter 21; Chapter 22; Chapter 23; Chapter 24; Chapter 25; Chapter 26; Chapter 27; Chapter 28; Chapter 29; Chapter 30; Chapter 31; Chapter 32; Excercises - Part 3; Chapter 33; Chapter 34; Chapter 35; Chapter 36; Chapter 37; Chapter 38; Chapter 39; Chapter 40; Chapter 41 Chapter 42Chapter 43; Chapter 44; Excercises - Part 4; Chapter 45; Chapter 46; Chapter 47; Chapter 48; Chapter 49; Chapter 50; Chapter 51; Chapter 52; Chapter 53; Chapter 54; Chapter 55; Chapter 56; Chapter 57; Excercises - Part 5; Index; Back Cover
Record Nr.	UNINA-9910453929803321

Autore	Salvaggio, Alessandra
Edizione	[2. ed.]
Pubbl/distr/stampa	Milano : Edizioni Fag, c2007
Descrizione fisica	293 p. ; 21 cm
Disciplina	005.54
Collana	Pro Digital LifeStyle
Soggetto non controllato	Microelaboratori elettroniciProgrammi Microsoft Excel per Windows
ISBN	978-88-8233-613-4
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	ita
Titolo uniforme
Record Nr.	UNIPARTHENOPE-000028489

Autore	Walkenbach John
Edizione	[1st edition]
Pubbl/distr/stampa	Hoboken, N.J., : Wiley
Descrizione fisica	1 online resource (1106 p.)
Disciplina	005.54
Collana	Mr. Spreadsheet's bookshelf
Soggetto topico	Visual programming (Computer science)
Soggetto genere / forma	Electronic books.
ISBN	1-281-73243-5 9786611732431 1-118-25759-6 0-470-15130-7
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Excel 2007 Power Programming with VBA; About the Author; Preface; Topics Covered; What You Need to Know; What You Need to Have; Conventions in This Book; What the Icons Mean; How This Book Is Organized; About the Companion CD-ROM; About the Power Utility Pak Offer; How to Use This Book; Reach Out; Contents at a Glance; Table of Contents; Part I: Some Essential Background; Chapter 1: Excel 2007: Where It Came From; A Brief History of Spreadsheets; Why Excel Is Great for Developers; Excel's Role in Microsoft's Strategy; Chapter 2: Excel in a Nutshell; Thinking in Terms of Objects; Workbooks Excel's User InterfaceCustomizing the Display; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features; Analysis Tools; Add-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 3: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Array Formulas; Counting and Summing Techniques; Working with Dates and Times; Creating Megaformulas; Chapter 4: Understanding Excel's Files; Starting Excel; File Types Working with Template FilesInside an Excel File; The QAT File; The XLB File; Add-In Files; Excel Settings in the Registry; Part II: Excel Application Development; Chapter 5: What Is a Spreadsheet Application?; Spreadsheet Applications; The Developer and the End User; Solving Problems with Excel; Basic Spreadsheet Types; Chapter 6: Essentials of Spreadsheet Application Development; Determining User Needs; Planning an Application That Meets User Needs; Determining the Most Appropriate User Interface; Concerning Yourself with the End User; Other Development Issues Part III: Understanding Visual Basic for ApplicationsChapter 7: Introducing Visual Basic for Applications; Some BASIC Background; About VBA; The Basics of VBA; Introducing the Visual Basic Editor; Working with the Project Explorer; Working with Code Windows; Customizing the VBE Environment; The Macro Recorder; About Objects and Collections; Properties and Methods; The Comment Object: A Case Study; Some Useful Application Properties; Working with Range Objects; Things to Know about Objects; Chapter 8: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments Variables, Data Types, and ConstantsAssignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 9: Working with VBA Sub Procedures; About Procedures; Executing Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 10: Creating Function Procedures; Sub Procedures versus Function Procedures; Why Create Custom Functions?; An Introductory Function Example; Function Procedures; Function Arguments; Function Examples Emulating Excel's SUM Function
Record Nr.	UNINA-9910144136703321