WORKSHOP BISM 401Excel Macros and VBA: Level 1 – Data Input

Connected Workshop Series

This workshop is part 1 of a three part workshop series that works towards an increased understanding of Data Input, Data Analysis, as well as Formulas and Functions to facilitate better workplace applications.

Data Input

Learn to use Excel features that enhance the input of data and learn to create Excel Macros from the ground up. Emphasis is on the creation of input forms that use Excel’s Data Validation features and Absolute versus Relative Macro Recording capabilities. Create worksheet interface controls to enable end users to direct, control or abort macro processing. Learn to hide and protect worksheets and macro code.

BISM 401 is a pre-requisite for both BISM 402 and BISM 403

1. Streamline Input by using Excel’s “Data Entry” Features

• Use AutoFill to Create a Data Series or Quickly Copy Data
• Use Data Validation to Validate Data Input and to Identify Invalid Data

2. Record and Run a Macro; Manage Generated VBA Code and Macro Security

• Record a Macro, Run it; Examine its Code
• Macro Comments and Macro Run Options
• Generate Absolute or Relative Cell References
• Set Macro Security to Medium to Enable Macros

3. Make More Extensive Use of the Visual Basic Editor (VBE)

• Record a “Personal Macro” and Remove Unwanted Code
• Create User Interface Message Boxes using the VBE
• Identify “Breakable Code” and Make it “Unbreakable”
• Use Worksheet Buttons to Simplify Macro Execution
• Further Explore the VBE Screen’s Components

4. Develop a Database Update Application and Protect What’s Created

• Compare Use of a “Sheet Form” to Excel’s UserForm
• Create Input Form and Macros to Implement a Database Update
• Hide Macros, Hide Sheets, Protect Sheets, Protect Workbook, Protect VBA Code

 

---

Note: Students who intend to take all 3 workshops should register using course code BISM 404 50 to receive the discount price of $577.72 for all three workshops.

Calendar

This course is offered through any of the following sections:

SECTION: 50 (Spring 2012)	SESSION	TIME	DAY	FREQUENCY	LOCATION
Saturday, June 2 (6 hours) Registration Deadline: June 2, 2012 PRICE: $197.57	Lab	8:30 am - 4:30 pm	Saturday	Once	North

Contact

Apply Now