Excel Programming Weekend Crash Course

Product 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

From the Back Cover
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
Microsoft® 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
Mirror
Readme
Password default : booktraining.net