05317nam 22006494a 450 991055522710332120230617020450.01-280-35369-497866103536990-7645-5575-8(CKB)111090425032348(EBL)469174(OCoLC)55750907(SSID)ssj0000151706(PQKBManifestationID)12036263(PQKBTitleCode)TC0000151706(PQKBWorkID)10321200(PQKB)11721837(MiAaPQ)EBC469174(EXLCZ)9911109042503234820030205d2003 uy 0engur|n|---|||||txtccrExcel programming weekend crash course /Peter G. Aitken1st ed.Indianapolis, IN Wiley Pub.c20031 online resource (457 p.)Weekend Crash Course"Use with Excel 2003, Excel 2002, or Excel 2000"--Cover.Includes index.0-7645-4062-9 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 ToolsThe 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 ReviewP 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 ProceduresSession 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 UserP 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 FunctionsUsing Excel Functions in FormulasThirty 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 quiWeekend Crash CourseBusinessComputer programsElectronic spreadsheetsComputer softwareProgrammingBusinessComputer programs.Electronic spreadsheets.Computer softwareProgramming.005.54Aitken Peter G42713MiAaPQMiAaPQMiAaPQBOOK9910555227103321Excel programming weekend crash course2816202UNINA