Search:

Excel 2023 : the complete book to successfully conquer Microsoft Excel from scratch in less than 7 minutes a day : discover all the features & formulas with step-by-step tutorials / by Ledger, Leonard J.,author.;
Follow step-by-step instructions and master Excel
Subjects: Microsoft Excel (Computer file); Electronic spreadsheets; Business; Tableurs;
Available copies: 1 / Total copies: 1
unAPI

Excel VBA programming / by Kusleika, Dick,author.(CARDINAL)609555;
Starting Excel VBA programming. Getting to know VBA ; Building simple macros -- Employing VBA with Excel. Working in the Visual Basic Editor ; Introducing the Excel object model ; VBA sub and function procedures ; Using the Excel macro recorder -- Programming concepts. Essential VBA language elements ; Working with range objects ; Using VBA and worksheet functions ; Controlling program flow and making decisions ; Automatic procedures and events ; Error-handling techniques ; Bug extermination techniques ; VBA programming examples -- Communicating with your users. Simple dialog boxes ; UserForm basics ; Using UserForm controls ; UserForm techniques and tricks ; Accessing your macros through the user interface -- Putting it all together. Creating worksheet functions ; Creating Excel add-ins -- The part of tens. Ten handy Visual Basic Editor tips ; Resurces for VBA help ; Ten VBA do's and don'ts."Find out what Excel is capable of with this step-by-step guide to VBA. Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software. Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to: Understand the basic tools and operations of Visual Basic for Applications; Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets; Deal with errors and exceptions and eliminate the bugs in your code. Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language"--Publisher's description.
Subjects: Instructional and educational works.; Handbooks and manuals.; Microsoft Excel (Computer file); Visual Basic for Applications (Computer program language); Electronic spreadsheets.; Business; Tableurs.;
Available copies: 3 / Total copies: 3
unAPI

Microsoft 365 Excel VBA programming / by Kusleika, Dick,author.(CARDINAL)609555;
Introduction -- PART 1: Starting Excel VBA programming. Getting to know VBA ; Building simple macros -- PART 2: Using VBA with Excel. Working in the visual basic editor ; Introducing the Excel object model ; VBA sub and function procedures -- PART 3: Creating code automatically. Using the Excel macro recorder ; Generating code with Copilot -- PART 4: Programming concepts. Essential VBA language elements ; Working with range objects ; Using VBA and worksheet functions ; Controlling program flow and making decisions ; Automatic procedures and events ; Error-handling techniques ; Bug extermination techniques ; VBA programming examples -- PART 5: Communicating with your users. Simple dialog boxes ; UserForm basics ; Using UserForm controls ; UserForm techniques and tricks ; Accessing your macros through the user interface -- PART 6: Putting it all together. Creating worksheet functions ; Creating Excel add-ins -- PART 7: The part of tens. Ten handy visual basic editor tips ; Resources for VBA help ; Ten VBA do's and don'ts."Fully updated for the latest version of Office 365, Excel VBA Programming For Dummies will take your Excel knowledge to the next level. With a little background in Visual Basic for Applications (VBA) programming, you can go well beyond basic spreadsheets and functions. Learn the coding basics and syntax you need to write simple or complex macros that can automate your routine Excel tasks. Become an Excel power user by automating data management, user forms, pivot tables, and beyond. When you use VBA to perform Excel operations, you can reduce errors, save time, and integrate with other Microsoft applications. This handy guide also teaches you how to control the security settings for your macros and save macros to use across files and apps. Plus, you'll get updated coverage of Copilot AI integration. Your spreadsheets are about to get much more powerful. " --
Subjects: self-instructional materials.; handbooks.; Self-instructional works.; Handbooks and manuals.; Matériel d'auto-enseignement.; Guides et manuels.; Microsoft Excel (Computer file); Visual Basic for Applications (Computer program language); Electronic spreadsheets.; Business; Tableurs.; COMPUTERS / Programming / Microsoft Programming.; COMPUTERS / Business & Productivity Software / Spreadsheets.; COMPUTERS / Business & Productivity Software / Office Suites.;
Available copies: 2 / Total copies: 2
unAPI