Excel Programming Weekend Crash Course(tm)
- 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 2003
- 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
Table of Contents
PART I—Friday Evening.
SESSION 1–Microsoft Excel Programming—Why and How.
SESSION 2–The VBA Code Editor.
SESSION 3–The Excel Object Model.
SESSION 4–Syntax and Data in VBA.
PART II–Saturday Morning.
SESSION 6–Control Constructs.
SESSION 7–Procedures and Modules.
SESSION 8–Working with Dates and Times.
SESSION 9–Working with Text.
SESSION 10–Using Ranges and Selections.
PART III–Saturday Afternoon.
SESSION 11–Working with Columns, Rows, and Cells.
SESSION 12–Programming with Custom Formulas.
SESSION 13–Programming with Excel’s Built-In Functions.
SESSION 14–Formatting a Worksheet.
SESSION 15–Find and Replace Operations.
SESSION 16–Creating Custom Toolbars.
PART IV–Saturday Evening.
SESSION 17–Introduction to Charts.
SESSION 18–Advanced Charting Techniques.
SESSION 19–Creating Custom Dialog Boxes with User Forms.
SESSION 20–Controls for User Forms.
PART V–Sunday Morning.
SESSION 21–Advanced User Form Techniques.
SESSION 22–A User Form Example.
SESSION 23–Working with Events.
SESSION 24–Security Considerations.
SESSION 25–Debugging and Distributing an Application.
SESSION 26–Defining and Using Custom Classes.
PART VI–Sunday Afternoon.
SESSION 27–Handling Runtime Errors.
SESSION 28–Database Tasks.
SESSION 29–Creating Add-Ins.
SESSION 30–Adding Online Help to Your Application.
Appendix A–Answers to Part Reviews.
Appendix B–What’s on the Web Site.
Sign up now »
- FTSenior Python DeveloperNSW
- FTOS Web Applications DeveloperNSW
- FT.NET - Sitecore Developer - Melbourne - PermNSW
- FTFlash / ActionScript Developer - ContractNSW
- FTJob Title: Mac Systems/ Enterprise Systems EngineerNZ
- FTSenior Python DeveloperNSW
- FTR&D EngineerSA
- FTLead Software EngineerSA
- FTQuality ManagerSA
- FTSenior Python Web Applications DeveloperNSW
In a sluggish economy, getting the best ROI on every IT dollar spent is the top priority for almost every business. Storage budgets in most IT environments continue to remain ...
"Suggesting that people's "purpose is to get information to flow through the ..."
Why change management doesn’t work
"Darn those pesky laws that get in the way of commercial exploitation ..."
Larry Page wants to see your medical records
"Instead of partitioning the device between corporate and personal data, another approach ..."
Dual-Persona Smartphones Not a BYOD Panacea
"Well that's a nice back-handed compliment isn't it? So now, finally, my ..."
After two-year hiatus, EFF accepts bitcoin donations again
"Actually, both Mobile App developers and CIOs should be blamed for it. ..."
CIOs struggle to deliver timely mobile business apps: survey
- AusCERT 2013: Users, cats more likely hack culprits than cyber-espionage: Trustwave
- AusCERT 2013: Home-electronics gear’s UPnP as insecure in Australia as rest of world: Metasploit
- AusCERT 2013: Big data skills help beat the bad guys, says HP
- Growing mobile malware threat swirls (mostly) around Android
- In pictures: AusCERT 2013 Day One