Excel Programming Weekend Crash Course

Excel Programming Weekend Crash Course

by Peter G. Aitken
     
 

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

See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780764540622
Publisher:
Wiley
Publication date:
09/23/2003
Series:
Weekend Crash Course Series, #7
Pages:
456
Product dimensions:
7.46(w) x 9.18(h) x 1.03(d)

Related Subjects

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >