{"product_id":"mastering-ideascript-with-website-the-definitive-guide-paperback-softback-9781118004487","title":"Mastering IDEAScript, with Website; The Definitive Guide (Paperback \/ softback) 9781118004487","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eMastering IDEAScript, with Website\u003c\/font\u003e\u003cbr\u003e\r\n\u003cfont size=\"5\"\u003eThe Definitive Guide\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\u003cp\u003e\u003cfont size=\"4\"\u003e (Author), John Paul Mueller (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781118004487, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 15 April 2011\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e504 pages, Screen captures: 198 B\u0026amp;W, 0 Color\u003cbr\u003e23.6 x 18.9 x 2.7 cm, 0.762 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003eWith approximately 44,000 users in the U.S. and Canada, as well as 42,000 in Europe, IDEA software has become a leading provider of data analysis software for use by auditors and accountants. Written to provide users with a quick access guide for optimal use of IDEAScript, \u003ci\u003eMastering IDEAScript: The Definitive Guide\u003c\/i\u003e is IDEA's official guide to mastering IDEAScript, covering essential topics such as Introducing IDEAScript, Understanding the Basics of IDEAScript Editor, Designing Structured Applications, Understanding IDEA Databases and much more. For auditors, accountants and controllers.\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePreface.  \u003cp\u003eAcknowledgments.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Introducing IDEAScript.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Automation.\u003c\/p\u003e \u003cp\u003eUnderstanding How You Use Macros.\u003c\/p\u003e \u003cp\u003eHaving Things Your Way.\u003c\/p\u003e \u003cp\u003eConsidering Your Skills.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Creating Your First IDEAScript Application.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Macro Types.\u003c\/p\u003e \u003cp\u003eOpening the Visual Script Editor.\u003c\/p\u003e \u003cp\u003eWriting a Hello World Application.\u003c\/p\u003e \u003cp\u003eBuilding Your Application.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Understanding the Basics of the IDEAScript Editor.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWorking with Windows.\u003c\/p\u003e \u003cp\u003eHiding and Viewing Windows.\u003c\/p\u003e \u003cp\u003eWorking with Menus and Toolbars.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Designing Structured Applications.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Parts of an Application.\u003c\/p\u003e \u003cp\u003eMethods You Use to Create an Application.\u003c\/p\u003e \u003cp\u003eUsing the Macro Recorder.\u003c\/p\u003e \u003cp\u003eWorking with Subs and Functions.\u003c\/p\u003e \u003cp\u003eMaking Your Code Easy to Read.\u003c\/p\u003e \u003cp\u003eAdding Your Application to a Toolbar or Menu.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Working with Data.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Variables and Constants.\u003c\/p\u003e \u003cp\u003eChoosing a Data Type.\u003c\/p\u003e \u003cp\u003eEmploying Operators.\u003c\/p\u003e \u003cp\u003eFormatting Data.\u003c\/p\u003e \u003cp\u003eCreating Custom Data Types.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Using Conditional Statements and Loops.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMaking Decisions Using the If…Then…Else Statement.\u003c\/p\u003e \u003cp\u003eChoosing between Options Using Select Case.\u003c\/p\u003e \u003cp\u003ePerforming Tasks a Specific Number of Times with For…Next.\u003c\/p\u003e \u003cp\u003ePerforming Tasks Using Conditions with Do Loop.\u003c\/p\u003e \u003cp\u003eAdding Error Trapping to Your Application.\u003c\/p\u003e \u003cp\u003eRedirecting Macro Flow Using GoTo.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: Understanding IDEA Databases.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the Parts of a Database.\u003c\/p\u003e \u003cp\u003eAn Overview of the IDEA Database System.\u003c\/p\u003e \u003cp\u003eOpening a Database for Use.\u003c\/p\u003e \u003cp\u003eChecking the Database History.\u003c\/p\u003e \u003cp\u003eObtaining Field Statistics.\u003c\/p\u003e \u003cp\u003eSetting Database Criteria.\u003c\/p\u003e \u003cp\u003eIndexing a Database.\u003c\/p\u003e \u003cp\u003eSorting a Database.\u003c\/p\u003e \u003cp\u003eModifying Database Comments.\u003c\/p\u003e \u003cp\u003eCommitting the Database.\u003c\/p\u003e \u003cp\u003eClosing a Database.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Working with Databases.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdding One Database to Another Using Append Database.\u003c\/p\u003e \u003cp\u003eComparing Two Databases Using CompareDB.\u003c\/p\u003e \u003cp\u003eWorking with Keys.\u003c\/p\u003e \u003cp\u003eExporting a Database Using ExportDatabase.\u003c\/p\u003e \u003cp\u003eWorking with Fields Using Field.\u003c\/p\u003e \u003cp\u003eWorking with Records.\u003c\/p\u003e \u003cp\u003eWorking with Tables.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9: Considering the CaseWare IDEA Object Model.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the IDEA Object Model.\u003c\/p\u003e \u003cp\u003eWorking with the Task Object Model.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10: Performing Mathematical Tasks.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePerforming Basic Math.\u003c\/p\u003e \u003cp\u003eUsing Advanced Math.\u003c\/p\u003e \u003cp\u003eEmploying Analysis.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11: Interacting with Arrays.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding How Arrays Work.\u003c\/p\u003e \u003cp\u003eCreating and Using Arrays.\u003c\/p\u003e \u003cp\u003eCopying Data between Arrays.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12: Creating Interactive Dialog Boxes.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating Great Dialog Boxes.\u003c\/p\u003e \u003cp\u003eUsing the Basic Controls.\u003c\/p\u003e \u003cp\u003eObtaining the Visual Appearance You Want.\u003c\/p\u003e \u003cp\u003eInteracting with Dialog Boxes Using Code.\u003c\/p\u003e \u003cp\u003eAdding Pictures to Your Dialog Boxes.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13: Locating Information in Databases.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePerforming Searches Efficiently.\u003c\/p\u003e \u003cp\u003eUsing the Built-in Search Features.\u003c\/p\u003e \u003cp\u003eCreating a Custom Search.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14: Importing and Exporting Data.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the Import\/Export Features.\u003c\/p\u003e \u003cp\u003ePerforming Data Extractions.\u003c\/p\u003e \u003cp\u003eManaging PDF Data.\u003c\/p\u003e \u003cp\u003eManaging Text Data.\u003c\/p\u003e \u003cp\u003eManaging Excel Data.\u003c\/p\u003e \u003cp\u003eManaging Access Data.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15: Working with Files.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the File Format.\u003c\/p\u003e \u003cp\u003eUsing the File IO Features.\u003c\/p\u003e \u003cp\u003eUsing External Variables\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16: Working with Other Applications.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering IDEAScript and Visual Basic for Applications (VBA) Differences.\u003c\/p\u003e \u003cp\u003eUnderstanding the Word and Excel Object Models.\u003c\/p\u003e \u003cp\u003eRunning Word from IDEA.\u003c\/p\u003e \u003cp\u003eRunning IDEA from Excel.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17: Performing Data Analysis Tasks.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePerforming Stratification.\u003c\/p\u003e \u003cp\u003ePerforming Summarization.\u003c\/p\u003e \u003cp\u003eCreating a Pivot Table.\u003c\/p\u003e \u003cp\u003eEmploying Random Record Sampling Using RandomSample.\u003c\/p\u003e \u003cp\u003ePerforming Gap Detection.\u003c\/p\u003e \u003cp\u003eChecking Distribution Using SystematicSample.\u003c\/p\u003e \u003cp\u003eMerging Databases.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18: Working with Charts and Graphs.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChoosing the Correct Chart or Graph.\u003c\/p\u003e \u003cp\u003eCreating a Basic Graph.\u003c\/p\u003e \u003cp\u003eDefining Analytical Charts.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19: Defining Reports.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefining a Report.\u003c\/p\u003e \u003cp\u003eOutputting Data in PDF Format.\u003c\/p\u003e \u003cp\u003eOutputting Data in Word Format.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20: Considering Database Security.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering Programmatic Data Security.\u003c\/p\u003e \u003cp\u003eChoosing the Correct Data Type.\u003c\/p\u003e \u003cp\u003eValidating Data.\u003c\/p\u003e \u003cp\u003eProtecting Dialog Boxes.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21: Debugging Your Application.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Kinds of Application Errors.\u003c\/p\u003e \u003cp\u003eRunning and Stopping the Application.\u003c\/p\u003e \u003cp\u003eUsing Breakpoints.\u003c\/p\u003e \u003cp\u003eStepping through the Application.\u003c\/p\u003e \u003cp\u003eUsing the Watch Window.\u003c\/p\u003e \u003cp\u003eRelying on Message Boxes.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 22: Performing Project Management Tasks.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating a Plan for Your Application.\u003c\/p\u003e \u003cp\u003eKeeping Track of Application Files.\u003c\/p\u003e \u003cp\u003eWorking within a Group.\u003c\/p\u003e \u003cp\u003eDocumenting Your Application.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 23: Converting Visual Script to IDEAScript.\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eConsidering the Benefits of Using IDEAScript.\u003c\/p\u003e \u003cp\u003ePerforming the Conversion.\u003c\/p\u003e \u003cp\u003eMaking Changes and Saving the Result.\u003c\/p\u003e \u003cp\u003eSummary.\u003c\/p\u003e \u003cp\u003eAbout the Author.\u003c\/p\u003e \u003cp\u003eAbout the Website.\u003c\/p\u003e \u003cp\u003eIndex.\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Finance \u0026amp; accounting [\u003ca title=\"See our other books on Finance \u0026amp; accounting\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Finance%20\u0026amp;%20accounting%20%5BKF%5D%22\"\u003eKF\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wiley","offers":[{"title":"Brand New","offer_id":52417745355032,"sku":"9781118004487","price":149.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781118004487.jpg?v=1784506171","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/mastering-ideascript-with-website-the-definitive-guide-paperback-softback-9781118004487","provider":"Freshly Printed Books","version":"1.0","type":"link"}