LEADER 05317nam 22006494a 450 001 9910555227103321 005 20230617020450.0 010 $a1-280-35369-4 010 $a9786610353699 010 $a0-7645-5575-8 035 $a(CKB)111090425032348 035 $a(EBL)469174 035 $a(OCoLC)55750907 035 $a(SSID)ssj0000151706 035 $a(PQKBManifestationID)12036263 035 $a(PQKBTitleCode)TC0000151706 035 $a(PQKBWorkID)10321200 035 $a(PQKB)11721837 035 $a(MiAaPQ)EBC469174 035 $a(EXLCZ)99111090425032348 100 $a20030205d2003 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel programming weekend crash course /$fPeter G. Aitken 205 $a1st ed. 210 $aIndianapolis, IN $cWiley Pub.$dc2003 215 $a1 online resource (457 p.) 225 1 $aWeekend Crash Course 300 $a"Use with Excel 2003, Excel 2002, or Excel 2000"--Cover. 300 $aIncludes index. 311 $a0-7645-4062-9 327 $aExcel 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 327 $aThe 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 327 $aP 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 327 $aSession 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 327 $aP 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 327 $aUsing Excel Functions in Formulas 330 $aThirty 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 410 0$aWeekend Crash Course 606 $aBusiness$xComputer programs 606 $aElectronic spreadsheets 606 $aComputer software$xProgramming 615 0$aBusiness$xComputer programs. 615 0$aElectronic spreadsheets. 615 0$aComputer software$xProgramming. 676 $a005.54 700 $aAitken$b Peter G$042713 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910555227103321 996 $aExcel programming weekend crash course$92816202 997 $aUNINA