LEADER 05731nam 2200781 a 450 001 9910953881003321 005 20230105192843.0 010 $a9781118490402 010 $a1118490401 010 $a9781118491805 010 $a1118491807 035 $a(CKB)2670000000341484 035 $a(EBL)1144767 035 $a(OCoLC)831119167 035 $a(SSID)ssj0000906980 035 $a(PQKBManifestationID)11496073 035 $a(PQKBTitleCode)TC0000906980 035 $a(PQKBWorkID)10856043 035 $a(PQKB)10932075 035 $a(OCoLC)847729041 035 $a(Au-PeEL)EBL1144767 035 $a(CaPaEBR)ebr10674764 035 $a(CaONFJC)MIL531259 035 $a(CaSebORM)9781118490402 035 $a(MiAaPQ)EBC1144767 035 $a(OCoLC)877823240 035 $a(OCoLC)ocn877823240 035 $a(Perlego)1003838 035 $a(EXLCZ)992670000000341484 100 $a20130419d2013 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel 2013 power programming with VBA /$fby John Walkenbach 205 $a1st edition 210 $aHoboken, N.J. $cWiley$dc2013 215 $a1 online resource (1107 p.) 225 1 $aMr. Spreadsheet's Bookshelf 300 $aIncludes index. 311 08$a9781118490396 311 08$a1118490398 327 $aMicrosoft® Excel® 2013 Power Programming with VBA; Introduction; Topics Covered; What You Need to Know; What You Need to Have; Conventions in This Book; What the Icons Mean; How This Book Is Organized; About This Book's Website; About the Power Utility Pak Offer; How to Use This Book; Part 1: Some Essential Background; Chapter 1: Excel in a Nutshell; About Excel; Thinking in Terms of Objects; Workbooks; Excel's User Interface; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features 327 $aAnalysis ToolsAdd-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 2: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Excel Auditing Tools; Array Formulas; Counting and Summing Techniques; Lookup Formulas; Working with Dates and Times; Creating Megaformulas; Chapter 3: Understanding Excel Files; Starting Excel; File Types; Excel File Compatibility; Protected View; Using AutoRecover; Working with Template Files; Inside an Excel File; The OfficeUI File; The XLB File; Add-In Files 327 $aExcel Settings in the RegistryChapter 4: Essentials of Spreadsheet Application Development; What Is a Spreadsheet Application?; Steps for Application Development; Determining User Needs; Planning an Application That Meets User Needs; Determining the Most Appropriate User Interface; Concerning Yourself with the End User; Other Development Issues; Part 2: Understanding Visual Basic for Applications; Chapter 5: Introducing Visual Basic for Applications; Getting Some BASIC Background; Delving into VBA; Covering the Basics of VBA; Introducing Visual Basic Editor; Working with Project Explorer 327 $aWorking with Code WindowsCustomizing the VBE Environment; The Macro Recorder; About Objects and Collections; Properties and Methods; The Comment Object: A Case Study; Some Useful Application Properties; Working with Range Objects; Things to Know about Objects; Chapter 6: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments; Variables, Data Types, and Constants; Assignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 7: Working with VBA Sub Procedures 327 $aAbout ProceduresExecuting Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 8: Creating Function Procedures; Sub Procedures versus Function Procedures; Why Create Custom Functions?; An Introductory Function Example; Function Procedures; Function Arguments; Function Examples; Emulating Excel's SUM function; Extended Date Functions; Debugging Functions; Dealing with the Insert Function Dialog Box; Using Add-ins to Store Custom Functions; Using the Windows API; Chapter 9: VBA Programming Examples and Techniques 327 $aLearning by Example 330 $aMaximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, ""Mr. Spreadsheet"" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic f 410 0$aMr. Spreadsheet's bookshelf. 517 1 $aMicrosoft Excel 2013 power programming with VBA 517 3 $aExcel power programming with VBA 606 $aBusiness$xComputer programs 606 $aElectronic spreadsheets 606 $aElectronic spreadsheets$xComputer programs 615 0$aBusiness$xComputer programs. 615 0$aElectronic spreadsheets. 615 0$aElectronic spreadsheets$xComputer programs. 676 $a650.02855365 700 $aWalkenbach$b John$061459 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910953881003321 996 $aExcel 2013 power programming with VBA$94360327 997 $aUNINA LEADER 04121nam 22005415 450 001 9910742490703321 005 20251009071938.0 010 $a9789819939664 010 $a9819939666 024 7 $a10.1007/978-981-99-3966-4 035 $a(MiAaPQ)EBC30719846 035 $a(Au-PeEL)EBL30719846 035 $a(DE-He213)978-981-99-3966-4 035 $a(CKB)28044422000041 035 $a(OCoLC)1395182918 035 $a(EXLCZ)9928044422000041 100 $a20230823d2023 u| 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aApplied Cognitive Science and Technology $eImplications of Interactions Between Human Cognition and Technology /$fedited by Sumitava Mukherjee, Varun Dutt, Narayanan Srinivasan 205 $a1st ed. 2023. 210 1$aSingapore :$cSpringer Nature Singapore :$cImprint: Springer,$d2023. 215 $a1 online resource (261 pages) 311 08$aPrint version: Mukherjee, Sumitava Applied Cognitive Science and Technology Singapore : Springer,c2023 9789819939657 327 $aTowards Behavioral AI: Cognitive factors underlying the public psychology of artificial intelligence -- Defining the Relationship Between Level of Autonomy in a Computer and Cognitive Workload of its User -- Cognitive effects of anthropomorphization of artificial agents in human-agent interactions -- Psychological Factors Driving Adoption of Decision Support Tools -- Model-based operator assistance: How to match engineering models with humans? cognitive representations of their actions? -- Behavioral cyber-security: Influence of availability of information about opponent?s actions on decision-making in markov-security games -- Exploring Cybercriminal Activities, Behaviours and Profiles -- Computer Vision Technology: Do Deep Neural Networks Model Nonlinear Compositionality in the Brain?s Representation of Human-Object Interactions? -- Evaluation of different deep reinforcement learning algorithms in complex search-and-retrieve virtual simulation against human performance -- Cognate Identification to Augment Lexical resources for NLP -- Psychophysiological Monitoring to Improve Human-Computer Collaborative Tasks -- Human-Technology interfaces: Did ?I? do it? Agency, Control and why it matters -- Effects of Analogies and Analogical Distance on Ideation in Conceptual Phase of Engineering Design -- Humiliation and Technology: Dilemmas and Challenges for State, Civil Society and Industry.-Technology: Does It Help or Harm Intelligence?or Both?. 330 $aThis book fills the long-pending gap in consolidating research on applied cognitive science and technology. It explores the broader implications of interactions between human cognition and technology by touching upon artificial intelligence (AI) and artificial agents, decision support and assistance support systems, cybersecurity threats, computational modeling of cognition through artificial neural networks and machine learning, human factors, engineering design, and social media interfaces. With an interdisciplinary scope that addresses psychological and technological issues, this unique book shows how cognitive science is furthered by technology(or platforms) while simultaneously illustrating how the study of cognitive processes is helping shape technological products. Accordingly, it offers a valuable resource for researchers and practitioners in a broad array of fields, such as psychology, science, engineering and management. 606 $aCognition 606 $aIntellect 606 $aCognition 606 $aIntelligence 615 0$aCognition. 615 0$aIntellect. 615 14$aCognition. 615 24$aIntelligence. 676 $a620.82 700 $aMukherjee$b Sumitava$01425228 701 $aDutt$b Varun$01425229 701 $aSrinivasan$b Narayanan$01425230 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910742490703321 996 $aApplied Cognitive Science and Technology$93555464 997 $aUNINA