Excel programming weekend crash course / / Peter G. Aitken

• Record Nr.: UNINA9910555227103321
• Autore: Aitken Peter G
• Pubbl/distr/stampa: Indianapolis, IN, : Wiley Pub., c2003
• ISBN: 1-280-35369-4; 9786610353699; 0-7645-5575-8
• Edizione: [1st ed.]
• Descrizione fisica: 1 online resource (457 p.)
• Collana: Weekend Crash Course
• Disciplina: 005.54
• Soggetti: Business - Computer programs; Electronic spreadsheets; Computer software - Programming
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: "Use with Excel 2003, Excel 2002, or Excel 2000"--Cover.; Includes index.
• 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
• Sommario/riassunto: Thirty clearly defined lessons take the reader from understanding the parts of an Excel application into building applications to work with data, formulas, charts, and the enhanced XML capabilities of the new Excel ""X""Book is designed to teach the core concepts of Excel over a weekend or in just fifteen hours, with each session being thirty minutesApplicable to Excel 2000, Excel 2002, and the latest release, Excel 2003Helps Excel power users in fields such as accounting, finance, operations management, and market research to begin automating data manipulation in Excel qui