Excel Programming Weekend Crash Course (Weekend Crash Course)
Editorial Reviews
Book Description
Get up to speed on Excel programming in a weekend! The big day is Monday. That s when you get to show off what you know about Excel programming. The problem is, you re not really up to speed. Maybe it s been a while since you programmed Excel to create custom data processing solutions. Perhaps you ve just discovered Excel s adaptability. Or maybe you just like a challenge. In any event, we ve got a solution for you Excel Programming Weekend Crash Course. Open the book Friday evening and on Sunday afternoon, after completing 30 fast, focused sessions, you ll be able to dive right in and start programming and automating Excel. It s as simple as that. The Curriculum Friday Evening: 4 Sessions, 2 Hours Microsoftandreg; Excel and Programming Why and How The VBA Code Editor The Excel Object Model Syntax and Data in VBA Saturday Morning: 6 Sessions, 3 Hours Operators Control Constructs Procedures and Modules Working with Dates and Times Working with Text Using Ranges and Selections Afternoon: 6 Sessions, 3 Hours Working with Columns, Rows, and Cells Programming with Custom Formulas Programming with Excel's Built-In Functions Formatting a Worksheet Find and Replace Operations Creating Custom Toolbars Saturday, cont. Evening: 4 Sessions, 2 Hours Introduction to Charts Advanced Charting Techniques Creating Custom Dialog Boxes with User Forms Controls for User Forms Sunday Morning: 6 Sessions, 3 Hours Advanced User Form Techniques A User Form Example Working with Events Security Considerations Debugging and Distributing an Application Defining and Using Custom Classes Afternoon: 4 Sessions, 2 Hours Handling Runtime Errors Database Tasks Creating Add-Ins Adding Online Help to Your Application
Download Description
* Thirty 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 minutes
* Applicable to Excel 2000, Excel 2002, and the latest release, Excel "X"
* Helps Excel power users in fields such as accounting, finance, operations management, and market research to begin automating data manipulation in Excel quickly, so they can handle real-world projects
* A how-to guide to using Excel's programmability to create custom data-processing and analysis solutions
* Covers security, debugging, and error handling
* Companion Web site includes sample files, projects, and test enginewith self-assessment exam
Excel Programming Weekend Crash Course (Weekend Crash Course)
Excel Programming Weekend Crash Course (Weekend Crash Course),Peter G. Aitken,Wiley,0764540629,Business,Computer Bks - Spreadsheets,Computer Books: General,Computer programs,Computer software,Computers,Electronic spreadsheets,Microcomputer Spreadsheet Software,Microsoft Excel (Computer file,Programming,Programming - General,Spreadsheets - Excel,Spreadsheets - General,Computers / Spreadsheets / General,Excel
Hot Books:
Recommended Books