Autore	Bluttman Ken
Edizione	[3rd ed.]
Pubbl/distr/stampa	Indianapolis, Ind., : John Wiley & Sons, Inc., 2013
Descrizione fisica	1 online resource (410 p.)
Disciplina	005.54
Collana	--For dummies Excel formulas and functions for dummies
Soggetto topico	Electronic spreadsheets Business - Computer programs
ISBN	1-118-46085-5 1-299-24191-3 1-118-46089-8
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	pt. 1. Putting the fun in functions -- pt. 2. Doing the math -- pt. 3. Solving with statistics -- pt. 4. Working with data -- pt. 5. The part of tens.
Record Nr.	UNINA-9910792080503321

Autore	Floria, Gianclaudio
Pubbl/distr/stampa	Milano : Tecniche nuove, c2008
Descrizione fisica	XI, 467 p. ; 24 cm
Disciplina	005.54
Collana	I manuali
Soggetto non controllato	Analisi dei dati Microelaboratori elettroniciProgrammi Microsoft Excel
ISBN	978-88-481-2248-1
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	ita
Titolo uniforme
Record Nr.	UNIPARTHENOPE-000028369

Autore	Aitken Peter G
Edizione	[1st ed.]
Pubbl/distr/stampa	Indianapolis, IN, : Wiley Pub., c2003
Descrizione fisica	1 online resource (457 p.)
Disciplina	005.54
Collana	Weekend Crash Course
Soggetto topico	Business - Computer programs Electronic spreadsheets Computer software - Programming
ISBN	1-280-35369-4 9786610353699 0-7645-5575-8
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Excel Programming Weekend Crash Course; About the Author; Preface; Who Should Read This Book; Weekend Crash Course Layout and Features; Acknowledgments; Contents at a Glance; Contents; P A R T I: Friday Evening; Session 1: Microsoft Excel Programming - Why and How; Advantages of Programming; Programming Fundamentals; The VBA Language; The Excel Object Model; Objects and Classes; Macros and Programming; Designing Your Custom Application; Your First Excel Program; Programs and Procedures; Running the Program; Session 2: The VBA Code Editor; Code and Project Organization; Editing Tools The Property WindowThe VBA Editor Menus; The Immediate Window; Using Macros in Programming; Session 3: The Excel Object Model; Understanding Properties and Methods; The Importance of Object References; Working with Collections; The Object Hierarchy; The Workbook Object; The Worksheet Object; The Usefulness of Nothing; Session 4: Syntax and Data in VBA; VBA Syntax Fundamentals; Employing Constants; Declaring and Using Variables; VBA Naming Rules; Variable Declaration and Option Explicit; Using Arrays; Determining Array Size; Understanding Variable Scope; P A R T I: Friday Evening Part Review P A R T II: Saturday MorningSession 5: Operators; The Assignment Operator; Numerical Operators; String Operators; Logical Operators; Comparison Operators; Operator Precedence; Session 6: Control Constructs; The If... Then Statement; With... End With; The Select Case Statement; The IIf Function; The Do... Loop Statement; The For... Next Statement; Stopping an Infinite Loop; The For Each... Next Statement; The Goto Statement; Session 7: Procedures and Modules; Sub Procedures; The Insert; Procedure Command; Function Procedures; Variables in Procedures; Procedure Scope; Storing Procedures Session 8: Working with Dates and TimesThe Date Data Type; Date/Time Values; Dates and System Settings; Date Calculations; The System Date and Time; Date and Time Details; Formatting Date/Time Values; Session 9: Working with Text; Text Input and Output; Searching for Text; Comparing Strings; String Conversions; Working with ASCII Values; Displaying Unicode Characters; Extracting or Modifying Parts of Strings; Session 10: Using Ranges and Selections; The Range Object; Empty Cells; Reading Data from Ranges; Naming Ranges; The Selection Property; Display a Range to the User P A R T II: Saturday Morning Part ReviewP A R T III: Saturday Afternoon; Session 11: Working with Columns, Rows, and Cells; Referencing Cells with the Cells Property; The SpecialCells Method; Screen Updating; Manipulating Columns and Rows; Referencing Entire Rows and Columns; Adding and Deleting Rows and Columns; Session 12: Programming with Custom Formulas; Cell References in Formulas; Use Caution When Using Links Between Workbooks; Operators; Avoiding Circular References; Controlling Formula Calculation; Session 13: Programming with Excel's Built-In Functions; Excel's Built-in Functions Using Excel Functions in Formulas
Record Nr.	UNINA-9910555227103321

Autore	Walkenbach John
Edizione	[2nd ed.]
Pubbl/distr/stampa	Hoboken, New Jersey : , : Wiley Publishing, Inc., , 2010
Descrizione fisica	1 online resource (432 p.)
Disciplina	005.368/2 005.54
Collana	For Dummies
Soggetto topico	Electronic spreadsheets Business - Computer programs
Soggetto genere / forma	Electronic books.
ISBN	1-282-68510-4 9786612685101 1-118-25765-0 0-470-63275-5
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Excel® VBA Programming For Dummies®, 2nd Edition; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; Is This the Right Book?; So You Want to Be a Programmer . . .; Why Bother?; What I Assume about You; Obligatory Typographical Conventions Section; Check Your Security Settings; How This Book Is Organized; Icons Used in This Book; Getting the Sample Files; Now What?; Part I: Introducing VBA; Chapter 1: What Is VBA?; Okay, So What Is VBA?; What Can You Do with VBA?; Advantages and Disadvantages of VBA; VBA in a Nutshell An Excursion into VersionsChapter 2: Jumping Right In; First Things First; What You'll Be Doing; Taking the First Steps; Recording the Macro; Testing the Macro; Examining the Macro; Modifying the Macro; Saving Workbooks That Contain Macros; Understanding Macro Security; More about the NameAndTime Macro; Part II: How VBA Works with Excel; Chapter 3: Working In the Visual Basic Editor; What Is the Visual Basic Editor?; Working with the Project Window; Working with a Code Window; Customizing the VBA Environment; Chapter 4: Introducing the Excel Object Model; Excel Is an Object? Climbing the Object HierarchyWrapping Your Mind around Collections; Referring to Objects; Diving into Object Properties and Methods; Finding Out More; Chapter 5: VBA Sub and Function Procedures; Subs versus Functions; Executing Sub procedures; Executing Function procedures; Chapter 6: Using the Excel Macro Recorder; Is It Live or Is It VBA?; Recording Basics; Preparing to Record; Relative or Absolute?; What Gets Recorded?; Recording Options; Is This Thing Efficient?; Part III: Programming Concepts; Chapter 7: Essential VBA Language Elements; Using Comments in Your VBA Code Using Variables, Constants, and Data TypesUsing Assignment Statements; Working with Arrays; Using Labels; Chapter 8: Working with Range Objects; A Quick Review; Other Ways to Refer to a Range; Some Useful Range Object Properties; Some Useful Range Object Methods; Chapter 9: Using VBA and Worksheet Functions; What Is a Function?; Using Built-In VBA Functions; Using Worksheet Functions in VBA; More about Using Worksheet Functions; Using Custom Functions; Chapter 10: Controlling Program Flow and Making Decisions; Going with the Flow, Dude; The GoTo Statement; Knocking Your Code for a Loop Looping through a CollectionChapter 11: Automatic Procedures and Events; Preparing for the Big Event; Where Does the VBA Code Go?; Writing an Event-Handler Procedure; Introductory Examples; Examples of Activation Events; Other Worksheet-Related Events; Events Not Associated with Objects; Chapter 12: Error-Handling Techniques; Types of Errors; An Erroneous Example; Handling Errors Another Way; Handling Errors: The Details; An Intentional Error; Chapter 13: Bug Extermination Techniques; Species of Bugs; Identifying Bugs; Debugging Techniques; About the Debugger; Bug Reduction Tips Chapter 14: VBA Programming Examples
Record Nr.	UNINA-9910140569703321

Autore	Alexander Michael
Edizione	[1st edition]
Pubbl/distr/stampa	Indianapolis, Indiana : , : Wiley, , 2016
Descrizione fisica	1 online resource (818 p.)
Disciplina	005.54
Collana	Mr. Spreadsheet's Bookshelf
Soggetto topico	Electronic spreadsheets - Computer programs
Soggetto genere / forma	Electronic books.
ISBN	1-119-06792-8
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Record Nr.	UNINA-9910460516103321