presents

National Seminars Group & Padgett Thompson
a division of Rockhurst University Continuing Education Center
Course Description

Advanced Microsoft® Excel For the Power User

Program Description		Who Should Attend
Workshop Agenda		Guarantee Dates/Locations, Pricing, Register
What You’ll Learn

Program Description

Now that you have the handle on Excel, push its potential to the max. Harness the full power of a VBA macro. Learn the Visual Basic for Applications language used by Excel and streamline a series of actions into a single command. Plus, get even more advanced techniques to analyze and share data.

What You’ll Learn

1. Use the Visual Basic Editor to make changes in existing macros
2. Streamline your access to your VBA modules with the VBE Project Explorer
3. Take a look inside the Code Window
4. Create interactive macros
5. Pause your macro to allow for user input
6. Create a new macro with the Visual Basic Editor
7. Customize your dialog sheets with text boxes, radio buttons and dropdown lists
8. Add Logic power to your macros with the If/Then command
9. Debug a macro with the Step feature
10. Turn your Excel workbook into a Web page and download data from an Internet site using a Web query
11. Combine data from multiple users by setting up a shared workbook
12. Use the AutoFilter and Advanced Filter to display information you need
13. Plus, get the most advanced tips and tricks for the true power user
    

Who Should Attend

• Intermediate users who know the basics but want to learn how to make the most of Excel's features and functions

• Self-taught users who want to push their skills to the next level

• Advanced users who are eager to learn additional shortcuts and tips that will boost their speed and productivity in Excel

Your Guarantee of Complete Satisfaction

We stand behind our seminars with a 100 percent , iron-clad, money-back guarantee of satisfaction. If for any reason you’re not completely satisfied with the solid skills, the tips, tools and shortcuts, and the crucial information you receive during this workshop, we’ll refund your money in full. Every penny. Guaranteed!

Program Hours:
9:00 a.m. to 4:00 p.m. Registration begins at
8:30 a.m.

Group Discount: When 3 enroll from your organization, a 4th attends FREE!

Lunch:
Lunch is on your own.

Continuing Education:
Continuing education credits may be recognized by your professional board. Contact your own board to find out what's required. If you cancel your registration up to five business days before the workshop,

Bring a seminar to your site! For information about bringing a course to your site please call 1-919-847-0331 or email the registry at .

If this course or the dates/locations below do not have what you are looking for, then click here and we will find it for you right away. It will save you a lot of time and energy finding it yourself.

** Register Online**

Select date/location from list box below (Use side arrow to scroll). Complete form and click on 'Send'
This seminar is offered onsite only

Title:	Mr. Mrs. Ms
Fields with an "*" are required input.
* Attendee Name:
Position:
* E-Mail:
Company:
* Address 1:
Address 2:
* City:
* State/Province:
* Zip/Postal Code:
Country:
* Phone:
* Fax:
* Contact first and last name:
Approving supervisor first and last name:
	Click here to add more attendees.
Dollar Amount of Transaction: (Please add appropriate sales tax if in SD or WV.)
Payment Information
	Invoice Me, or
	Credit Card Info:
Credit Card Type:	American Express VISA Mastercard
Credit Card Number:
Expiration Date:
Name on Card:
PO # (if applicable):
Tax Exempt #:
Additional Attendees:	Use for listing additional attendees only.
Attendee 2 Name:
Attendee 3 Name:
Attendee 4 Name: (4th is FREE when you register 3)
Attendee 5 Name:
Attendee 6 Name:
Attendee 7 Name:
Attendee 8 Name: (8th is FREE when you register 7)

Additional Information:

National Seminars Group will e-mail confirmation soon. If you are not paying via credit card, you will receive an invoice with payment instructions.

Cancellation Policy:
If you cannot attend a workshop for which you are registered, you may send a substitute or receive a credit memo toward a future workshop. If you cancel your registration up to five business days before the workshop, your registration fee will be refunded less a $10 enrollment charge.

You can also register by emailing your registration information to us at or calling us at 919-847-0331. Please mention the meeting number specified above and BE SURE TO STATE VIP CODE "919-120001-000 -- Training Registry".