|
|
|
|
LEADER |
05428nmm a2200565 u 4500 |
001 |
EB002231586 |
003 |
EBX01000000000000001368544 |
005 |
00000000000000.0 |
007 |
cr||||||||||||||||||||| |
008 |
241008 ||| eng |
020 |
|
|
|a 1118991400
|
020 |
|
|
|a 9781118991411
|
020 |
|
|
|a 1118991370
|
020 |
|
|
|a 1118991419
|
020 |
|
|
|a 9781118991404
|
050 |
|
4 |
|a HF5548.4.M523
|
100 |
1 |
|
|a Urtis, Tom
|
245 |
0 |
0 |
|a Excel VBA
|b 24-hour trainer
|c Tom Urtis
|
246 |
3 |
1 |
|a twenty-four hour trainer
|
250 |
|
|
|a Second edition
|
260 |
|
|
|a Indianapolis, IN
|b Wrox, a Wiley brand
|c 2015
|
300 |
|
|
|a 1 online resource
|
505 |
0 |
|
|a Try ItLesson Requirements; Step-by-Step; Lesson 7: Understanding Objects and Collections; Workbooks; Cells and Ranges; SpecialCells; Try It; Lesson Requirements; Step-by-Step; Lesson 8: Working with Ranges; Working with Contiguously Populated Ranges; Using the Cells Property; Using CurrentRegion; Working with Noncontiguously Populated Ranges; Using Range with Several Cells; Using OFFSET; Using RESIZE; Identifying a Data Range; Identifying the UsedRange; Finding the Dynamic Last Rows and Columns; Identifying Where the Range Starts and Ends When No Start or End Point Is Known; Try It
|
505 |
0 |
|
|a Lesson RequirementsHints; Step-by-Step; Lesson 9: Making Decisions with VBA; Understanding Logical Operators; AND; OR; NOT; Choosing Between This or That; If ... Then; If ... Then ... Else; If ... Then ... ElseIf; IIF; Select Case; Getting Users to Make Decisions; Message Boxes; Input Boxes; Try It; Lesson Requirements; Hints; Step-by-Step; Part III: Beyond the Macro Recorder: Writing Your Own Code; Lesson 10: Repeating Actions with Loops; What Is a Loop?; Types of Loops; Do ... While; Do ... Until; Do ... Loop While; Do ... Loop Until; While ... Wend; Nesting Loops; Try It; Lesson Requirements; Hints; Step-by-Step
|
505 |
0 |
|
|a Cover; Title Page; Copyright; Contents; Part I: Understanding the BASICs; Lesson 1: Introducing VBA; What Is VBA?; A Brief History of VBA; What VBA Can Do for You; Automating a Recurring Task; Automating a Repetitive Task; Running a Macro Automatically if Another Action Takes Place; Creating Your Own Worksheet Functions; Simplifying the Workbook's Look and Feel for Other Users; Controlling Other Office Applications from Excel; Liabilities of VBA; Try It; Lesson 2: Getting Started with Macros; Composing Your First Macro; Accessing the VBA Environment; Using the Macro Recorder; Running a Macro
|
505 |
0 |
|
|a The Macro Dialog BoxShortcut Key; Try It; Lesson Requirements; Hints; Step-by-Step; Lesson 3: Introducing the Visual Basic Editor; What Is the VBE?; How to Get Into the VBE; Understanding the VBE; Understanding Modules; Using the Object Browser; Exiting the VBE; Try It; Lesson 4: Working in the VBE; Toolbars in the VBE; Macros and Modules; Locating Your Macros; Understanding the Code; Editing a Macro with Comments and Improvements to the Code; Deleting a Macro; Inserting a Module; Renaming a Module; Deleting a Module; Locking and Protecting the VBE; Try It; Lesson Requirements; Hints
|
505 |
0 |
|
|a Step-by-StepPart II: Diving Deeper into VBA; Lesson 5: Object-Oriented Programming: An Overview; What "Object-Oriented Programming" Means; The Object Model; Properties; Methods; Collections; Try It; Lesson 6: Variables, Data Types, and Constants; What Is a Variable?; Assigning Values to Variables; Why You Need Variables; Data Types; Understanding the Different Data Types; Declaring a Variable for Dates and Times; Declaring a Variable with the Proper Data Type; Forcing Variable Declaration; Understanding a Variable's Scope; Local Macro Level Only; Module Level; Application Level; Constants
|
653 |
|
|
|a Electronic spreadsheets / fast
|
653 |
|
|
|a COMPUTERS / Desktop Applications / Spreadsheets / bisacsh
|
653 |
|
|
|a Microsoft Visual Basic for applications
|
653 |
|
|
|a Tableurs
|
653 |
|
|
|a Microsoft Excel (Computer file) / http://id.loc.gov/authorities/names/n86025775
|
653 |
|
|
|a Business / Computer programs / fast
|
653 |
|
|
|a Microsoft Excel (Computer file) / fast
|
653 |
|
|
|a Business / Computer programs / http://id.loc.gov/authorities/subjects/sh85018263
|
653 |
|
|
|a Microsoft Visual Basic for applications / fast
|
653 |
|
|
|a Electronic spreadsheets / http://id.loc.gov/authorities/subjects/sh85042371
|
041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
989 |
|
|
|b OREILLY
|a O'Reilly
|
500 |
|
|
|a "Programmer to programmer"--Page 4 of cover. - Includes index
|
776 |
|
|
|z 1118991400
|
776 |
|
|
|z 1118991370
|
776 |
|
|
|z 9781118991404
|
776 |
|
|
|z 9781118991374
|
776 |
|
|
|z 1118991419
|
776 |
|
|
|z 9781118991411
|
856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781118991411/?ar
|x Verlag
|3 Volltext
|
082 |
0 |
|
|a 005.54
|
082 |
0 |
|
|a 330
|
520 |
|
|
|a Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined wit
|