|
E-mail Me
Syllabus
Schedule
Handouts
Assignments
All My Webs
Dept Home
|
Course Handouts and Notes
(Last Updated
October 21, 2003
)
- 394 Introduction, PowerPoint file
- First discussion on spreadsheets
- Database Tools
- Employee Files.txt, text file
to import
- VBA Intro, PowerPoint file
- VBA Day 2, PowerPoint
file
- Discussion on Visual Basic
for Applications (VBA)
- Functions and
Decisions, PowerPoint File
- Discussion on Flowcharting,
MS-Word 97 file
- Text Functions.xls,
an Excel spreadsheet with examples of 3 text functions
- Branching
and Looping, PowerPoint file.
- Text Use tutorial,
Flash file
- If-Then-Else tutorial,
Flash file
- Multiple Choice
tutorial, Flash file
- Do-Loop tutorial,
Flash file
- For-Next tutorial,
Flash file
- MsgBox tutorial, Flash
file
- Decisions.xls, an Excel spreadsheet
with examples on 4 types of decision structure.
- Events and Errors,
PowerPoint File
- Errors and Events.xls,
an Excel spreadsheet
- Dialog Boxes First Day,
PowerPoint file
- Dialog Box tutorial,
Flash file
- Dialog Boxes.xls, an
Excel spreadsheet with examples of MsgBox, GetOpenFile, and a custom
User Form.
- InClass 9-30-03.xls,
advnaced userform demo from class
- Check Box tutorial,
Flash file
- ComboBox tutorial,
Flash file
- RefEdit tutorial,
Flash file
- Option Button tutorial,
flash file
- First discussion on Excel
Macros
- Custom Functions,
PowerPoint file
- Custom Function.xls,
an Excel spreadsheet that demonstrates how to use custom functions and
perform look-ups.
- SayHi.xls, an Excel spreadsheet
that demonstrates how to use macros to add toolbar and menu items.
- VLookup tutorial,
Flash file
- Using Vlookup
in VBA tutorial, Flash file
- Find( ) tutorial, flash
file
- Group Assignments
- PowerPoint Presentations,
PowerPoint file
- Advanced Powerpoint,
PowerPoint file
- Flowchart tutorial,
Flash file
- First discussion on Access Databases
- Access Day 1, PowerPoint
program
- Access Day 2, PowerPoint
file covering simple reports and queries
- Access Day 3, PowerPoint
file covering Relationships and Subforms
- Access Day 4, a brief summary
of topics
- Access programming
- Discussion on Word features
- Discussion on Integration
- Discussion on Add-ins
- Discussion on Application design
|
